How can I display the data that is queried from my database using a cold fusion form search in a table. I have tried to put the results in a table but all I get is the same result repeated more than once across. How can I get the results to be displayed in a table that is two colums across and 20 rows down without having the results being displayed twice. I hear that I need to create a counter to assign numbers to each result so they are not repeated if so how can i do this and set up this table. Thanks for your help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Display Cold Fusion Query data in a two column Table
- Thread starter tjg
- Start date
tjg,
Two columns in your query result:
<table border="1" cellspacing="0">
<tr><td>Your First Column Header</td><td>Your Second
Column Header</td></tr>
<cfoutput query="yourquery">
<tr>
<td>#Yourfirstcolumn#</td><td>#Yoursecondcolumn#</td>
</tr>
</cfoutput>
</table>
Is this what you're doing? Why does your query return
duplicate results?
HTH,
PH
Two columns in your query result:
<table border="1" cellspacing="0">
<tr><td>Your First Column Header</td><td>Your Second
Column Header</td></tr>
<cfoutput query="yourquery">
<tr>
<td>#Yourfirstcolumn#</td><td>#Yoursecondcolumn#</td>
</tr>
</cfoutput>
</table>
Is this what you're doing? Why does your query return
duplicate results?
HTH,
PH
- Status