wierd, my first reply didn't go through...
Rick is right. Use cfqueryparam and your problems will go away:
INSERT INTO xTable(xDate) VALUES (<cfqueryparam value="Dec. 10,
2010" cfsqltype="cf_sql_date" />);
That's for a DATE column. If you are doing a DATETIME column, use
cf_sql_timestamp instead.
You can also use Michael Grant's method by converting it first to an
ODBCDATE/DATETIME formatted object
Rick Root wrote:
> #1 - are you using <cfqueryparam> to do the insert?
> #2 - To help us fix the error, it would be helpful to see the full
> error text as well as the code that is generating it.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336449
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
