0

I have downloaded CF successfully and have been successful in connecting to my own database. However, I am following the Developer Center Tutorial for creating a record set and table to display the query in DreamWeaver. It all works as advertised however I am only getting the first entry in the table. If I change to descending seq I get the last entry.

<cfquery name="players" datasource="connsilvereagles">
SELECT *
FROM player
ORDER BY playernumber DESC</cfquery>

Appreciate in advance what error I may be doing wrong. FYI CF8 and DW8
Thanks.
:Bob

2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by bvaz
1

Have you added a loop to display the output?

<cfquery name="players" datasource="connsilvereagles">
SELECT *
FROM player
ORDER BY playernumber DESC</cfquery>

<cfoutput>
<table>
<cfloop query="players">
<tr><td>#playernumber#</td></tr>
</cfloop>
</table>
</cfoutput>
Votes + Comments
Good job
0

gosh how stupid! thanks a lot, buddylee. appreciate you taking the time

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.