> 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
Use:
SET Logindate=#CreateODBCDAte(datetime)#
No quotes.
CreateODBCDAteTime() and Now() produce identical
results and contain the time element
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
