5849l3

Listing 3. The ZSQL Method insert_address_data

    INSERT INTO AddressBook
        (first_name, last_name, address1,
         address2, city, state_province, 
         postal_code, phone_number, fax_number, cell_number)
    VALUES
        (<dtml-sqlvar first_name type="string">,
         <dtml-sqlvar last_name type="string">,
         <dtml-sqlvar address1 type="string">,
         <dtml-sqlvar address2 type="string">,
         <dtml-sqlvar city type="string">,
         <dtml-sqlvar state_province type="string">,
         <dtml-sqlvar postal_code type="string">,
         <dtml-sqlvar phone_number type="string">,
         <dtml-sqlvar fax_number type="string">,
         <dtml-sqlvar cell_number type="string">)