Yeah no kidding, we hit the floor laughing -----Original Message----- From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 5:53 PM To: CF-Talk Subject: Re: Allaire Partner upgrades...
So UD is considered an upgrade to CF Studio? hahahahahahaha I thought it was the other way around. --- Billy Cravens ----- Original Message ----- From: "Tangorre, Michael T." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 18, 2001 4:25 PM Subject: RE: Allaire Partner upgrades... > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
