Re: Problem with CreateODBCDateTime(Now())

[Lawrence Ng]

its a string now and no longer a datetime type

you can always just insert the now() function in the query

<cfquery datasource="dsn">
  UPDATE trackusers
  SET Logindate='#now()#',
                         IP='#remote_addr#',
                         browser='#http_user_agent#',
                         ....
  </cfquery>


>>> [EMAIL PROTECTED] 9/20/2004 11:42:12 AM >>>
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]

---