[thelist] comparing form data to database data

David McCreath mccreath at ak.net
Fri Oct 27 09:36:48 CDT 2000

Hi, Tab --

> Do you *have* to verify the range before doing the insert?

I'm not sure I understand the direction you're going. My approach was to
make sure that the SubStartDate and SubEndDate are between the ActStartDate
and ActEndDate *before* they're inserted so I don't end up with bad data.

> Cause otherwise you can just insert everything into the database, and then
> do a:
> SELECT * FROM Table WHERE (SubstitutesStartDate BETWEEN ActivityStartDate
> AND ActivityEndDate) AND (SubstitutesEndDate BETWEEN ActivityStartDate AND
> ActivityEndDate)

I think maybe I didn't explain my task well enough, but later on in the
process, an activity summary is created by pulling all the related info
(including the subs) from a few tables based on the activity ID.

By checking the date ranges prior to insert, I don't have to check them when
I pull them back out.

Does that make sense? Or have I missed the point of your suggestion?


More information about the thelist mailing list