Sure, that is easy. Just add a column to your room assignment table called
something like "RELEASE_TIME", and put into that column the time you want
the room to be released. Then, whenever you want to release rooms, execute
something like "DELETE FROM ROOM_ASSIGN WHERE RELEASE_TIME > NOW()"
Hi,
Just wanted to thank everyone for all the suggestions.
cheers,
Hasan
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Hasan Niyaz" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 1:45 AM
Sub
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Hasan Niyaz" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 05, 2001 1:45 PM
Subject: Re: events that i can trigger on intervals.
> On Tue, Jun 05, 2001 at 11
On Tue, Jun 05, 2001 at 11:27:33PM +0500, Hasan Niyaz wrote:
> Hi,
>
> I have a room inventory. Clients can block rooms them but I want to
> release them after a specified time if they do not release them
> normally via the given link. I want to be able to trigger an event
> to release the rooms
On 05-Jun-01 Hasan Niyaz wrote:
> Hi,
>
> I have a room inventory. Clients can block rooms them but I want to
> release them after a specified time if they do not release them
> normally via the given link. I want to be able to trigger an event to
> release the rooms after the time limit.
> Is t
"Hasan Niyaz" writes:
>Hi,
>
>I have a room inventory. Clients can block rooms them but I want to release t
>hem after a specified time if they do not release them
>normally via the given link. I want to be able to trigger an event to release
> the rooms after the time limit.
>Is there any
