GetRows() converts to a native array which is handled by the interpreter, in this case CF. It only converts to a VBScript array, if called by VBScript. ADO is theorhetically platform independant.
Basically I am trying to do an array update with ADO. This is easy with ASP or WSH, but with cfquery, although nice easy, is extremely limited in this manner. In my app I have one page (it's a grid...) that literally might update hundreds of rows in a normalized table. I am hoping that in Neo, I will be able to build a component that takes advantage of java.sql's batch updates, but until then... jon ----- Original Message ----- From: "BILLY CRAVENS" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 18, 2001 12:06 PM Subject: Re: CFObject ADO & the decimal datatype > 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 ______________________________________________________________________ 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
