Can someone help me with a`set of eyes to look at this? I just can't see what I am missing..

-------
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
/admin/usedequip/update.asp, line 79

----

My Code:

<%
Dim strItemID
Dim strDescription
Dim strPrice
Dim strNotes
Dim strThumb
Dim strPhoto
strItemID = Trim(Request.Form("ItemID"))
strDescription = Trim(Request.Form("Description"))
strPrice = Trim(Request.Form("Price"))
strNotes = Trim(Request.Form("Notes"))
strThumb = Trim(Request.Form("Thumb"))
strPhoto = Trim(Request.Form("Photo"))

Dim objConn, objRS, strQuery
Dim strConn
set objConn = Server.CreateObject("ADODB.Connection")
strConn = "Data Source=catalog1;"
objConn.Open strConn
Set objRS = Server.CreateObject("ADODB.Recordset")
Set objRS.ActiveConnection = objConn

strQuery = "UPDATE usedequip001 SET Description = '"
strQuery = strQuery & strDescription
strQuery = strQuery & "', Price = "
strQuery = strQuery & strPrice
strQuery = strQuery & ", Notes = '"
strQuery = strQuery & strNotes
strQuery = strQuery & "', Thumb = '"
strQuery = strQuery & strThumb
strQuery = strQuery & "', Photo = "
strQuery = strQuery & strPhoto
strQuery = strQuery & " WHERE ItemID="
strQuery = strQuery & strItemID
strQuery = strQuery & ";"
objRS.Open strQuery
%>Thanks

Can you Response.Write your SQL Statement after it's been built and post it?

Hi Minaki


I'm not sure how I would response.write an UPDATE statement?

How would I do this..??

respone.write strQuery before the objRS.Open

Thanks-- Did it and it worked. I had a missing field. everything that was there was ok. It's what wasn't there.. That's why I couldn't see it and of course not knowing what fields are in my database, you would have no idea! But when I did a response.write on each item, it stuck out like a sore thumb. Saw just what was missing.

When I grow up, i wanna be just like you guys (and gals) @;-)


Thanks again..

Chip