my codes are under
------------------

<%if session("granted") = false then
        response.redirect("unauth.htm")
end if
ringname=request("ring_name")
desc=request("desc")
itemid=request("itemid")
dim objRS
set objRS = Server.CreateObject("ADODB.Recordset")
sql="update tblRings set name="&ringname&",desc="&desc&" where item_id = " &itemid
-->objRS.open sql,conn
objRS.close
set objRS=nothing
%>


when i check my query through response.write(sql)
its shows me
update tblRings set name=ring Ass,desc=gfhfhhfhfh where item_id = 9
whats wrong with this query pls help me
-----------
but my browser say

------------

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'ring Ass'.
/jewler/admin/update_ring.asp, line 12


Browser Type:
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)

Page:
POST 187 bytes to /jewler/admin/update_ring.asp

POST Data:
ring_name=ring+Ass&itemid=9&desc=gfhfhhfhfh&s1=on& s2=on&s3=on&s4=on&s5=on&s6=on&s7=on&s8=on&s9=on&s1 0=on&karat=&listing_data=6%2F10%2F2004+10%3A39%3A4 0+AM&price=222&opqty=22&Submit=Update

Time:
Thursday, June 10, 2004, 2:20:50 PM


More information:
Microsoft Support

Modify the sql statement as:

sql="update tblRings set name='"&ringname&"',desc='"&desc&"' where item_id = " &itemid


Om Prakash

now error shown
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in UPDATE statement.
/jewler/admin/update_ring.asp, line 13

line 13 is--> objRS.open sql,conn

What does your SQL-statement look like now? (response.write(sql))

It could be the column name 'desc' that is the culprit - check this thread:
http://p2p.wrox.com/topic.asp?TOPIC_ID=14616

Yes, Jonax is correct, the code should be as follows:

sql="update tblRings set name='"&ringname&"',[desc]='"&desc&"' where item_id = " &itemid

as desc is keyword.

Om Prakash