Either that or you could use query of query which is liable to be faster than what you have now but a tad slower than using an array of structures. I'd probably use an array for days of the month and a structure for events on that day with HH:mm as the structure key for the event -- that way the events will automatically show up in chronological order if you display them using a collection loop on the structure. Just make sure you use 24 hr time for the structure key, whether you display the time in 24 hour format or not.
> "kinda sorta" along those lines: > I have a calendar that I am doing a loop within each day > to query each > days events for that calendar month. > I've wondered if: an array or structure (hyperlink title > and event id) > would > run faster?? thought i would ask the group > Right now my execution time for a 30 day month is 350ms > * running CFMX professional on a win2k box > ** as a sidebar i installed the MX updater package which > is essential > all the macromedia patches >>>> [EMAIL PROTECTED] 02/04/03 04:22PM >>> > Looks like CFMX handles structures differently than CF. > There are 2 > different ways to set a structure's key: > <cfset stTest = StructNew()> > <cfset stTest.Key1 = ""> > <cfset stTest["Key2"] = ""> > In CF5 and earlier versions, the key would be returned as > Upper Case > text, regardless of which approach you used to set the > structure's > keys. > In MX, however, the key is returned in whatever case you > use for the > key > name when using the second approach above. This is > important if you > use > XSL stylesheets to render data sourced from a structure. > I spent the > better part of a day trying to figure out why my > stylesheets are not > rendering in MX. Hope this saves you some time. > Thanks - > Tom Schreck > 817-252-4900 > [EMAIL PROTECTED] > I have not failed. I've found 10,000 ways that won't > work. > - Thomas Edison > ----------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To unsubscribe: > Send UNSUBSCRIBE to [EMAIL PROTECTED] > To subscribe / unsubscribe: http://www.dfwcfug.org s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
