RE: The vagaries of QueryNew

2011-03-24 Thread Kevin Parker
arker -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Thursday, 24 March 2011 09:16 To: cf-talk Subject: RE: The vagaries of QueryNew It seems like an invalid use of queryAddColumn might have caused this for me once. I have rarely ever used that function b

RE: The vagaries of QueryNew

2011-03-23 Thread Bobby Hartsfield
It seems like an invalid use of queryAddColumn might have caused this for me once. I have rarely ever used that function but it seems familiar... As if, instead of adding the new column and updating the existing rows, it added the column but added double the rows and updated only the new rows. I'

Re: The vagaries of QueryNew

2011-03-23 Thread Claude Schnéegans
>>Are you sure you are updating the rows and not adding new ones? I am sure he is not sure ;-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archi

Re: The vagaries of QueryNew

2011-03-23 Thread Bryan Stevenson
Are you sure you are updating the rows and not adding new ones? code plz Cheers On Wed, 2011-03-23 at 22:18 +1100, Kevin Parker wrote: > I have a query where I need to add some extra stuff not in the database so > decide to create another query object with QueryNew. > > I loop over a query of

Re: The vagaries of QueryNew

2011-03-23 Thread rex
Hi Kevin, You must be doubling up a call to QueryAddRow(). Go do a search on github.com for a piece of code called QuerySim by Hal Helms. It'll help you create queries you need, and it's very easy to use. - Rex On 3/23/2011 5:01 AM, Steven Durette wrote: > First, let me say that anything th

Re: The vagaries of QueryNew

2011-03-23 Thread Steven Durette
First, let me say that anything that can be done in the database should be. But, if you must do it this way, why don't you have the db return the extra columns as nulls then set the cell values. That way you don't have the extra query object being built. Steve Sent from my iPhone On Mar 23,

Re: The vagaries of QueryNew

2011-03-23 Thread Steve Milburn
Can you show us some code? On Wed, Mar 23, 2011 at 7:18 AM, Kevin Parker wrote: > > I have a query where I need to add some extra stuff not in the database so > decide to create another query object with QueryNew. > > I loop over a query of the table to set cell values and add extra values to >