display value

[kt03]

1)I have the drop down box to display all different table names. When user selected one table from this dropdown then it passed it value to the next page.

2)On the next page, I have the query
<cfquery name="tableselected" datasource="#DSN#">
select * from #form.tableSelected#
</cfquery>

3)On this page, I want to display the Id for each record but I don’t know how since this is the dynamic page and it depended on what table they selected on #1.
<cfouput>
<cfloop index = "rowNum" from = "1" to = #qTableSelected.recordCount#>
#tableselected[Column][rowNum]#
<cfouput>
With this code, I was able to display all the name from this table but don't know how to display the id that associated with each name.
Thanks

[Dan_Bracuk]

Loop throught the columnlist for the query. Details are in the cf reference manual under cfloop and cfquery.

If you don't have a manual, the internet does.

[kt03]

yes i did that, please look at my latest edit.

Thx

[Dan_Bracuk]

do it like this
<cfoutput query ="yourquery">
<cfloop List = "#yourquery.columlist# index = "ThisColumn">
#tableselected[thiscolumn][rownumber]
closing tags