Quoting Raymond Camden <[EMAIL PROTECTED]>: > > Are you using CFMX? I believe this issue relates to the fact that > QofQ makes assumptions based on the data in the original query. In > your data below - your first row in the column custom 1 has a data.
"April 2002" is not a date, it is a string. A date in SQL has the format yyyy-mm-dd. It can not even be the string representation of a date, because it only has a month and a year. BTW, why should CF MX make an assumption for that in the first place? Databases are strongly typed. Java is strongly typed. Unless that information is not returned through JDBC, CF MX only needs to make an assumption about the "-100", not about what is returned from the databse. Or am I misunderstanding something here? Jochem ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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