Hmmm... all Greek to me. Right now, I'm building the calendar with something like
<cfloop from="1" to="42" index="ThisCalSquare"> and doing all my stuff in the loop. Thing is, the calendar will be used to present info from many different areas, such as project tasks, recurring maintenance tasks, meeting reminders, etc. In addition, I can filter the information by employee, project type, equipment, what have you. (Filtering by a what have you is a pain, let me tell you). My plan at this stage is to run one query for the parameters at the top, then query the main queries for each day and loop that daily query. The alternative, and reason for the question, was to loop each master query on each day and cfif in the loop. And to really make it complicated, I want to link tasks started on one day with tasks ending on a later day. I've done it before with layers and pixel placement calculations plotted over the table cells, but it's a real head job. Chad -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Darryl Lyons Sent: Wednesday, 16 March 2005 10:24 AM To: CFAussie Mailing List Subject: [cfaussie] Re: 30 Querys vs. 3000 loops Hands-down one query. If you are building it from scratch, can I suggest looking at returning the calendar data in a struct of arrays? E.g. stCalendar[YYYY][M][D] = {array of tasks ordered chronologically} . I've found this approach is quite scalable and very quick to access and reuse (e.g. a mini-calendar and a large calendar on the same screen) Darryl Lyons http://dangermoose.blogspot.com [EMAIL PROTECTED] wrote on 15/03/2005 08:59:09 PM: > 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. > > Cheers, > > Chad > > > --- > 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/ To unsubscribe from this email please forward this email to [EMAIL PROTECTED] This email message is confidential and may be privileged. If you are not the intended recipient please forward the email to [EMAIL PROTECTED] and delete the original. ABN AMRO Morgans Limited and its associates hold or may hold securities in the companies/trusts mentioned herein. Any general advice included in this email has been prepared without taking into account your objectives, financial situation or needs. Before acting on the advice, you should consider its appropriateness or discuss with one of our investment advisors. ABN AMRO Morgans Limited (ABN 49 010 669 726 AFSL 235410) A Participant of ASX Group. A principal member of the Financial Planning Association. --- 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/ --- 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/
