I am using DBman as the back end for a room reservation program, for a small resort.
I wish to do two separate range searches, one to show vacant rooms within a specified date range,
and one to show occupied rooms within a specified date range.
First I create a database with a 69 day span, (severn days prior to localtime and two months in advance)
When a room is booked a new value for 'field 1' is printed using the modify_form sub.
So: 'field 1' with value 'unique0' = vacant
and 'field 1' with 'unique1' = occupied
Simple, I can now search and display the vacant rooms or the occupied rooms by searching either
for unique0 or unique1.
But I don't want to see all the days up until the end of the records that a room is vacant or occupied,
I wish only to see the results between two specified dates.
This is what I have tried passing, but I can only get dbman to reconize the first part of the date range.
/cgi-bin/db.pl?db=default&uid=&OC=unique1&ID=&Room+%23=&Date=%3E1135051260+%3C1135569660&Type=---&Rate=&Persons=&Customer=&Checkin=&Checkout=&Comments=&keyword=&view_records=View+Records
Can someone please help me with the syntax?
rgs Peter.