[thelist] [SPAM] Re: tough: sql solution for finding available days foranappointment
Anthony Baratta
anthony at baratta.com
Tue Apr 11 17:22:48 CDT 2006
-----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.
More information about the thelist
mailing list