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/
