Howdy, I recently took over a CF 4.51 site and am in the process of redesigning it for a client. Database is MS Access. The site is for a massage company that lets corporate clients sign up for on-site massages. Administrators can print copies of the day's on-site massage appointment schedule for massage therapists to take with them to a client's site.
Anyway, I'm wondering about the best way to handle building the appointment schedules. The way it is right now, a day's schedule of appointments is created by looping over an "event" (a date/location) and then an inner loop hits the database for each time slot and builds the appointment/schedule table. There are only about 20 appointment slots per event schedule, but this doesn't seem very efficient to me. For those of you who've worked with building date/time schedules, would it make more sense to convert to using arrays or structures for something like this? I can show representative blocks of code the way it is right now if necessary. Thanks in advance for your thoughts. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 AIM: Airtightweb ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
