3 Replies Latest reply on Aug 8, 2008 4:32 PM by Dan Bracuk

    display value

    kt03 Level 1
      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