ANybody know when Allaire Alliance Partners (before they expire) should be recieving the upgrade to CF Studio5 and Homesite 5? I had been told "soon", but got no firm date a while back.
Kevin Langevin Web Guy In Charge UsWebGuys 954-327-5780 -----Original Message----- From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 2:43 PM To: CF-Talk Subject: Re: CFObject ADO & the decimal datatype 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
