Book.asp

Thank You!

Database Results Error The database connection named 'fredtest' is undefined. This problem can occur if: * the connection has been removed from the web * the file 'global.asa' is missing or contains errors * the root folder does not have Scripting permissions enabled * the web is not marked as an Application Root One or more form fields were empty. You should provide default values for all form fields that are used in the query. Database Results Error The database connection named 'fredtest' is undefined. This problem can occur if: * the connection has been removed from the web * the file 'global.asa' is missing or contains errors * the root folder does not have Scripting permissions enabled * the web is not marked as an Application Root Database Results Error The database connection named 'fredtest' is undefined. This problem can occur if: * the connection has been removed from the web * the file 'global.asa' is missing or contains errors * the root folder does not have Scripting permissions enabled * the web is not marked as an Application Root One or more form fields were empty. You should provide default values for all form fields that are used in the query.Database Results Error The database connection named 'fredtest' is undefined. This problem can occur if: * the connection has been removed from the web * the file 'global.asa' is missing or contains errors * the root folder does not have Scripting permissions enabled * the web is not marked as an Application Root One or more form fields were empty. You should provide default values for all form fields that are used in the query.

Click here to book another date

How To...

This page contains four database results regions which we will refer to as DBRR1, DBRR2, DBRR3 and DBRR4.

DBRR1 - Displays the company name based on the companyID passed from the listings.asp page:

Insert > Database > Results.
Select connection and then "company" from step two as the record source.
In step three, click More Options and then Criteria.
Set the criteria to companyID = companyID.
In step four, select List - one field per item and uncheck the field label boxes.
In step five, uncheck the Add Search box and click finish.

DBRR2 - Inserts the dateID and companyID into the bookings table:

Insert > Database > Results.
Select connection and then in step two select Custom Query and then the Edit button.
Insert the following SQL code:
Click OK and then finish the wizard.

DBRR3 - Displays the date that was selected from listings.asp:

Insert > Database > Results.
Select connection and then "dates" from step two as the record source.
In step three, click More Options and then Criteria.
Set the criteria to dateID = dateID.
In step four, select List - one field per item and uncheck the field label boxes.
In step five, uncheck the Add Search box and click finish.

DBRR4 - Updates the dates table to show this date as booked:

Insert > Database > Results.
Select connection and then in step two select Custom Query and then the Edit button.
Insert the following SQL code:
Click OK and then finish the wizard.

Finally, your page should look something like this:

^ Top of page