update issue

[standardCode]

Do you guys see any problems with this:
<cfquery name="updPassword" datasource="#session.dsn#">
update auth
set password='#variables.pass2#'
where username='#session.username#'
</cfquery>

password and username get a string value and I have tried to replace the
variables with a string and I doing all of that I get the following error:

Error Executing Database Query.
Syntax error in UPDATE statement.

The interesting part is that I can do an INSERT and SELECT in the same query
statment and table just not an update.

[jorgepino]

where is this value coming from #variables.pass2#

[standardCode]

<cfset pass2=trim(form.updatedPassword1)>
on top of my script. As I mentioned, I have tried replacing these variables with actual strings and I still get the same error.

[standardCode]

I'm not crazy ;). The duplicates are from a system error I kept getting.
NNTP protocol error. 441 437 EMP (phl)