Can you check if the recordCount of the query is less than 3, then re-do the query so it includes the first (number less than 3 ot the recordcount) records of the query as well as the last 1 or 2?
We might need to see some of your code to get a better idea of how you are pulling the ads out. seeya! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Knott, Brian Sent: Friday, 21 February 2003 11:02 AM To: CFAussie Mailing List Subject: [cfaussie] Loop problem Hi guy hope you all enjoyed MXDU, been quite on the list the last few day. No Scott. Anyway I'm writing an quick banner program. The problem I have got is basically this. I want to return 3 ads to be displayed. I have a table that contains the ads. I also have a table that contains the last ad displayed. What I need to do is get the next 3 ads after the ad displayed, no problems there. The problem is if its the second last ad or last ad then it needs to go back to the start of the list and get 1 or 2 ads to make up the 3. I'm presently using loops. Any ideas Brian Knott --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
