I have a stored proc that returns a query. Problem is I don't know what columns are retutned.
I can use qryReport.getColumnList() to get me a list of columns that are returned. I can display these in a table with the following code <cfset list.qryResults.columns = arrayToList(qryReport.getColumnList())> <cfset variables.Querycolumns = arraynew(1)> <cfset variables.Querycolumns = listtoarray(list.qryResults.columns )> <cfdump var="#variables.Querycolumns#"> <!--- table to display results ---> <table> <!--- header ---> <tr class="tableStyle1"> <cfloop from="1" to="#arraylen(variables.Querycolumns)#" index="counter"> <th class="tableStyle1"> <cfoutput>#variables.Querycolumns[counter]#</cfoutput> </th> </cfloop> </tr> My problem is that I can not seem to use this array to dump the query results. This code is below <cfoutput query="qryReport"> <tr class="tableStyle1"> <cfloop from="1" to="#arraylen(variables.Querycolumns)#" index="counter"> <td colspan="tableStyle1"> #qryReport['variables.Querycolmns[#counter#]']# </td> </cfloop> </tr> </cfoutput> This query returns an error [EMAIL PROTECTED] ] is not indexable by variables.Querycolmns[1] Any Ideas?? Thanks Brian Knott MIS Specialist | Pricing and MIS CFO Banking | CFO Retail Banking ext 61984 ph 07 3836 1984 fax 07 3835 5455 ________________________________ This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities "Suncorp". Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---