Are you sure that URL_PASSWORD_ID had a value otherwise it may be executing: "WHERE PASSWORD_ID = "
Output the variable before running the query to make sure that it isn't this On 11/10/06, alex poyaoan <[EMAIL PROTECTED]> wrote: > 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:259878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
