ke hay mal en este update

[rashid]

ChRegSQL = ""
ChRegSQL = ChRegSQL & " UPDATE auctions SET "
ChRegSQL = ChRegSQL & " ItemTitle = " & SQLStr(sItemTitle) & ", "
ChRegSQL = ChRegSQL & " WHERE ItemID = " & SQLVal(iItemID) &";"

GobjConnect.Execute ChRegSQL
Response.Write("<TR><TD COLSPAN=""2"">")
Response.Write ChRegSQL
Response.Write("Your property has been successfully updated.<P>")
Response.Write("<A HREF=""default.asp"">Click here</A> to go to the TropicalEstate homepage.<P>")
Response.Write("</TD></TR>")


El error es:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[TCX][MyODBC]You have an error in your SQL syntax near 'WHERE ItemID = 22' at line 1


el response. write me da:
UPDATE auctions SET ItemTitle = 'casa de socalo', WHERE ItemID = 22;Your property has been successfully updated.


Gracias!

[urjose]

ChRegSQL = ""
ChRegSQL = ChRegSQL & " UPDATE auctions SET "
ChRegSQL = ChRegSQL & " ItemTitle = '" & SQLStr(sItemTitle) & "', "
ChRegSQL = ChRegSQL & " WHERE ItemID = " & SQLVal(iItemID) &";"

[rashid]

gracias jose, pero creo que eso tampoco me hubiese corrido por ke el problem estaba en la coma antes del were
ChRegSQL = ChRegSQL & " ItemTitle = '" & SQLStr(sItemTitle) & "', "



Pero gracias m estro!