Jeff,
I think you are actually bringing down the entire
record set by specifying Maxrows="5"
If you are using Sql Server use
Select Top 5 Bid_Price, Bidder_Name, Bidder_Address ..
from Auction_Bid_Table
This will only bring down the record set, you need.
If you only want to show the 5th max bidder price,
In your cfoutput, use a count variable and display the
the 5th only when the var is 5
<cfset x="0">
<cfoutput query="Get_5maxBidder">
<cfset x=x+1>
#name#
<cfif x eq "5">#5thMaxBidder#</cfif>
</cfoutput>
hope this helps
Joe
--- Original Message ---
"Jeff Fongemie" <[EMAIL PROTECTED]> Wrote on
Thu, 6 Jul 2000 08:19:11 -0400
------------------
I'm setting up a real simple auction application. Super simple.
People
submit bids via a form, then the top 5 bids are displayed on
a page. The
catch is, I only want the 5th highest bid to show the actual
bid.
So, I can order the query by bid descending and for output bids
1 through 5
will give the bidders name, but I need to have the bid amounts
hidden for
the top 4 bids, and show the 5th.
To display only the top 5 bids, I'm using maxrows =5 in my output.
Is there
a way to control all this stuff with the SQL, or do I have a
basic query,
order by bid desc. and control the results through output?
With the output method, I can't seem to be able to get the results
to
populate the 5th bid amt., but not the first 4.
Thanks,
Jeff Fongemie
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.
-----
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
