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!
