Error Message Help??

morpheus · April 28th, 2004, 01:49 PM

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.

Here is my update code that is getting the error

IF Request.Form("submit")="Save Changes" THEN
        SQLStr="SELECT * FROM ORNextIssue WHERE NextIssueID=" & Request.Form("ID")
        RS.Open SQLStr,Application("DBConn"),1 ,2 ,&H0001
        RS("NextIssueID")=Request.Form("ID")
        RS("Title")=Request.Form("Title")
        RS("Line1")=Request.Form("Line1")
        RS("Line2")=Request.Form("Line2")
        RS("Line3")=Request.Form("Line3")
        RS("Line4")=Request.Form("Line4")
        RS("Line5")=Request.Form("Line5")
        RS("Line6")=Request.Form("Line6")
        RS("Line7")=Request.Form("Line7")
        RS("Line8")=Request.Form("Line8")
        RS("Line9")=Request.Form("Line9")
        RS("Line10")=Request.Form("Line10")
        RS("AdDate")=Request.Form("AdDate")

        RS.Update
END IF

I used this code a dozen times and this is the only one I have a problem with.

I don't see what's wrong with it

happygv · April 28th, 2004, 10:58 PM

Try printing the Request.Form("ID")

I suspect it to be empty or no value coming with it. This error is because, you are trying to run an incomplete query .

To test that out, execute this alone at you database and see what error you get?
SELECT * FROM ORNextIssue WHERE NextIssueID=

So it is simeple that your ID doesnt come up to this page.

Cheers!

-Vijay G