I'm getting this when writing a date to a datetime len 8 in SQL Server 2000 in a hosted environment:
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string. It returns the error on any valid dates in mm/dd/yy format. I have several date fields in other places but they're OK. I've tried with and without quotes. Thanks, Doug Jordon ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

