<%@ page import = "org.hsc.DateHelper,java.io.*,java.util.*,javax.mail.internet.*,javax.mail.*,javax.naming.*" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/xml" prefix="x" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn" %> <%@ taglib uri="http://jakarta.apache.org/taglibs/mailer-1.1" prefix="mt" %> <%@ taglib uri="http://displaytag.sf.net" prefix="display" %> Humane Society of Charlotte

<%-- Choice of Scenarios : begin --%> select pow.primaryPet, p.description, p.name, p.breed from pets_of_week pow, pets p where p.pid = pow.primaryPet select eventid, title, description, month, day, days, graphic from event where date(concat(year, '-', month, '-', day, ' 00:00:00')) >= current_date() and month != '0' and day != '0' and homePageDisplay <=> 'Y' order by year, month, day asc

${rs.rows[0].name}

${fn:substring(rs.rows[0].description, 0, 256)}

see more about ${rs.rows[0].name}

There are many ways you can help the animals at the Humane Society of Charlotte. Our vision of seeing all animals in safe and loving homes requires lots of time and talent and lots of contributions of funds, goods and services from all the animal lovers in the our community...

see how you can help

${eventsMain.rows[0].title}
${eventsMain.rows[0].day}
${fn:substring(eventsMain.rows[0].description, 0, 128)}

Subscribe to our Newsletter!

select * from pet_tips where status = 'Y'

${rs.rows[0].tipShort}
${fn:substring(rs.rows[0].tipLong, 0, 128)}

more pet care tips

<%-- 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 : showNews : begin --%> "> "> <%-- Choice of Visual --%> <%-- Visual: none : begin --%> "> SELECT newsId, headline, details FROM news where newsId = ?

${newsRS.rows[0].headline}
${newsRS.rows[0].details}

<%-- Visual: showNews : end --%> <%-- Visual: showAllNews : begin --%> "> See All News SELECT newsId, headline FROM news where now() < date_end and now() > date_start ${row.headline}

<%-- Visual: showAllNews : end --%> <%-- Choice of Visual --%> <%-- Scenario : showNews : 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 --%>