We called MM form school (Alfred University) and inquired about our upgrade to CF Studio 5, and they said its on its way.. Well, 1 month later we got a CD but it was ULTRADEV!!!!!! We are still trying to get studio 5, based on the agreement we have with MM, our subscription entitles us to studio 5, and we would like to see MM honor their agreements on this.
-----Original Message----- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 2:47 PM To: CF-Talk Subject: Allaire Partner upgrades... 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 > > ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
