simple query from newbie

[bvaz]

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

[buddylee17]

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>

[bvaz]

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