I ran across an issue with queries in MX 6 and MX7, try this code in 6
and 7 and you 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#">
MX 6 Results
<style>
table.cfdump_wddx,
table.cfdump_xml,
table.cfdump_struct,
table.cfdump_array,
table.cfdump_query,
table.cfdump_cfc,
table.cfdump_object,
table.cfdump_binary,
table.cfdump_udf,
table.cfdump_udfbody,
table.cfdump_udfarguments {
font-size: xx-small;
font-family: verdana, arial, helvetica, sans-serif;
cell-spacing: 2;
}
table.cfdump_wddx th,
table.cfdump_xml th,
table.cfdump_struct th,
table.cfdump_array th,
table.cfdump_query th,
table.cfdump_cfc th,
table.cfdump_object th,
table.cfdump_binary th,
table.cfdump_udf th,
table.cfdump_udfbody th,
table.cfdump_udfarguments th {
text-align: left;
color: white;
padding: 5;
}
table.cfdump_wddx td,
table.cfdump_xml td,
table.cfdump_struct td,
table.cfdump_array td,
table.cfdump_query td,
table.cfdump_cfc td,
table.cfdump_object td,
table.cfdump_binary td,
table.cfdump_udf td,
table.cfdump_udfbody td,
table.cfdump_udfarguments td {
padding: 3;
background-color: ffffff;
vertical-align : top;
}
table.cfdump_wddx {
background-color: 000000;
}
table.cfdump_wddx th.wddx {
background-color: 444444;
}
table.cfdump_xml {
background-color: 888888;
}
table.cfdump_xml th.xml {
background-color: aaaaaa;
}
table.cfdump_xml td.xml {
background-color: dddddd;
}
table.cfdump_struct {
background-color: 0000cc ;
}
table.cfdump_struct th.struct {
background-color: 4444cc ;
}
table.cfdump_struct td.struct {
background-color: ccddff;
}
table.cfdump_array {
background-color: 006600 ;
}
table.cfdump_array th.array {
background-color: 009900 ;
}
table.cfdump_array td.array {
background-color: ccffcc ;
}
table.cfdump_query {
background-color: 884488 ;
}
table.cfdump_query th.query {
background-color: aa66aa ;
}
table.cfdump_query td.query {
background-color: ffddff ;
}
table.cfdump_cfc {
background-color: ff0000;
}
table.cfdump_cfc th.cfc{
background-color: ff4444;
}
table.cfdump_cfc td.cfc {
background-color: ffcccc;
}
table.cfdump_object {
background-color : ff0000;
}
table.cfdump_object th.object{
background-color: ff4444;
}
table.cfdump_binary {
background-color : eebb00;
}
table.cfdump_binary th.binary {
background-color: ffcc44;
}
table.cfdump_binary td {
font-size: x-small;
}
table.cfdump_udf {
background-color: aa4400;
}
table.cfdump_udf th.udf {
background-color: cc6600;
}
table.cfdump_udfarguments {
background-color: dddddd;
cell-spacing: 3;
}
table.cfdump_udfarguments th {
background-color: eeeeee;
color: 000000;
}
</style>
<script language="JavaScript">
function dump ( obj ) {
var out = '' ;
if ( typeof obj == "object" ) {
for ( key in obj ) {
if ( typeof obj[key] != "function" ) out += key + ': ' + obj[key] +
'<br>' ;
}
}
}
function cfdump_toggleRow(source) {
//target is the right cell
if(document.all) target = source.parentElement.cells[1];
else target = source.parentNode.lastChild ;
cfdump_toggleTarget( target, cfdump_toggleSource( source ) ) ;
}
function cfdump_toggleXmlDoc(source) {
var caption = source.innerHTML.split( ' [' ) ;
// toggle source (header)
if ( source.style.fontStyle == 'italic' ) {
// closed -> short
source.style.fontStyle = 'normal' ;
source.innerHTML = caption[0] + ' [short version]' ;
source.title = 'click to maximize' ;
switchShortToState = 'open' ;
} else if ( source.innerHTML.indexOf('[short version]') != -1 ) {
// short -> full
source.innerHTML = caption[0] + ' [long version]' ;
source.title = 'click to collapse' ;
switchLongToState = 'open' ;
switchShortToState = 'closed' ;
} else {
// full -> closed
source.style.fontStyle = 'italic' ;
source.title = 'click to expand' ;
source.innerHTML = caption[0] ;
switchLongToState = 'closed' ;
}
// Toggle the target (everething below the header row).
// First two rows are XMLComment and XMLRoot - they are part
// of the long dump, the rest are direct children - part of the
// short dump
if(document.all) {
var table = source.parentElement.parentElement ;
for ( var i = 1; i < table.rows.length; i++ ) {
target = table.rows[i] ;
if ( i < 3 ) cfdump_toggleTarget( target, switchLongToState ) ;
else cfdump_toggleTarget( target, switchShortToState ) ;
}
}
else {
var table = source.parentNode.parentNode ;
var row = 1;
for ( var i = 1; i < table.childNodes.length; i++ ) {
target = table.childNodes[i] ;
if( target.style ) {
if ( row < 3 ) {
cfdump_toggleTarget( target, switchLongToState ) ;
} else {
cfdump_toggleTarget( target, switchShortToState ) ;
}
row++;
}
}
}
}
function cfdump_toggleTable(source) {
var switchToState = cfdump_toggleSource( source ) ;
if(document.all) {
var table = source.parentElement.parentElement ;
for ( var i = 1; i < table.rows.length; i++ ) {
target = table.rows[i] ;
cfdump_toggleTarget( target, switchToState ) ;
}
}
else {
var table = source.parentNode.parentNode ;
for ( var i = 1; i < table.childNodes.length; i++ ) {
target = table.childNodes[i] ;
if(target.style) {
cfdump_toggleTarget( target, switchToState ) ;
}
}
}
}
function cfdump_toggleSource ( source ) {
if ( source.style.fontStyle == 'italic' ) {
source.style.fontStyle = 'normal' ;
source.title = 'click to collapse' ;
return 'open' ;
} else {
source.style.fontStyle = 'italic' ;
source.title = 'click to expand' ;
return 'closed' ;
}
}
function cfdump_toggleTarget ( target, switchToState ) {
if ( switchToState == 'open' ) target.style.display = '' ;
else target.style.display = 'none' ;
}
</script>
<table class="cfdump_query">
<tr><th class="query" colspan="7" onClick="cfdump_toggleTable(this);"
style="cursor:hand;" title="click to collapse">query</th></tr>
<tr bgcolor="eeaaaa">
<td class="query"> </td>
<td class="query">A</td><td class="query">B</td><td
class="query">BB</td><td class="query">C</td><td class="query">D</td><td
class="query">E</td></tr>
<tr><td class="query">1</td><td valign="top">1</td><td
valign="top">2</td><td valign="top">[empty string]</td><td
valign="top">3</td><td valign="top">4</td><td valign="top">5</td></tr>
<tr><td class="query">2</td><td valign="top">1</td><td
valign="top">2</td><td valign="top">[empty string]</td><td
valign="top">3</td><td valign="top">4</td><td valign="top">5</td></tr>
<tr><td class="query">3</td><td valign="top">1</td><td
valign="top">2</td><td valign="top">[empty string]</td><td
valign="top">3</td><td valign="top">4</td><td valign="top">5</td></tr>
</table>
<table class="cfdump_query">
<tr><th class="query" colspan="7" onClick="cfdump_toggleTable(this);"
style="cursor:hand;" title="click to collapse">query</th></tr>
<tr bgcolor="eeaaaa">
<td class="query"> </td>
<td class="query">A</td><td class="query">B</td><td
class="query">BB</td><td class="query">C</td><td class="query">D</td><td
class="query">E</td></tr>
<tr><td class="query">1</td><td valign="top">1</td><td
valign="top">2</td><td valign="top">
<table class="cfdump_query">
<tr><th class="query" colspan="6" onClick="cfdump_toggleTable(this);"
style="cursor:hand;" title="click to collapse">query</th></tr>
<tr bgcolor="eeaaaa">
<td class="query"> </td>
<td class="query">A</td><td class="query">B</td><td
class="query">C</td><td class="query">D</td><td
class="query">E</td></tr>
<tr><td class="query">1</td><td valign="top">1</td><td
valign="top">2</td><td valign="top">3</td><td valign="top">4</td><td
valign="top">5</td></tr>
<tr><td class="query">2</td><td valign="top">1</td><td
valign="top">2</td><td valign="top">3</td><td valign="top">4</td><td
valign="top">5</td></tr>
<tr><td class="query">3</td><td valign="top">1</td><td
valign="top">2</td><td valign="top">3</td><td valign="top">4</td><td
valign="top">5</td></tr>
</table>
</td><td valign="top">3</td><td valign="top">4</td><td
valign="top">5</td></tr>
<tr><td class="query">2</td><td valign="top">1</td><td
valign="top">2</td><td valign="top">
<table class="cfdump_query">
<tr><th class="query" colspan="6" onClick="cfdump_toggleTable(this);"
style="cursor:hand;" title="click to collapse">query</th></tr>
<tr bgcolor="eeaaaa">
<td class="query"> </td>
<td class="query">A</td><td class="query">B</td><td
class="query">C</td><td class="query">D</td><td
class="query">E</td></tr>
<tr><td class="query">1</td><td valign="top">1</td><td
valign="top">2</td><td valign="top">3</td><td valign="top">4</td><td
valign="top">5</td></tr>
<tr><td class="query">2</td><td valign="top">1</td><td
valign="top">2</td><td valign="top">3</td><td valign="top">4</td><td
valign="top">5</td></tr>
<tr><td class="query">3</td><td valign="top">1</td><td
valign="top">2</td><td valign="top">3</td><td valign="top">4</td><td
valign="top">5</td></tr>
</table>
</td><td valign="top">3</td><td valign="top">4</td><td
valign="top">5</td></tr>
<tr><td class="query">3</td><td valign="top">1</td><td
valign="top">2</td><td valign="top">
<table class="cfdump_query">
<tr><th class="query" colspan="6" onClick="cfdump_toggleTable(this);"
style="cursor:hand;" title="click to collapse">query</th></tr>
<tr bgcolor="eeaaaa">
<td class="query"> </td>
<td class="query">A</td><td class="query">B</td><td
class="query">C</td><td class="query">D</td><td
class="query">E</td></tr>
<tr><td class="query">1</td><td valign="top">1</td><td
valign="top">2</td><td valign="top">3</td><td valign="top">4</td><td
valign="top">5</td></tr>
<tr><td class="query">2</td><td valign="top">1</td><td
valign="top">2</td><td valign="top">3</td><td valign="top">4</td><td
valign="top">5</td></tr>
<tr><td class="query">3</td><td valign="top">1</td><td
valign="top">2</td><td valign="top">3</td><td valign="top">4</td><td
valign="top">5</td></tr>
</table>
</td><td valign="top">3</td><td valign="top">4</td><td
valign="top">5</td></tr>
</table>
MX 7 Results
<style>
table.cfdump_wddx,
table.cfdump_xml,
table.cfdump_struct,
table.cfdump_array,
table.cfdump_query,
table.cfdump_cfc,
table.cfdump_object,
table.cfdump_binary,
table.cfdump_udf,
table.cfdump_udfbody,
table.cfdump_udfarguments {
font-size: xx-small;
font-family: verdana, arial, helvetica, sans-serif;
cell-spacing: 2px;
}
table.cfdump_wddx th,
table.cfdump_xml th,
table.cfdump_struct th,
table.cfdump_array th,
table.cfdump_query th,
table.cfdump_cfc th,
table.cfdump_object th,
table.cfdump_binary th,
table.cfdump_udf th,
table.cfdump_udfbody th,
table.cfdump_udfarguments th {
text-align: left;
color: white;
padding: 5px;
}
table.cfdump_wddx td,
table.cfdump_xml td,
table.cfdump_struct td,
table.cfdump_array td,
table.cfdump_query td,
table.cfdump_cfc td,
table.cfdump_object td,
table.cfdump_binary td,
table.cfdump_udf td,
table.cfdump_udfbody td,
table.cfdump_udfarguments td {
padding: 3px;
background-color: #ffffff;
vertical-align : top;
}
table.cfdump_wddx {
background-color: #000000;
}
table.cfdump_wddx th.wddx {
background-color: #444444;
}
table.cfdump_xml {
background-color: #888888;
}
table.cfdump_xml th.xml {
background-color: #aaaaaa;
}
table.cfdump_xml td.xml {
background-color: #dddddd;
}
table.cfdump_struct {
background-color: #0000cc ;
}
table.cfdump_struct th.struct {
background-color: #4444cc ;
}
table.cfdump_struct td.struct {
background-color: #ccddff;
}
table.cfdump_array {
background-color: #006600 ;
}
table.cfdump_array th.array {
background-color: #009900 ;
}
table.cfdump_array td.array {
background-color: #ccffcc ;
}
table.cfdump_query {
background-color: #884488 ;
}
table.cfdump_query th.query {
background-color: #aa66aa ;
}
table.cfdump_query td.query {
background-color: #ffddff ;
}
table.cfdump_cfc {
background-color: #ff0000;
}
table.cfdump_cfc th.cfc{
background-color: #ff4444;
}
table.cfdump_cfc td.cfc {
background-color: #ffcccc;
}
table.cfdump_object {
background-color : #ff0000;
}
table.cfdump_object th.object{
background-color: #ff4444;
}
table.cfdump_binary {
background-color : #eebb00;
}
table.cfdump_binary th.binary {
background-color: #ffcc44;
}
table.cfdump_binary td {
font-size: x-small;
}
table.cfdump_udf {
background-color: #aa4400;
}
table.cfdump_udf th.udf {
background-color: #cc6600;
}
table.cfdump_udfarguments {
background-color: #dddddd;
cell-spacing: 3;
}
table.cfdump_udfarguments th {
background-color: #eeeeee;
color: #000000;
}
</style>
<script language="JavaScript">
function dump ( obj ) {
var out = '' ;
if ( typeof obj == "object" ) {
for ( key in obj ) {
if ( typeof obj[key] != "function" ) out += key + ': ' + obj[key] +
'<br>' ;
}
}
}
function cfdump_toggleRow(source) {
//target is the right cell
if(document.all) target = source.parentElement.cells[1];
else target = source.parentNode.lastChild ;
cfdump_toggleTarget( target, cfdump_toggleSource( source ) ) ;
}
function cfdump_toggleXmlDoc(source) {
var caption = source.innerHTML.split( ' [' ) ;
// toggle source (header)
if ( source.style.fontStyle == 'italic' ) {
// closed -> short
source.style.fontStyle = 'normal' ;
source.innerHTML = caption[0] + ' [short version]' ;
source.title = 'click to maximize' ;
switchLongToState = 'closed' ;
switchShortToState = 'open' ;
} else if ( source.innerHTML.indexOf('[short version]') != -1 ) {
// short -> full
source.innerHTML = caption[0] + ' [long version]' ;
source.title = 'click to collapse' ;
switchLongToState = 'open' ;
switchShortToState = 'closed' ;
} else {
// full -> closed
source.style.fontStyle = 'italic' ;
source.title = 'click to expand' ;
source.innerHTML = caption[0] ;
switchLongToState = 'closed' ;
switchShortToState = 'closed' ;
}
// Toggle the target (everething below the header row).
// First two rows are XMLComment and XMLRoot - they are part
// of the long dump, the rest are direct children - part of the
// short dump
if(document.all) {
var table = source.parentElement.parentElement ;
for ( var i = 1; i < table.rows.length; i++ ) {
target = table.rows[i] ;
if ( i < 3 ) cfdump_toggleTarget( target, switchLongToState ) ;
else cfdump_toggleTarget( target, switchShortToState ) ;
}
}
else {
var table = source.parentNode.parentNode ;
var row = 1;
for ( var i = 1; i < table.childNodes.length; i++ ) {
target = table.childNodes[i] ;
if( target.style ) {
if ( row < 3 ) {
cfdump_toggleTarget( target, switchLongToState ) ;
} else {
cfdump_toggleTarget( target, switchShortToState ) ;
}
row++;
}
}
}
}
function cfdump_toggleTable(source) {
var switchToState = cfdump_toggleSource( source ) ;
if(document.all) {
var table = source.parentElement.parentElement ;
for ( var i = 1; i < table.rows.length; i++ ) {
target = table.rows[i] ;
cfdump_toggleTarget( target, switchToState ) ;
}
}
else {
var table = source.parentNode.parentNode ;
for ( var i = 1; i < table.childNodes.length; i++ ) {
target = table.childNodes[i] ;
if(target.style) {
cfdump_toggleTarget( target, switchToState ) ;
}
}
}
}
function cfdump_toggleSource ( source ) {
if ( source.style.fontStyle == 'italic' || source.style.fontStyle
== null) {
source.style.fontStyle = 'normal' ;
source.title = 'click to collapse' ;
return 'open' ;
} else {
source.style.fontStyle = 'italic' ;
source.title = 'click to expand' ;
return 'closed' ;
}
}
function cfdump_toggleTarget ( target, switchToState ) {
if ( switchToState == 'open' ) target.style.display = '' ;
else target.style.display = 'none' ;
}
</script>
<table class="cfdump_query">
<tr><th class="query" colspan="7" onClick="cfdump_toggleTable(this);"
style="cursor:hand;" title="click to collapse">query - Top 3 of 3
Rows</th></tr>
<tr bgcolor="eeaaaa" >
<td class="query"> </td>
<td class="query">A</td><td class="query">B</td><td
class="query">BB</td><td class="query">C</td><td class="query">D</td><td
class="query">E</td></tr>
<tr ><td onClick="cfdump_toggleRow(this);" style="cursor:hand;"
title="click to collapse" class="query">1</td> <td valign="top"> 1 </td>
<td valign="top">2 </td> <td valign="top">[empty string] </td> <td
valign="top">3 </td> <td valign="top">4 </td> <td valign="top">5 </td>
</tr>
<tr ><td onClick="cfdump_toggleRow(this);" style="cursor:hand;"
title="click to collapse" class="query">2</td> <td valign="top">1 </td>
<td valign="top">2 </td> <td valign="top">[empty string] </td> <td
valign="top">3 </td> <td valign="top">4 </td> <td valign="top">5 </td>
</tr>
<tr ><td onClick="cfdump_toggleRow(this);" style="cursor:hand;"
title="click to collapse" class="query">3</td> <td valign="top">1 </td>
<td valign="top">2 </td> <td valign="top">[empty string] </td> <td
valign="top">3 </td> <td valign="top">4 </td> <td valign="top">5 </td>
</tr>
</table>
<style>
table.cfdump_wddx,
table.cfdump_xml,
table.cfdump_struct,
table.cfdump_array,
table.cfdump_query,
table.cfdump_cfc,
table.cfdump_object,
table.cfdump_binary,
table.cfdump_udf,
table.cfdump_udfbody,
table.cfdump_udfarguments {
font-size: xx-small;
font-family: verdana, arial, helvetica, sans-serif;
cell-spacing: 2px;
}
table.cfdump_wddx th,
table.cfdump_xml th,
table.cfdump_struct th,
table.cfdump_array th,
table.cfdump_query th,
table.cfdump_cfc th,
table.cfdump_object th,
table.cfdump_binary th,
table.cfdump_udf th,
table.cfdump_udfbody th,
table.cfdump_udfarguments th {
text-align: left;
color: white;
padding: 5px;
}
table.cfdump_wddx td,
table.cfdump_xml td,
table.cfdump_struct td,
table.cfdump_array td,
table.cfdump_query td,
table.cfdump_cfc td,
table.cfdump_object td,
table.cfdump_binary td,
table.cfdump_udf td,
table.cfdump_udfbody td,
table.cfdump_udfarguments td {
padding: 3px;
background-color: #ffffff;
vertical-align : top;
}
table.cfdump_wddx {
background-color: #000000;
}
table.cfdump_wddx th.wddx {
background-color: #444444;
}
table.cfdump_xml {
background-color: #888888;
}
table.cfdump_xml th.xml {
background-color: #aaaaaa;
}
table.cfdump_xml td.xml {
background-color: #dddddd;
}
table.cfdump_struct {
background-color: #0000cc ;
}
table.cfdump_struct th.struct {
background-color: #4444cc ;
}
table.cfdump_struct td.struct {
background-color: #ccddff;
}
table.cfdump_array {
background-color: #006600 ;
}
table.cfdump_array th.array {
background-color: #009900 ;
}
table.cfdump_array td.array {
background-color: #ccffcc ;
}
table.cfdump_query {
background-color: #884488 ;
}
table.cfdump_query th.query {
background-color: #aa66aa ;
}
table.cfdump_query td.query {
background-color: #ffddff ;
}
table.cfdump_cfc {
background-color: #ff0000;
}
table.cfdump_cfc th.cfc{
background-color: #ff4444;
}
table.cfdump_cfc td.cfc {
background-color: #ffcccc;
}
table.cfdump_object {
background-color : #ff0000;
}
table.cfdump_object th.object{
background-color: #ff4444;
}
table.cfdump_binary {
background-color : #eebb00;
}
table.cfdump_binary th.binary {
background-color: #ffcc44;
}
table.cfdump_binary td {
font-size: x-small;
}
table.cfdump_udf {
background-color: #aa4400;
}
table.cfdump_udf th.udf {
background-color: #cc6600;
}
table.cfdump_udfarguments {
background-color: #dddddd;
cell-spacing: 3;
}
table.cfdump_udfarguments th {
background-color: #eeeeee;
color: #000000;
}
</style>
<script language="JavaScript">
function dump ( obj ) {
var out = '' ;
if ( typeof obj == "object" ) {
for ( key in obj ) {
if ( typeof obj[key] != "function" ) out += key + ': ' + obj[key] +
'<br>' ;
}
}
}
function cfdump_toggleRow(source) {
//target is the right cell
if(document.all) target = source.parentElement.cells[1];
else target = source.parentNode.lastChild ;
cfdump_toggleTarget( target, cfdump_toggleSource( source ) ) ;
}
function cfdump_toggleXmlDoc(source) {
var caption = source.innerHTML.split( ' [' ) ;
// toggle source (header)
if ( source.style.fontStyle == 'italic' ) {
// closed -> short
source.style.fontStyle = 'normal' ;
source.innerHTML = caption[0] + ' [short version]' ;
source.title = 'click to maximize' ;
switchLongToState = 'closed' ;
switchShortToState = 'open' ;
} else if ( source.innerHTML.indexOf('[short version]') != -1 ) {
// short -> full
source.innerHTML = caption[0] + ' [long version]' ;
source.title = 'click to collapse' ;
switchLongToState = 'open' ;
switchShortToState = 'closed' ;
} else {
// full -> closed
source.style.fontStyle = 'italic' ;
source.title = 'click to expand' ;
source.innerHTML = caption[0] ;
switchLongToState = 'closed' ;
switchShortToState = 'closed' ;
}
// Toggle the target (everething below the header row).
// First two rows are XMLComment and XMLRoot - they are part
// of the long dump, the rest are direct children - part of the
// short dump
if(document.all) {
var table = source.parentElement.parentElement ;
for ( var i = 1; i < table.rows.length; i++ ) {
target = table.rows[i] ;
if ( i < 3 ) cfdump_toggleTarget( target, switchLongToState ) ;
else cfdump_toggleTarget( target, switchShortToState ) ;
}
}
else {
var table = source.parentNode.parentNode ;
var row = 1;
for ( var i = 1; i < table.childNodes.length; i++ ) {
target = table.childNodes[i] ;
if( target.style ) {
if ( row < 3 ) {
cfdump_toggleTarget( target, switchLongToState ) ;
} else {
cfdump_toggleTarget( target, switchShortToState ) ;
}
row++;
}
}
}
}
function cfdump_toggleTable(source) {
var switchToState = cfdump_toggleSource( source ) ;
if(document.all) {
var table = source.parentElement.parentElement ;
for ( var i = 1; i < table.rows.length; i++ ) {
target = table.rows[i] ;
cfdump_toggleTarget( target, switchToState ) ;
}
}
else {
var table = source.parentNode.parentNode ;
for ( var i = 1; i < table.childNodes.length; i++ ) {
target = table.childNodes[i] ;
if(target.style) {
cfdump_toggleTarget( target, switchToState ) ;
}
}
}
}
function cfdump_toggleSource ( source ) {
if ( source.style.fontStyle == 'italic' || source.style.fontStyle
== null) {
source.style.fontStyle = 'normal' ;
source.title = 'click to collapse' ;
return 'open' ;
} else {
source.style.fontStyle = 'italic' ;
source.title = 'click to expand' ;
return 'closed' ;
}
}
function cfdump_toggleTarget ( target, switchToState ) {
if ( switchToState == 'open' ) target.style.display = '' ;
else target.style.display = 'none' ;
}
</script>
<table class="cfdump_query">
<tr><th class="query" colspan="7" onClick="cfdump_toggleTable(this);"
style="cursor:hand;" title="click to collapse">query - Top 3 of 3
Rows</th></tr>
<tr bgcolor="eeaaaa" >
<td class="query"> </td>
<td class="query">A</td><td class="query">B</td><td
class="query">BB</td><td class="query">C</td><td class="query">D</td><td
class="query">E</td></tr>
<tr ><td onClick="cfdump_toggleRow(this);" style="cursor:hand;"
title="click to collapse" class="query">1</td> <td valign="top">1 </td>
<td valign="top">2 </td> <td valign="top">
<table class="cfdump_query">
<tr><th class="query" colspan="6" onClick="cfdump_toggleTable(this);"
style="cursor:hand;" title="click to collapse">query - Top 3 of 3
Rows</th></tr>
<tr bgcolor="eeaaaa" >
<td class="query"> </td>
<td class="query">A</td><td class="query">B</td><td
class="query">C</td><td class="query">D</td><td
class="query">E</td></tr>
<tr ><td onClick="cfdump_toggleRow(this);" style="cursor:hand;"
title="click to collapse" class="query">1</td> <td valign="top"> 1 </td>
<td valign="top">2 </td> <td valign="top">3 </td> <td valign="top">4
</td> <td valign="top">5 </td> </tr>
<tr ><td onClick="cfdump_toggleRow(this);" style="cursor:hand;"
title="click to collapse" class="query">2</td> <td valign="top">1 </td>
<td valign="top">2 </td> <td valign="top">3 </td> <td valign="top">4
</td> <td valign="top">5 </td> </tr>
<tr ><td onClick="cfdump_toggleRow(this);" style="cursor:hand;"
title="click to collapse" class="query">3</td> <td valign="top">1 </td>
<td valign="top">2 </td> <td valign="top">3 </td> <td valign="top">4
</td> <td valign="top">5 </td> </tr>
</table>
</td> <td valign="top">[empty string] </td> <td valign="top">[empty
string] </td> <td valign="top">[empty string] </td> </tr>
<tr ><td onClick="cfdump_toggleRow(this);" style="cursor:hand;"
title="click to collapse" class="query">2</td> <td valign="top">1 </td>
<td valign="top">2 </td> <td valign="top">
<table class="cfdump_query">
<tr><th class="query" colspan="6" onClick="cfdump_toggleTable(this);"
style="cursor:hand;" title="click to collapse">query - Top 3 of 3
Rows</th></tr>
<tr bgcolor="eeaaaa" >
<td class="query"> </td>
<td class="query">A</td><td class="query">B</td><td
class="query">C</td><td class="query">D</td><td
class="query">E</td></tr>
<tr ><td onClick="cfdump_toggleRow(this);" style="cursor:hand;"
title="click to collapse" class="query">1</td> <td valign="top">1 </td>
<td valign="top">2 </td> <td valign="top">3 </td> <td valign="top">4
</td> <td valign="top">5 </td> </tr>
<tr ><td onClick="cfdump_toggleRow(this);" style="cursor:hand;"
title="click to collapse" class="query">2</td> <td valign="top">1 </td>
<td valign="top">2 </td> <td valign="top">3 </td> <td valign="top">4
</td> <td valign="top">5 </td> </tr>
<tr ><td onClick="cfdump_toggleRow(this);" style="cursor:hand;"
title="click to collapse" class="query">3</td> <td valign="top">1 </td>
<td valign="top">2 </td> <td valign="top">3 </td> <td valign="top">4
</td> <td valign="top">5 </td> </tr>
</table>
</td> <td valign="top">[empty string] </td> <td valign="top">[empty
string] </td> <td valign="top">[empty string] </td> </tr>
<tr ><td onClick="cfdump_toggleRow(this);" style="cursor:hand;"
title="click to collapse" class="query">3</td> <td valign="top">1 </td>
<td valign="top">2 </td> <td valign="top">
<table class="cfdump_query">
<tr><th class="query" colspan="6" onClick="cfdump_toggleTable(this);"
style="cursor:hand;" title="click to collapse">query - Top 3 of 3
Rows</th></tr>
<tr bgcolor="eeaaaa" >
<td class="query"> </td>
<td class="query">A</td><td class="query">B</td><td
class="query">C</td><td class="query">D</td><td
class="query">E</td></tr>
<tr ><td onClick="cfdump_toggleRow(this);" style="cursor:hand;"
title="click to collapse" class="query">1</td> <td valign="top">1 </td>
<td valign="top">2 </td> <td valign="top">3 </td> <td valign="top">4
</td> <td valign="top">5 </td> </tr>
<tr ><td onClick="cfdump_toggleRow(this);" style="cursor:hand;"
title="click to collapse" class="query">2</td> <td valign="top">1 </td>
<td valign="top">2 </td> <td valign="top">3 </td> <td valign="top">4
</td> <td valign="top">5 </td> </tr>
<tr ><td onClick="cfdump_toggleRow(this);" style="cursor:hand;"
title="click to collapse" class="query">3</td> <td valign="top">1 </td>
<td valign="top">2 </td> <td valign="top">3 </td> <td valign="top">4
</td> <td valign="top">5 </td> </tr>
</table>
</td> <td valign="top">[empty string] </td> <td valign="top">[empty
string] </td> <td valign="top">[empty string] </td> </tr>
</table>
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/cf_lists/message.cfm/forumid:10/messageid:6048
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:10
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.10
