<%-- Choice of Scenarios : begin --%> select * from pets_of_week Please Adopt Us Cats  |  Dogs  |  All animals select * from event where date_start > now() order by date_start asc select eventid, title, description, date_format(date_start,'%m/%d/%Y') as date_start, date_format(date_end,'%m/%d/%Y') as date_end, date_format(date_start,'%l %p') as time_start, date_format(date_end,'%l %p') as time_end, graphic, etid from event where eventid = ? News You Can Use ${eventsMain.rows[0].title} From: ${eventsMain.rows[0].date_start} ${eventsMain.rows[0].time_start} To: ${eventsMain.rows[0].date_end} ${eventsMain.rows[0].time_end} More Upcoming Events   ${fn:substring(events.rows[1].title, 0, 15)} ... more ${fn:substring(events.rows[2].title, 0, 15)} ... more ${fn:substring(events.rows[3].title, 0, 15)} ... more   Caring for Your Critters select * from pet_tips where status = 'Y' ${rowrs.tipShort}   ${fn:substring(rowrs.tipLong, 0, 15)} ... Want More News? Sign Up! <%-- Scenario : signupnews : begin --%> "> "> <%@ include file="signupnews.jsp" %> <%-- Scenario : signupnews : end --%> <%-- Scenario : showAllEvents : begin --%> "> "> <%@ include file="allEvents.jsp" %> <%-- Scenario : showAllEvents : end --%> <%-- Scenario : showAllPets : begin --%> "> "> <%@ include file="allPets.jsp" %> <%-- Scenario : showAllPets : end --%> <%-- Scenario : helpanim : begin --%> "> "> <%@ include file="helpanim.jsp" %> <%-- Scenario : helpanim : end --%> <%-- Scenario : calendar : begin --%> "> "> <%@ include file="calendar.jsp" %> <%-- Scenario : calendar : end --%> <%-- Scenario : spayneuter : begin --%> "> "> <%@ include file="spayneuter.jsp" %> <%-- Scenario : spayneuter : end --%> <%-- Scenario : educate : begin --%> "> "> <%@ include file="educate.jsp" %> <%-- Scenario : educate : end --%> <%-- Scenario : adopt : begin --%> "> "> <%@ include file="adopt.jsp" %> <%-- Scenario : adopt : end --%> <%-- Scenario : about : begin --%> "> "> <%@ include file="about.jsp" %> <%-- Scenario : about : end --%> <%-- Scenario : adoptApp : begin --%> "> "> <%@ include file="adoptApp.jsp" %> <%-- Scenario : adoptApp : end --%> <%-- Scenario : unavailable : begin --%> "> "> <%@ include file="unavailable.jsp" %> <%-- Scenario : unavailable : end --%> <%-- Scenario : showPetTips : begin --%> "> "> <%-- Choice of Visual --%> <%-- Visual: none : begin --%> "> select * from pet_tips where status = 'Y'   Select   ${rowrs.tipShort} ${fn:substring(rowrs.tipLong, 0, 75)} ... <%-- Visual: none : end --%> <%-- Visual: showAll : begin --%> "> select * from pet_tips where ptId = ? Pet Tip: ${rs.rows[0].tipShort} Description: ${rs.rows[0].tipLong} <%-- Visual: showAll : end --%> <%-- Choice of Visual --%> <%-- Scenario : showPetTips : end --%> <%-- Scenario : generic: begin --%> "> "> <%-- Choice of Visual --%> <%-- Visual: challengeUserprompt : begin --%> "> <%-- Visual: challengeUserprompt : end --%> <%-- Choice of Visual : end --%> <%-- Scenario : generic: end --%> <%-- No matching scenario found --%> <%-- Choice of Scenarios : end --%>