Automobiles by Roshni of Beverly Hills

90210

The purpose of this form and the companion Access table, is to show you how various form elements work with the database.pl script, and how they integrate with Access data types. But you might as well have some fun. Imagine you just hit the lotto and have surfed to this page, to pre-order your car so it's ready when you move to Rodeo Drive (that's ro-DAY-o, ok?)

The document source contains lots of comments about fields and how to use them.

These are just your standard, run-of-the-mill html text boxes. Note that MAXLENGTH is used to control size of input, and this matches the Access table size.

Please give us your name and address, so we will know where to deliver your luxury automobile.

Name:     
Address1:
Address2:
City:         State: Zip:
Country:   Phone:

Please provide a desired delivery date, formatted like 06/15/1998:   
Note: the Access table expects the formatting to be correct on this since it has a date field for the import. Making the Access field "text" will avoid any import errors from bad input, but you'd lose the ability to work with dates effectively.

Which automobile should be reserved for you?  

And which color do you prefer?    Burgundy    Taupe    Azure    Green

Would you like a jar of Grey Poupon left in a conspicuous place? Yes    No, thank you
Note the above (Grey Poupon) question will save TRUE or FALSE to the single field, named greypoupon. This is one way of representing a logical field for Access. We could have used two checkboxes, but hey, radio buttons are cool.

Check here if you'd like to have a chauffeur named James
The James question is also representing a logical field. A single checkbox works like this because Access defaults to "FALSE" for an empty value (if the checkbox is unchecked). Note that you cannot "require" such a checkbox!

Checkboxes may also be used to capture multiple choices into one field. The choice (VALUEs) get put together, separated by commas and stored as one string in a text field:
Please check all the extras you need, all complimentary, of course!

Lumbar Support
Recarro Seats
Television
Surround Sound
Titanium Alloy Wheels
Italian Leather
Moonroof

Any additional requests for your luxury automobile?

Note that new lines and hard returns are not saved in the datafile. This is because everything has to fit on one line.