It is being established as:
> SQL INSERT INTO AccessLog ( MEMBERID, ACTIONDATE, ACTION, TYPE )
> VALUES ( (param 1) , '{ts '2005-11-25 14:44:00'}', 'Login', 'User Login'
> )
>
-----Original Message-----
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Friday, November 25, 2005 6:01 PM
To: CF-Talk
Subject: Re: Access Error? CF7
how/where is request.dtStamp being set?
the combination of createODBCDate() and losing the single quotes should
certainly resolve any issues with getting the date value into the database.
Since it's not, I'm leaning towards thinking that maybe the date var isn't
being set correctly?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225286
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
