Regarding an error

[sanika1507]

I m getting an error in this line

rs.open ExportSql, c,adOpenStatic,adLockReadOnly,adCmdTxt

any problme with this . can any one help me out ,
the error is


LogTime = 11/6/2007 9:19:26 AM
ASPCode =
ASPDescription =
Category = Microsoft OLE DB Provider for SQL Server
Column = -1
Description = Line 1: Incorrect syntax near '='.
File = /scripts/san/table/try.asp
Line = 386
Number = -2147217900
Source =
-----------------------


thanks in advance

[markrawlingson]

Sounds like a problem with your SQL statement.

Write out your SQL statement on the page so you can see what it actually says and what you're actually trying to tell SQL server to do.

Response.Write ExportSQL
 

If the answer isn't evident after doing that... Show the SQL statement that you are using, and also show us the textual output of the SQL statement after you response.write it out on the page.

Sincerely,
Mark

[sanika1507]

Sounds like a problem with your SQL statement.

Write out your SQL statement on the page so you can see what it actually says and what you're actually trying to tell SQL server to do.

Response.Write ExportSQL
 

If the answer isn't evident after doing that... Show the SQL statement that you are using, and also show us the textual output of the SQL statement after you response.write it out on the page.

Sincerely,
Mark

I am still getttin the same Error on Page nad the same above errror in the errorlog file,


ExportSql = "cp.dbo.spCode"_
& "@BCode=" & dbQuoteOrNull(sBCode) & " ,"_
& "@F_Ind =" & dbQuoteOrNull(bF_Ind) & " ," _
& "@S_Ind=" & dbQuoteOrNull(bS_Ind)& " ," _
& "@Active =" & dbQuoteOrNull(bActive) & " ," _
& "@ACF=" & dbQuoteOrNull(bACF)& " ," _
& "@BaseInd =" & dbQuoteOrNull(bBaseInd) & " ," _
& "@MHN=" & dbQuoteOrNull(bMHN)& " ," _
& "@SHEVHO=" & dbQuoteOrNull(bSHEVHO)


rs.open ExportSql, c,adOpenStatic,adLockReadOnly,adCmdTxt

PageCount = rs.pagecount
iTotalRecs = rs.recordcount

This is wht i have written and u asked me to put the response.write stmt. still im gettin the same error on page

[sanika1507]

I am still getttin the same Error on Page nad the same above errror in the errorlog file,


ExportSql = "cp.dbo.spCode"_
& "@BCode=" & dbQuoteOrNull(sBCode) & " ,"_
& "@F_Ind =" & dbQuoteOrNull(bF_Ind) & " ," _
& "@S_Ind=" & dbQuoteOrNull(bS_Ind)& " ," _
& "@Active =" & dbQuoteOrNull(bActive) & " ," _
& "@ACF=" & dbQuoteOrNull(bACF)& " ," _
& "@BaseInd =" & dbQuoteOrNull(bBaseInd) & " ," _
& "@MHN=" & dbQuoteOrNull(bMHN)& " ," _
& "@SHEVHO=" & dbQuoteOrNull(bSHEVHO)


rs.open ExportSql, c,adOpenStatic,adLockReadOnly,adCmdTxt

PageCount = rs.pagecount
iTotalRecs = rs.recordcount

This is wht i have written and u asked me to put the response.write stmt. still im gettin the same error on page

The output if i write the response.write(ExportSql)

cp.dbo.sp_Code@BCode=NULL ,@F_Ind =NULL ,@S_Ind=NULL ,@HIPC=NULL ,@Active =NULL ,@ACF=NULL ,@BaseInd =NULL ,@MHN=NULL ,@SHEVHO=NULL

what should be the possible error ???????

plus another thing i have noticed is after
rs.open ExportSql, c,adOpenStatic,adLockReadOnly,adCmdTxt

this stmt i m gettin the Application Error. i should actually get

cp.dbo.sp_Code@BCode=NULL ,@F_Ind =NULL ,@S_Ind=NULL ,@HIPC=NULL ,@Active =NULL ,@ACF=NULL ,@BaseInd =NULL ,@MHN=NULL ,@SHEVHO=NULL

So is there any problem with

rs.open ExportSql, c,adOpenStatic,adLockReadOnly,adCmdTxt

Please help
thanks in advance