ErRoR

[hoog]

Can you help me check what is this errors?



Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

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

/up.asp, line 46




<%
if request.form(&quot;password&quot <> request.form(&quot;pwd&quot then

Dim adoCon , adoRec ' ADO connection object
Dim ConnString
Dim myNameID, myUserID, myPwd, myPass, myYr, myEmail, SQL

myUserID = Request.Form (&quot;text&quot
myPwd = Request.Form (&quot;pwd&quot
myPass=Request.Form (&quot;password&quot


Set adoCon = Server.CreateObject(&quot;ADODB.Connection&quot
Set adoRec=server.CreateObject (&quot;ADODB.Recordset&quot
ConnString=&quot;driver={sql server};server=o6f2e1;database=user;DSN=localserver;PWD=;UID=sa;&quot;
adoCon.Open ConnString

adoRec.ActiveConnection = adoCon

SQL=&quot;UPDATE info &quot; & _
&quot;SET password='&quot; & myPwd & &quot;' &quot; & _
&quot;WHERE UserID='&quot; & myUserID & &quot;', &quot; & _
&quot;password='&quot; & myPass & &quot;'&quot;

line 46 adoCon.Execute(SQL)


adoCon.Close
Set adoCon = Nothing

Response.Redirect (&quot;Success.asp&quot
response.write (&quot;password and confirm passworddoent match&quot

else

response.write (&quot;password matchs&quot

%>

thanks...

 

[SrinuReddy]

Use:

SQL=&quot;UPDATE info &quot; & _
&quot;SET password='&quot; & myPwd & &quot;' &quot; & _
&quot;WHERE UserID='&quot; & myUserID & &quot;' and &quot; & _
&quot;password='&quot; & myPass & &quot;'&quot;

There should not be any comma(,) in where clause...

srinu...