simple query from newbie

Expand Post »

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.

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.

Similar Threads

help a newbie? mySQL find & replace in MySQL
Newbie - looping and array [very simple] problem in PHP
Report w/Cateories/subcategories in PHP
Java newbie in Java
how to send dns query through C program? in C++

bvaz

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Nov 2008

Permalink

Feb 25th, 2009

Re: simple query from newbie

Have you added a loop to display the output?

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>

buddylee17

Reputation Points: 232

Solved Threads: 137

Practically a Master Poster

Offline

665 posts
since Nov 2007

Permalink

Feb 25th, 2009

Re: simple query from newbie

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

bvaz

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Nov 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ColdFusion Forum Timeline: a streaming server query

Next Thread in ColdFusion Forum Timeline: New to this and a little ignorant, but need help

DaniWeb Message

Cancel Changes

User Name
Password