Syntax error (missing operator) in query expression

I'm having trouble updating record set.  I get an syntax error on the id.

I request an querystring like this:  NO=request.querystring("id")

I load a content like this:
set adoRs = adoCn.Execute("Select * From Videos where id=" & NO)
and that works perfectly.

When I try to update the data I get an error.
This is the code for the update:
  sAuthor = Replace(Request.Form("AUTHOR"),"'","''")
  sTitle = Replace(Request.Form("TITLE"),"'","''")
  sContent = Replace(Request.Form("txtContent"),"'","''")
  adoCn.Execute "Update VIDEOS set DESCRIPTION='" & sContent & "', AUTHOR='" & sAuthor & "', TITLE='" & sTitle & "' where id= & NO &"'"
  end if
 
The error I get is:
Syntax error (missing operator) in query expression 'id= & NO &'.

Open in new window

GDB08Asked:
Who is Participating?
 
BadotzConnect With a Mentor Commented:
You have an unterminated string.
'' If NO is a nemeric field:
 
adoCn.Execute "Update VIDEOS set DESCRIPTION='" & sContent & "', AUTHOR='" & sAuthor & "', TITLE='" & sTitle & "' where id=" & NO
 
 
'' If NO is a text field:
 
adoCn.Execute "Update VIDEOS set DESCRIPTION='" & sContent & "', AUTHOR='" & sAuthor & "', TITLE='" & sTitle & "' where id='" & NO &"'"

Open in new window

0
 
Abiel de GrootCommented:
You have put the single comma in the wrong place. A string is put like this

Where No '" & sAuthor & "'

You have put this:

Where No "' & sAuthor & '" '<<< you need the single quote outside the double quotes.


Also... if AUTHOR is a number (int) Then do not put a single quote outside the double quotes. The single quote deliminates a string not a number.

A.
0
 
BadotzCommented:
@Jonbysoft: I sure don't see where the asker made that error.
0
 
BadotzCommented:
No worries - glad to help.
0
All Courses

From novice to tech pro — start learning today.