<%@ page import= "custom.trr.com.*,java.util.*,java.sql.*,javax.sql.*;" %> <% String[][] memberInfo = null; String[][] shopInfo = null; String memberId = null; int failOver = 0; try { memberId = request.getParameter("memberId").replaceAll(" ",""); } catch(Exception e) { failOver = 1; } DataAccess da = new DataAccess(); /* Failover checks - series of if statements to see if proper data is returned 0 = all is good 1 = No member ID sent to page ---- provide form to search for shop to rate 2 = No member with that ID ---- provide form and resubmit to self with display that there is no shop for that zip or zip doesn't exist ?? show surrounding ?? */ if(memberId == null || memberId.equals("")) { failOver = 1; } else { shopInfo = da.getData("SELECT * FROM `member_info` WHERE `trr_id` = "+memberId+""); if(shopInfo[0][0].toString() == "No records found." || shopInfo[0][0].toString() == "DataAccess problem.") { failOver = 1; } else { }//2 }//1 %> Request for Transmission Repair Referral Service

<%@ include file="/contentLeft.htm"%>

Service Request

<% request.getRequestDispatcher("/request"+failOver+".jsp").include(request, response); %>

<%@ include file="/contentRight.htm"%>