On Tue, 15 Mar 2005 21:59:09 +1100, Chad <[EMAIL PROTECTED]> wrote: > Building a calendar. For each day, I want to present the tasks for the > user. > > What is faster: > 1. Query of a query on each day, WHERE TaskDate = CurrentDate > > Or > > 2. Single query, then loop all tasks and if TaskDate EQ CurrentDate, > then display.
3. Single query ORDER BY TaskDate ASC and then a SINGLE loop that builds the calendar and checks for tasks for each day. Use a counter and a loop variable... probably easier to loop over the dates once and explicitly access rows in the query by counter. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! "If you're not annoying somebody, you're not really alive." -- Margaret Atwood --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
