Generating web scripts

Capturing data from an HTML form

Some web templates allow you to specify an HTML page containing a form and associate the form elements on that page with specific columns in a database table. MacSQL will then modify your HTML page to contain the appropriate code to handle form submission.

If the HTML page you select has more than one form, you will be prompted to select which form you would like to script. MacSQL currently only supports working with a single form.

After you have selected the form (or if there is only one form), MacSQL will parse the HTML and ask you to specify how to handle each form input. For every input element, you will be prompted to select the field the form value should be stored in, and you can decide if that field is required or not.

For <TEXTAREA> and <INPUT TYPE=text ...> form fields, you will also be able to specify the minimum number of characters required, if the case should be changed (for example, some database administrators prefer certain values to always be uppercase), and a validation to perform on the text value.

The following validations can be performed:

• Integer
      The value must be a whole number
• Alpha Numeric
      The value must consist of only letters and numbers.
• Contains non-Alpha Numeric
      The value must contain a non-alphanumeric value.
• Credit Card Expiration
      The value must contain a valid date in the format MM/YYYY.
• Date
      The value must contain a date in the format MM/DD/YYYY.