<%@page import="java.util.*"%> <%@page import="java.sql.*"%> <% ResourceBundle rb = ResourceBundle.getBundle("properties/vendorDB"); Connection con = null; Statement st = null; ResultSet rs = null; Class.forName("com.mysql.jdbc.Driver").newInstance(); con = DriverManager.getConnection(rb.getString("databaseName"), rb.getString("databaseUser"), rb.getString("databasePass")); st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); String monthQuery = "SELECT monthName FROM month ORDER BY monthNum";//rb.getString("monthQuery"); String roomQuery = "SELECT room, building FROM conferenceRooms";//rb.getString("roomQuery"); %> <% con.close(); %>

 

.Canal.Street.Ltd.

 

Please fill out the form below if you'd like to receive a quote from Canal Street Ltd for your next event. You'll hear from us within 1 business day of request submittal. Thank you for taking the time to view our site. We sincerely hope you enjoyed your Canal Street Ltd web experience.

<% rs = st.executeQuery(monthQuery);%> <% rs.close(); rs = st.executeQuery(roomQuery); %> <% rs.close(); %>
Canal Street Ltd Request for Quote
First Name: Last Name:
Email:    
  
May we add you to our mailing list? Yes No
When is your event? How did you find our site?
Where will your event be held?
What is the title of your event?   
Setup Complete-By Time: Breakdown Start Time:
 What type of arrangement(s) would you like?
Simple Vase Quantity: Size(s): Type of Rose(s):
Swag Quantity: Size(s): Type of Rose(s):
Centerpiece Quantity: Size(s): Type of Rose(s):
Attention Grabber Quantity: Size(s): Type of Rose(s):