[thelist] [SPAM] Re: tough: sql solution for finding available days foranappointment

[Anthony Baratta]

-----Original message-----
From: "Matt Warden" mwarden at gmail.com
Date: Tue, 11 Apr 2006 12:17:43 -0700
To: "thelist at lists.evolt.org" thelist at lists.evolt.org
Subject: [SPAM] Re: [thelist] tough: sql solution for finding available days foranappointment
> 
> Ok, looks like the concensus is to use a table with the date set in
> it. The problem as I have stated it is actually a very simplified
> version, but I think I can get this idea to work. I'm just a little
> worried about performance.

Matt..

There are a few user defined functions on the web that help you get back all dates within a specific range. Would that be helpful? I have a copy of MS SQL, but it could probably be ported to mySQL 5.

Let me know and I'll see if I can find my copy.