was to produce a dynamically generated page which would provide
website visitors with links to the websites of homebuilders in their
state that are participating in Simpson Strong-Tie's "Well-Connected
House Builder Program."
An ASP page
was designed which uses ADO to connect with a Microsoft Access database
holding the Builder Program data. The website visitor selects a
state from a drop-down list box, and the ASP code then executes
a SQL query on the database to return and display all the "Well-Connected
House Builders" in that state, including the builder's name,
builder's logo image, and the URL of the builder's website.
the "Find A Builder" page
Note: This website
has since been revised by my successor.