Problem with CreateODBCDateTime(Now())

[Steve Kahn]

I'm trying to set the date when a user logs in, but it keeps showing up in the database as:
<cfoutput>{ts '2004-09-20 13:21:00'}</cfoutput>

on my action page I have
<cfset datetime="<cfoutput>#CreateODBCDateTime(Now())#</cfoutput>">

<cfquery datasource="dsn">
  UPDATE trackusers
  SET Logindate='#datetime#', IP='#remote_addr#', browser='#http_user_agent#', remote_host='#remote_host#', remote_referer='#http_referer#'
  WHERE username = '#username#'
  AND pwd = '#pwd#'
  </cfquery>

What am I doing wrong?

Thanks
Steve

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---