Here is your company information. Please select an available date from the drop down and press submit to reserve it.

 

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

NOTE: If there are no available dates in the drop down box, you may need to first add some additional dates from this page: AddDates.asp.

How To....

  1. The first thing you need to do on this page is insert a Form object: Insert > Form > Form. This form will contain a dynamically populated drop down list box.
  2. Delete the Reset button.
  3. Place your cursor inside the Form object and to the left of the Submit button and insert a Database Results Region: Insert > Database > Results.
  4. We are going to put two Database Results Regions on this page. The first will be the drop down list for the user to select the Date to Book from. The second will display the users company information that they selected from the previous page.
  5. For the first results region, select the correct data connection, click next, select the correct dates table, click next, edit the database fields in step three to display the DateID and Date fields only. Click More Options and then Criteria. Set the Criteria as in this image:

    Click OK and then OK and then Next to move to step four
  6. On Step four, make your selections as follows. We are going to display the dates available in the list box but the value to be passed to the next page is the unique dateID:

    Click Next.
  7. In the final step of the wizard make sure that display all records together is selected and click Finish.
  8. The second results region is going to display the users company information. Insert > Database > Results. Note that this region is also within the form field properties.
  9. Select your connection in step one and "company" in step two for the record source.
  10. In step three, click More Options and then click Criteria.
  11. Since we passed the companyID from the previous page, we will be setting the criteria to companyID = companyID as follows:
  12. In step four, select List - one field per item and uncheck the field label boxes:
  13. Finally in step five, make your settings like this and click Finish:
  14. You can now apply formatting to the results region. Just remember to keep all of the database column values within the yellow db results region bars. Your page should look something like this:

Please use the form at the top of the page to select a booking date and click the Submit button to go to the next page.

^ Top Of Page