Try doing some further tests before inserting, like is the length of the value at
least the shortest possible date string, for example (1/1/00) is least 6 chars.
At 11:18 AM 8/8/00 -0400, you wrote:
>What are the usual suggested fixes/workarounds for the isDate function?
>Originally we were inserting comma delimited lists into our database, but
>whenever a list of two entries (ie: 1,1, 3,4) would be entered, it would
>turn these into dates(jan 1, 2000 march 4, 2000). If we just stop using the
>isDate function, then when we actually want to insert dates, they get
>corrupted.
>
>Sean Holden
>[EMAIL PROTECTED]
>
>
>------------------------------------------------------------------------------
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
====================================================
Douglas M. Smith - Database Architect/Web Integration Specialist
====================================================
TeraTech Inc - Tools for Programmers(tm)
VisualBasic, Web (ColdFusion and ASP), Math and Statistics,
Access, SQL, programming tools & consulting
100 Park Ave, Suite 360, Rockville MD 20850 USA
Voice: 301-424-3903, Fax: 301-762-8185
http://www.teratech.com
====================================================
Email: [EMAIL PROTECTED]
Mobil/Cell Phone: (240) 601-5520
ICQ: 41044319
====================================================
Do you need a group calendar or scheduler?
How about a free ColdFusion Tag and Function Reference?
Go to http://www.teratech.com/freestuff.cfm
====================================================
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
