Member Avatar for 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

  • 2 Contributors
  • 2 Replies
  • 132 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by bvaz
Member Avatar for 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>
commented: Good job +15
Member Avatar for bvaz

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.