Can you have a Dynamic CFGRID?

[mickeyj2]

Hi,

Check it out. I'm creating an application that allows my users to select the tables they would like to browse. There selections are sent over in a very simple form element (a list).

I loop through that list performing a basic 'SELECT' statement for each table.

I'd like to show each table's data in a CFGRID, but I keep getting my original table's data.

Here's what I have:

<cfoutput>
<!--- #form.selectedtables# --->

<cfloop index = "table_ID" list = "#form.selectedtables#" delimiters = ",">
<h1>#table_ID#</h1>:

<!--- VIEW TABLE DATA --->
<cfquery name="ShowTableData" datasource="#dsn#">
SELECT *
FROM #table_ID#
</cfquery>

<cfform>
<cfdump var="#ShowTableData#">
<cfgrid name="SampleGrid[table_id]"
width="600" query="ShowTableData" insert="No" delete="No"
sort="No" font="Verdana" bold="No" italic="No" appendkey="No"
highlighthref="No" griddataalign="LEFT" gridlines="Yes"
rowheaders="No" rowheaderalign="LEFT" rowheaderitalic="No"
rowheaderbold="No" colheaders="Yes" colheaderalign="CENTER"
colheaderitalic="No" colheaderbold="No" bgcolor="Teal"
selectmode="BROWSE" picturebar="No">
</cfgrid>
</cfform>
<cfdump var="#ShowTableData#">

</cfoutput>
</cfloop>

Can CFGRID not be in a loop like this? How can I get an update for my remaining tables?

Thanks in advance for any help.
mickeyj2