GetRows() converts to a VBScript array; not a CF array. If you want to see the contents of the array, you'll need to write a wrapper object that makes the ADO calls and gets the results.
Out of curiosity, why are you using ADO instead of CFQuery? --- Billy Cravens ----- Original Message ----- From: "Jon Hall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 18, 2001 10:15 AM Subject: CFObject ADO & the decimal datatype > 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 ________________________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists