Yup, that is what I mean, the columns getting an empty string.
-----Original Message----- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 10:35 AM To: CF-Talk Subject: Re: Query issue between MX 6 and MX 7 I assume what the "radically different result" you describe is that on CF 7, column C gets reverted to the empty string (from '3') when the second query is injected into column BB? Or is there something else? cheers, barneyb On 7/25/06, Trevor Orr <[EMAIL PROTECTED]> wrote: > I ran across an issue with queries in MX 6 and MX7, try this code in > MX > 6 and MX 7 and you get radically different results. Anyone know of a > reason for this or is it a bug. I sent this to Adobe but got no > response so maybe someone here can shed some light. > > > Here is the code: > > <cfset q = QueryNew("A,B,C,D,E") /> > <cfloop index="i" from="1" to="3"> > <cfset queryaddRow(q, 1) /> > <cfset querysetcell(q, "a", 1) /> > <cfset querysetcell(q, "b", 2) /> > <cfset querysetcell(q, "c", 3) /> > </cfloop> > <cfset queryaddcolumn(q, "bb", arraynew(1)) /> > > <cfset qq = QueryNew("A,B,C,D,E") /> > <cfloop index="i" from="1" to="3"> > <cfset queryaddRow(qq, 1) /> > <cfset querysetcell(qq, "a", 1) /> > <cfset querysetcell(qq, "b", 2) /> > <cfset querysetcell(qq, "c", 3) /> > </cfloop> > > <cfloop index="i" from="1" to="3"> > <cfset querysetcell(q, "bb", qq, i) /> </cfloop> <cfdump var="#q#"> > > > > > Trevor Orr -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247695 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
