Al Everett wrote: >>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. > > > This may be a silly question, but did you put your string inside a > CreateODBCDate() function?
I tried CreateODBCDateTime(). I'll try CreateODBCDate()(what the hell). I have CF code to validate the date. And it works on our development server. ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists