I am writing a script that uses ado to update a table, and in the process of debugging it I have run into a snag. My app doesn't need to get a recordset, but while I am writing this template it would be nice to be able to see the data I am working with. I have a decimal datatype field in my recordset with a scale of 2 (if that makes a difference...). When I use recordset.GetRows() to convert the ADO recordset into an array, it bombs out with the error "Error attempting to convert between object and ColdFusion datatypes." If I remove the decimal column everything works fine. Is this just a limitation of CFObject, or is their another way around this?
RDBMS == SQL Server... jon ________________________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
