> 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? ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
