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 <[EMAIL PROTECTED]> 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: > > <cfquery datasource="sonocme"> > 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#' > </cfquery> > > <cfquery datasource="sonocme"> > UPDATE C:\CFusionMX7\wwwroot\sonoCME\New\database\CME1.passwords > SET > password = '#FORM.psswrd1NEW#', > eMail = '#FORM.eMail1NEW#' > WHERE primaryKey = '#FORM.primaryKeyPASSWORD#' > </cfquery> > > 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:1957 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
