> current row = 1 > loop through your date range, day by day > numrecords = 0 > output the current date > loop while (using array notation) test and see if the date in > record[current row] matches the current day > numrecords = numrecords + 1 > end loop > output numrecords > end loop
There's no problem writing this sort of code, but your suggesting using a loop (well, 2 actually) which is exactly what I wanted to avoid -- if the database can be cajoled to return the required query without having to post-process it, then I'm laughing. I'm looping at the mo, but hopefully the mailing list I've just joined may have a suggestion. Thanks anyway! -- Aidan Whitehall <mailto:[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards> ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
