It could be done with CFQuery, but it would require you to loop over your data and do an insert each time (thought this could be easily wrapped into a single CFQuery or a stored procedure).
You can take advantage of Java's or ADO's capabilities now - simply put them in a bean, COM object, or CFX custom tag. Have you tried casting the column's datatype in your SQL? --- Billy Cravens ----- Original Message ----- From: "Jon Hall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 18, 2001 12:43 PM Subject: Re: CFObject ADO & the decimal datatype > 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 > > ______________________________________________________________________ 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
