The first thing to try is [password] rather than password. It's a reserved word and needs to be escaped if you must use it. I'd personally rename it to something else instead of trying to remember to escape it everytime.
-----Original Message----- From: alex poyaoan [mailto:[EMAIL PROTECTED] Sent: Friday, November 10, 2006 5:53 AM To: CF-Talk Subject: help on update query Hi everybody need help on this update query which gives me a syntax error.. but couldn't see where.. this is the code <CFQUERY NAME="UpdateMyPass" DATASOURCE="auxdb"> UPDATE tblpassword SET PASSWORD = '#Form.strPasswd#' WHERE PASSWORD_ID = #URL.PASSWORD_ID# </cfquery> with this i have a flash form from a mykey.cfm which calls mykey_action.cfm where the update query is.. but gives syntax error thanks in advance ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259891 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
