Casting worked! Thanks! I guess cfobject has a problem with decimal datatypes...
I make it a personal rule never to loop over queries, that's bad form and the the whole reason I'm doing this... Although building a bean or cfx tag would work, for something this simple is a little crazy. It would take less time to write the action page in asp than that. jon ----- Original Message ----- From: "BILLY CRAVENS" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 18, 2001 2:42 PM 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 > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
