Prevent entry to dates if book out

[Guest]

So close yet so far -I really would appreciate some help if anyone had a little time? I was wondering if there was a site or tutorial somewhere (I have looked long and hard) at how to prevent users from booking a date if the date is already full? Using ASP, Dreamweaver MX and Mic Access dbase
I have all forms working and passing information, I have script working to limit number of entries, but once a particular date gets full it is blocking any other dates being entered.
Could anyone help at all?
Many thanks

[Newsgroup_User]

The first thing you have to do is check to see if the date is available
before you do the insert to the database.
Dave
"mbdreammx" <webforumsuser@macromedia.com> wrote in message
news:es7hom$bkr$1@forums.macromedia.com...
> So close yet so far -I really would appreciate some help if anyone had a
little
> time? I was wondering if there was a site or tutorial somewhere (I have
looked
> long and hard) at how to prevent users from booking a date if the date is
> already full? Using ASP, Dreamweaver MX and Mic Access dbase
> I have all forms working and passing information, I have script working
to
> limit number of entries, but once a particular date gets full it is
blocking
> any other dates being entered.
> Could anyone help at all?
> Many thanks
>
>

[Newsgroup_User]

Can you provide a little more information as to what type of booking system
you are trying to build?
Is the date for a room a table or what ever?
There are a couple of ways to go about this but you didn't give us very much
information go on for what it is you want to do?
Dave

"mbdreammx" <webforumsuser@macromedia.com> wrote in message
news:es7hom$bkr$1@forums.macromedia.com...
> So close yet so far -I really would appreciate some help if anyone had a
little
> time? I was wondering if there was a site or tutorial somewhere (I have
looked
> long and hard) at how to prevent users from booking a date if the date is
> already full? Using ASP, Dreamweaver MX and Mic Access dbase
> I have all forms working and passing information, I have script working
to
> limit number of entries, but once a particular date gets full it is
blocking
> any other dates being entered.
> Could anyone help at all?
> Many thanks
>
>

[Guest]

Thanks for answering Dave - can I post you what I have?

[Newsgroup_User]

Sure
Dave
"mbdreammx" <webforumsuser@macromedia.com> wrote in message
news:es807l$rfp$1@forums.macromedia.com...
> Thanks for answering Dave - can I post you what I have?

[Guest]

Hi Dave
I was wondering if you had a chance to look at this code at all? Thanks
M