Ok I am having an issue with a fairly simple piece of code. I want users to be able to update their password using a online form. So I have created:
CODE
<cfquery datasource="Users" name="change_passwords">
UPDATE login
SET password ='anotherTest'
WHERE aUser ='will'
</cfquery>
I get the following error:
CODE
Error Executing Database Query.
Syntax error in UPDATE statement.
The error occurred in C:\Inetpub\wwwroot\workflow\update_password.cfm: line 1
1 : <cfquery datasource="Users" name="change_passwords">
2 : UPDATE login
3 : SET password ='anotherTest'
SQLSTATE
SQL UPDATE login SET password ='anotherTest' WHERE aUser ='will'
VENDORERRORCODE 3092
DATASOURCE Users
Just for reference login is the table inside an access database called 'Users'. Obviously the user 'will' and password 'anotherTest' was typed in just to make sure it was not a problem accepting dynamic data. Normally that data would be entered from a form.
Other bits of information, the CF server is a computer found on my local network which is running windows server 2003 and has an access 2003 database on it. The database is connected to CF and works in every way except when I use this UPDATE command.
Any ideas?!?! I am ready to pull my hair out.
| 