Project: Stewart Enterprises Corporate Website

Purpose: Public website that presents our mission and services, investment information, and career opportunities
Location: http://www.stei.com
User Base: N/A
Platform: Coldfusion 6.1

This is version 2 of our public website that we built in 2006 and explains the company's mission and services and also presents information for investors and available positions. Enhancements over version 1 include: up-to-the-minute stock quote on the home page, a location finder, a more user-friendly Contact Us form, and the ability to search for, view, and apply for currently open job offerings.

The Contact Us and Apply for a Job forms both utilize the Custom Form Validation API. The form contents are stored in database tables, then formatted into an email message and sent to members of our Corporate Communications or Human Resources departments accordingly.

Location Finder:
The Location Finder provides two ways for potential customers to find a location that may provide our services to them.

1. By selecting a state from a map of the U.S. or an alphabetical list
2. By entering an address

When the user enters an address a Google map is rendered, pin-pointing their address and the address of every location within the distance specified in the form.

Both methods yield an alphabetized list of locations matching their criteria.

Code Samples:

• mapResults.cfm - displays results of address/distance searches, using the stored procedure below, and renders a Google map that includes map markers for each location listed
• sp_RosterPropertyRadiusSearch - stored procedure that receives two parameters, SourceZipCode and MaxMiles, then queries the database for a list of all locations within MaxMiles of SourceZipCode