> 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. FYI, No quotes around the CreateODBCWhatever() functions ... You might also try using <cfqeuryparam> ... Isaac Dealey www.turnkey.to 954-776-0046 ______________________________________________________________________ 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
