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:1956
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
