Your problem is that you're not saving a date in your database, but the string "<cfoutput>{ts '2004-09-20 13:21:00'}</cfoutput>"
If you have SET Logindate='#datetime#', in your SQL and it does not causes an error, it means your
date field is not a date field, but a TEXT field.
<cfset datetime=CreateODBCDateTime(Now())>
<cfquery datasource="dsn">
UPDATE trackusers
SET Logindate=#datetime#, ....... (no quotes here)
</cfquery>
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
