ColdFusion

simple query from newbie

Please support our ColdFusion advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Nov 2008

Posts: 6

Reputation: bvaz is an unknown quantity at this point

Solved Threads: 0

bvaz

Offline

Newbie Poster

simple query from newbie

Feb 21st, 2009

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.

 Help with Code Tags 
 coldfusion Syntax (Toggle Plain Text) 
  <cfquery name="players" datasource="connsilvereagles">
SELECT *
FROM player
ORDER BY playernumber DESC</cfquery>
  <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

Last edited by peter_budo; Feb 25th, 2009 at 6:06 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Nov 2007

Posts: 596

Reputation: buddylee17 has a spectacular aura about

Solved Threads: 125

buddylee17 buddylee17 is offline

Offline

Posting Pro

Re: simple query from newbie

Feb 25th, 2009

Have you added a loop to display the output?

 Help with Code Tags 
 coldfusion Syntax (Toggle Plain Text) 
<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>
<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>