Couldn't you just do something like check the value of
queryname.recordcount, or, instead of <cfoutput query=>, loop through the
query and check for when the index hits 5?
Todd Ashworth
----- Original Message -----
From: "Jeff Fongemie" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 06, 2000 11:38 AM
Subject: Re: How the heck can I do this?
| As it stands, the output will show all bids. I need it to show a place
| holder
|
| for the first top 4 bids like $$$$ and show the 5th highest bid. The idea
is
|
| that the bidders can't see the top 4 bids.
|
| Jeff Fongemie
|
|
|
|
|
| <CFQUERY NAME="getbids" DATASOURCE="hclimb">
|
| SELECT bidsID, firstName, lastName, EmailAddress, HomePhone, BidAmount,
|
| BidDate, Alias
|
| FROM bids
|
| ORDER BY bidAmount desc</CFQUERY>
|
|
|
| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
|
| <html>
|
| <head>
|
| <title>Bids Are...</title>
|
| </head>
|
| <body>
|
| <TABLE CELLPADDING="2" CELLSPACING="2" BORDER="0">
|
| <TH>Alias</TH> <TH>Amt. Bid</TH> <TH>Bid Date</TH>
|
| <CFOUTPUT QUERY="getbids" maxrows=5>
|
| <TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FFFFFF'), DE ('grey'))#>
|
| <TD>#Alias#</TD> <TD>#BidAmount#</TD> <TD>#BidDate#</TD>
|
| </TR>
|
| </CFOUTPUT>
|
| </TABLE>
|
| </body>
|
| </html>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
