> First, drop the single quotes.
>
> WHERE date = #createodbcdate('20/09/2000')#
>
> That will work, and will enter into the database: {d '2000-09-20'}
Excellent, works great. The problem you outlined with CF isn't a major one,
it can be overcome I reckon.
Thanks
Will
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
