Hi Chris,
Can't you 'join' and sort it in the database? Or at least do the query in the db and then use queryofquery (?) to re-sort the data on the page?
As for structs and arrays, sorting and ordering is always a problem - or maybe I'm just too lazy to spend the time working out the niceties...
Perhaps if you can provide a bit more information, including db table structures, so we could provide a better answer.
Brett B)
Chris Silwedel wrote:
I have data coming from various db tables and fields and I thought combining
them into a structure would be a good method to sort the various items by
date.
For instance the structure would consist of the following keys populated by data from various tables and fields:
- date - title - description
Is an array infact the best method to do this, if so - how do I sort by date? I've not yet been able to successfully do this.
If there's a better way of doing this I'd love to have some suggestions. Perhaps do a QueryNew() ?
For a lil extra info on what I'm trying to achieve at the end of the day, I want to display this data in a calendar as well as having a summary of all the data on the same page, sorted by date.
Thanks in advance!
Chris
--- 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/
-- Brett Payne-Rhodes Eaglehawk Computing t: +61 (0)8 9371-0471 f: +61 (0)8 9371-0470 m: +61 (0)414 371 047 e: [EMAIL PROTECTED] w: www.ehc.net.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/
