Unterminated string constant

[jmurrayhead]

I receive the following error from this string:

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?

 

[CajunCenturion]

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

 

[jmurrayhead]

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