Gossamer Forum
Home : Products : DBMan : Customization :

Search time on the time of the search

Quote Reply
Search time on the time of the search
Hi, I have a little problem here. I have a database of Organizations with Operation Hours in this format.

mon_open = X;
mon_close = X;
...
Sun_open = X;
Sun_close = X;

And X are 24 Hours, Closed, 12:00 AM, 1:00 AM, ... , 11:00PM

Now I need to have a way to search for Organizations that are open the time I started my search without inputing the time and without have a time as a hidden value in my html.pl.

I don't know if I am stating this clearly, but someone please help.

I want to have a button in my search form that states "Open Now?" and when I click on it and search. I want it to search the database for all the Organizations that are opened at the time the search was started. I do not want to embed this in the html because if I leave the page open for a hour and than click on it, it would be a hour late. So in another word, I need the time search done on processing time.

Thank you so much.

Scott Wang


Subject Author Views Date
Thread Search time on the time of the search wangs 3970 Jul 3, 2000, 2:05 AM
Thread Re: Search time on the time of the search
JPDeni 3892 Jul 3, 2000, 3:18 AM
Thread Re: Search time on the time of the search
wangs 3877 Jul 3, 2000, 8:01 PM
Thread Re: Search time on the time of the search
JPDeni 3890 Jul 4, 2000, 1:33 AM
Thread Re: Search time on the time of the search
wangs 3876 Jul 4, 2000, 2:49 AM
Thread Re: Search time on the time of the search
JPDeni 3850 Jul 4, 2000, 4:31 AM
Thread Re: Search time on the time of the search
wangs 3881 Jul 4, 2000, 6:20 AM
Thread Re: Search time on the time of the search
JPDeni 3870 Jul 4, 2000, 6:49 AM
Thread Re: Search time on the time of the search
wangs 3861 Jul 4, 2000, 3:31 PM
Thread Re: Search time on the time of the search
JPDeni 3855 Jul 5, 2000, 10:04 AM
Thread Re: Search time on the time of the search
wangs 3877 Jul 5, 2000, 11:24 AM
Thread Re: Search time on the time of the search
JPDeni 3864 Jul 5, 2000, 11:36 AM
Thread Re: Search time on the time of the search
wangs 3846 Jul 5, 2000, 11:52 AM
Thread Re: Search time on the time of the search
wangs 3861 Jul 5, 2000, 11:54 AM
Thread Re: Search time on the time of the search
wangs 3876 Jul 5, 2000, 12:00 PM
Thread Re: Search time on the time of the search
JPDeni 3853 Jul 5, 2000, 12:08 PM
Post Re: Search time on the time of the search
wangs 3853 Jul 5, 2000, 12:14 PM