OK, next idea is the values you are updating. Are any of the values NULL (or "")? If so, you cannot set them using set field =""
But need to set field = NULL or, better, set field = <cfif field eq "">NULL<cfelse>'#field#'</cfif>, Or best, use the <cfqueryparam> tag whenever you pass values to a query. On 8/8/06, G Strommen <[EMAIL PROTECTED]> wrote: > I haven't figured that part out myself yet either. I have previously tried > your suggestion before but it just errors out so I have been using this until > I can figure it out. It works fine for me on other pages and it is working > partially on this page so I don't really feel like this is the issue. > > I run the code and it gets all the way to the "update" button and then > seems toe error out which is why I beleive that the error now is resulting > from my coding syntax in the two updates. I even tested with CFOUTPUT > calling all the values I am referring to and they all come up with the > correct values. I am connecting to my database and pulling the information > as well as bringing forth the correct edited values to the processing page... > I just can't seem to get the new values back into the database. > > Still putzing with it. > > Thanks for the help, > -Gary > > Jerry Johnson <[EMAIL PROTECTED]> wrote: > I have never seen a cfquery call the db files directly. > > I would normally just write the table name, maybe CME1.users, or just users. > > On 8/8/06, Gary Strommen wrote: > > I have done further testing and I have changed some code around and I > > believe that the problem now lies somewhere in the following code that > > should update the user's information in the database: > > > > > > UPDATE C:\CFusionMX7\wwwroot\sonoCME\New\database\CME1.users > > SET > > fName = '#FORM.fNameNEW#', > > lName = '#FORM.lNameNEW#', > > proID = '#FORM.proIDNEW#', > > eMail = '#FORM.eMail1NEW#', > > zip = '#FORM.zipNEW#', > > SSN = '#FORM.ssnNEW#' > > WHERE primaryKey = '#FORM.primaryKeyUSER#' > > > > > > > > UPDATE C:\CFusionMX7\wwwroot\sonoCME\New\database\CME1.passwords > > SET > > password = '#FORM.psswrd1NEW#', > > eMail = '#FORM.eMail1NEW#' > > WHERE primaryKey = '#FORM.primaryKeyPASSWORD#' > > > > > > Again, any help would be appreciated > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:1959 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
