Re: [How the heck can I do this?]
cfquery name="topbids" select bidder, top 5 bidAmt from tblBids order by bidder group by bidAmt, bidder /cfquery cfoutput query="topbids" #bidder# cfif currentrow eq 1 - #bidAmt# /cfif /cfoutput I might be a little off on the syntax - not looking at a reference right now. -- Billy Cravens [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: try max rows 1. if that doesnt work try cfloop instead of cfoutput and then put in a cfbreak. i am sure there is a better way though. "Jeff Fongemie" [EMAIL PROTECTED] 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. Thanks, Jeff Fongemie -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How the heck can I do this?
can you post the code? -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 5:19 AM To: [EMAIL PROTECTED] Subject: How the heck can I do this? 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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 titleBids Are.../title /head body TABLE CELLPADDING="2" CELLSPACING="2" BORDER="0" THAlias/TH THAmt. Bid/TH THBid Date/TH CFOUTPUT QUERY="getbids" maxrows=5 TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), DE ('grey'))# TD#Alias#/TD TD#BidAmount#/TD TD#BidDate#/TD /TR /CFOUTPUT /TABLE /body /html "Steve DeWitt" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... can you post the code? -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 5:19 AM To: [EMAIL PROTECTED] Subject: How the heck can I do this? 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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How the heck can I do this?
Use a counter to count rows. cfif RowNum Mod 5 eq 0#BidAmount#/cfif Lon Lentz Applications Developer - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 8:19 AM To: [EMAIL PROTECTED] Subject: How the heck can I do this? 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. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 titleBids Are.../title /head body TABLE CELLPADDING="2" CELLSPACING="2" BORDER="0" THAlias/TH THAmt. Bid/TH THBid Date/TH CFOUTPUT QUERY="getbids" TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), DE ('grey'))# TD#Alias#/TD TD#BidAmount#/TD TD#BidDate#/TD /TR /CFOUTPUT /TABLE /body /html -Original Message- From: Steve DeWitt [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 9:43 AM To: 'Jeff Fongemie ' Subject: RE: How the heck can I do this? can you post a code sample? -Original Message- From: Jeff Fongemie To: [EMAIL PROTECTED] Sent: 7/6/00 5:19 AM Subject: How the heck can I do this? 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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How the heck can I do this?
try this (replacing the table/field names of course): select top 5 bid from bid_table order by bid_desc as far as hiding all but the 5th bid, it would probably be easiest to just do a cfif bid_query.currentrow neq 5 type thing. HTH Jon Jeff Fongemie 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. Thanks, Jeff Fongemie -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Jon Boehnker [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How the heck can I do this?
Jeff, It looks like you only need a CFIF statement that checks the current row being processed by the CFOUTPUT statement, such as: CFOUTPUT QUERY="getbids" maxrows=5 TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), DE ('grey'))# CFIF CurrentRow IS NOT 5 TDAnonymous/TD TD/TD TD#BidDate#/TD CFELSE TD#Alias#/TD TD#BidAmount#/TD TD#BidDate#/TD /CFIF /TR /CFOUTPUT Hope it helps! dBIII+ -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 11:39 AM To: [EMAIL PROTECTED] 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 titleBids Are.../title /head body TABLE CELLPADDING="2" CELLSPACING="2" BORDER="0" THAlias/TH THAmt. Bid/TH THBid Date/TH CFOUTPUT QUERY="getbids" maxrows=5 TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), DE ('grey'))# TD#Alias#/TD TD#BidAmount#/TD TD#BidDate#/TD /TR /CFOUTPUT /TABLE /body /html "Steve DeWitt" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... can you post the code? -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 5:19 AM To: [EMAIL PROTECTED] Subject: How the heck can I do this? 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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How the heck can I do this?
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 | | titleBids Are.../title | | /head | | body | | TABLE CELLPADDING="2" CELLSPACING="2" BORDER="0" | | THAlias/TH THAmt. Bid/TH THBid Date/TH | | CFOUTPUT QUERY="getbids" maxrows=5 | | TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), 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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How the heck can I do this?
Why don't you put a CFIF... in the output ? TABLE CELLPADDING="2" CELLSPACING="2" BORDER="0" THAlias/TH THAmt. Bid/TH THBid Date/TH CFOUTPUT QUERY="getbids" maxrows=5 TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), DE ('grey'))# TD#Alias#/TD TDCFIF CurrentRow eq 5#BidAmount#CFELSE$/CFIF/TD TD#BidDate#/TD /TR /CFOUTPUT /TABLE Laure - Original Message - From: Jeff Fongemie [EMAIL PROTECTED] Newsgroups: cf-talk To: [EMAIL PROTECTED] Sent: Thursday, July 06, 2000 5:38 PM 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 titleBids Are.../title /head body TABLE CELLPADDING="2" CELLSPACING="2" BORDER="0" THAlias/TH THAmt. Bid/TH THBid Date/TH CFOUTPUT QUERY="getbids" maxrows=5 TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), DE ('grey'))# TD#Alias#/TD TD#BidAmount#/TD TD#BidDate#/TD /TR /CFOUTPUT /TABLE /body /html "Steve DeWitt" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... can you post the code? -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 5:19 AM To: [EMAIL PROTECTED] Subject: How the heck can I do this? 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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How the heck can I do this?
Use conditional logic to display only the 5th record or better yet, output only the 5th record by using the startrow attribute in your CFOUTPUT QUERY statement. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 8:39 AM To: [EMAIL PROTECTED] 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 titleBids Are.../title /head body TABLE CELLPADDING="2" CELLSPACING="2" BORDER="0" THAlias/TH THAmt. Bid/TH THBid Date/TH CFOUTPUT QUERY="getbids" maxrows=5 TR BGCOLOR=###IIF(getbids.currentrow MOD 2, DE ('FF'), DE ('grey'))# TD#Alias#/TD TD#BidAmount#/TD TD#BidDate#/TD /TR /CFOUTPUT /TABLE /body /html "Steve DeWitt" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... can you post the code? -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 5:19 AM To: [EMAIL PROTECTED] Subject: How the heck can I do this? 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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How the heck can I do this?
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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [How the heck can I do this?]
try max rows 1. if that doesnt work try cfloop instead of cfoutput and then put in a cfbreak. i am sure there is a better way though. "Jeff Fongemie" [EMAIL PROTECTED] 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. Thanks, Jeff Fongemie -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How the heck can I do this?
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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.