Sorry, I missed a bit out, when I write the database using my own script, it writes a record for each room for each day, for the length of the desired record. I show two months in advance.
The time stamp for a day is set for 12:00:00 (midday)
My query to the database then goes like this:
Is the room vacant? test unique field, (if yes) Is it vacant between these days? .........
test date1 field with >time stamp of 11:59:00, test date2 field with <time stamp of 12:01:00
What I attempted to do, was to test only one date field with two different arguments, that was where I came unstuck. (but is this possible?)
I have tried the following:
#give value to query
$config{'time'} = ">$config{'checkin'}++<$config{'checkout'}";
#send query within submit routine
<input type=hidden name="Checkin" value="$config{'time'}">
But the database does not reconise the second part of the query '<$config{'checkout'}'
---------------------------------------
With regard to seeing which rooms are vacant/occupied for part of a period between two given days, DBman does this in its logic (daah I was not thinking too good)
------------------------------------------
Next issue, In the DBman demo, one field is a URL, and the record displayed has an active hyperlink to whatever. I have tried to use this so that a record can have a link to more information, such as guest name etc. I cannot get the record that is displayed to show a active hyperlink? could this be my .db format, I used \t for a delimiter, or is this issue something more complex?
rgs Peter.
The time stamp for a day is set for 12:00:00 (midday)
My query to the database then goes like this:
Is the room vacant? test unique field, (if yes) Is it vacant between these days? .........
test date1 field with >time stamp of 11:59:00, test date2 field with <time stamp of 12:01:00
What I attempted to do, was to test only one date field with two different arguments, that was where I came unstuck. (but is this possible?)
I have tried the following:
#give value to query
$config{'time'} = ">$config{'checkin'}++<$config{'checkout'}";
#send query within submit routine
<input type=hidden name="Checkin" value="$config{'time'}">
But the database does not reconise the second part of the query '<$config{'checkout'}'
---------------------------------------
With regard to seeing which rooms are vacant/occupied for part of a period between two given days, DBman does this in its logic (daah I was not thinking too good)
------------------------------------------
Next issue, In the DBman demo, one field is a URL, and the record displayed has an active hyperlink to whatever. I have tried to use this so that a record can have a link to more information, such as guest name etc. I cannot get the record that is displayed to show a active hyperlink? could this be my .db format, I used \t for a delimiter, or is this issue something more complex?
rgs Peter.