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:247636
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
