Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unterminated string constant

Status
Not open for further replies.

jmurrayhead

Programmer
Feb 13, 2004
47
US
I receive the following error from this string:
Code:
Microsoft VBScript compilation error '800a0409' 

Unterminated string constant 

/test/validate.asp, line 28 

objRS.Open("UPDATE Users SET Password = " & chr(39) & CStr(Request.Form("NewPassword")) & " & chr(39) & WHERE UserName = " & chr(39) & CStr(Request.Form("UserName")) & chr(39) & "

any ideas on what's wrong?
 
The quotes don't match up. I've highlighted each string constant
objRS.Open(
"UPDATE Users SET Password = " &
chr(39) & CStr(Request.Form("NewPassword")) &
" & chr(39) & WHERE UserName = " &
chr(39) & CStr(Request.Form("UserName")) & chr(39) &
"

Also note that you have one of your chr(39) 'quotes' inside of a literal string.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
 
Any ideas what this means?

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'Execute'

/test/validate.asp, line 31


Here is line 31:

oConn.Execute(sSQL),,adexecutenorecords

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top