Jennifer-
You don't need to carry your own counter. The queryName.CurrentRow variable
stores it for you during a <cfloop query="queryName"> or <cfoutput
query="queryName">
-----Original Message-----
From: Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 12:00 PM
To: [EMAIL PROTECTED]
Subject: Re: How the heck can I do this?
At 08:19 AM 7/6/00 -0400, you wrote:
>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.
Ok, in your output, use cfloop instead of cfoutput. Loop through the query
and use a counter in the loop (if you need more info on this, let me know,
but it's pretty basic, so I'll assume you can figure it out). When the
counter is 5, you will change the information that is sent to the browser.
So you'd do something like this (I don't guarantee the code because I'm not
testing it):
<cfset i=1>
<cfloop query="yourqueryname">
<cfif i LT 5>
#bidder# #biddercontact#
<cfelse>
#bidder# #biddercontact# #bid#
</cfif>
</cfloop>
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.
