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
Summit Projects
[EMAIL PROTECTED]
541.387.8883 x213
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:247634
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4