I'm sure it's just a part of the date-handling process from form entry
to db insertion that I've been mishandling and just came up with a hack.

I'll need to revisit my date handling procedures.

Thanks for the advice.

Rick



-----Original Message-----
From: Claude Schneegans [mailto:schneegans@inte...]
Sent: Monday, July 31, 2006 10:59 AM
To: CF-Talk
Subject: Re: Anyone see anything wrong with this code?

>>Ever since I started using MySQL a few years ago, I've had difficulties
getting it to accept dates without the "mmm d, yyyy" formatting.

Personally, I've never had any problem with any database when passing a date
in ODBCformat.
It's THE standard with ODBC drivers, and I guess with JDBC as well.
With dates formated as strings, you never know which format the datasouce
will eventually take.

--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: piegeacon@inte...) Thanks.




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four times a year.
http://www.fusionauthority.com/quarterly

Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248240
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=20547.15921.4