Error when using createODBCDateTime and Now()

[Tomdogggg]

I'll start you guys off with my code here:
<cfquery datasource="tempData">
UPDATE login
SET lastLoginIP='#REMOTE_ADDR#'
lastLoginDate=#Now()#
WHERE username='#Form.username#'
AND password='#Form.password#'
</cfquery>

For some reason, this query is coming up with errors; the cause of the errors
is in the #Now()# clause.
It feels like I've tried every combination possible between
createNewODBCDateTime(Now()) and DateFormat(Now()) and all the other functions.
Can you guys help me out? I'm working with an Access Database and I'm going
bonkers here.

[paross1]

You are missing a comma between your two SET parameters.

<cfquery datasource="tempData">
UPDATE login
SET lastLoginIP='#REMOTE_ADDR#',
lastLoginDate=#Now()#
WHERE username='#Form.username#'
AND password='#Form.password#'
</cfquery>

Phil

[Tomdogggg]

Thanks a bunch for that answer, I guess my head was spinning so fast that I
overlooked that simple little thing(probably why nobody else was having that
problem). For anybody else in the future who IS looking this up, please also
remember to check your column names that you are updating to make sure they are
EXACTLY the same(as this was an underlying problem for my dumba$$).

You rock Phil,
Tom