If you are updating text fields in your database enclose them in quotes i.e. '#Form.Name#'
If you are updating a number field in your database do not enclose them in quotes.. On 8/9/06, Gary Strommen <[EMAIL PROTECTED]> wrote: > Thanks for the help, I figured out what the problem was. It did have to do > with the syntax of my update code. (The problem was that I had the > #FORM.primaryKeyxxx# in quotes and coldfusion did not like that.) The > following code works for me: > > <cfquery datasource="sonocme"> > UPDATE users > SET > fName = '#FORM.fNameNEW#', > lName = '#FORM.lNameNEW#', > proID = '#FORM.proIDNEW#', > eMail = '#FORM.eMail1NEW#', > zip = '#FORM.zipNEW#', > SSN = '#FORM.ssnNEW#' > WHERE primaryKey = #FORM.primaryKeyUSER# > </cfquery> > > <cfquery datasource="sonocme"> > UPDATE passwords > SET > password = '#FORM.psswrd1NEW#', > eMail = '#FORM.eMail1NEW#' > WHERE primaryKey = #FORM.primaryKeyPASSWORD# > </cfquery> > > > > Hope this helps other people. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-Newbie/message.cfm/messageid:1966 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
