Just fill in the registration information below.
We'll display it so others know of your good work, and send
you materials you can use to spread the word about your project.
The more challenges you issue, the more
orphans we can help. If you'd like to challenge more
than two others, just email their information to us
at challenge@youngheroes.org.sz
and we'll inform them that they've been challenged,
too.
COMPLETED YOUR CHALLENGE
PROJECT? Click here to
learn how to register your donation.
THEY'VE
ACCEPTED THE CHALLENGE!
School
Org/Class
Dollar Goal
Children Goal
<%
set YHConn=Server.CreateObject("ADODB.Connection")
YHConn.Open ConnectS
MyQuery = "select * from chschool where SchoolID > 0 order by School, orgclass"
'MyQuery = "select * from chorgchallenge order by chorgname"
set YHChallengeRS= Server.CreateObject("ADODB.RecordSet")
YHChallengeRS.Open MyQuery , YHConn, 3, 3
do while not YHChallengeRS.EOF %>
<%=YHChallengeRS("School")%>
<%=YHChallengeRS("orgclass")%>
<%
if YHChallengeRS("GoalDollarAmt")> 0 then%><%=YHChallengeRS("GoalDollarAmt")%><% else %>
<% End If %>
<%
if YHChallengeRS("GoalNumChildren")> 0 then%><%=YHChallengeRS("GoalNumChildren")%><% else %>
<% End If %>
<%
YHChallengeRS.movenext
loop
%>
<%
YHChallengeRS.close
set YHChallengeRS=Nothing
YHConn.close
SET YHConn=nothing
%>
These are the challenges that have been
issued
School
Org / Class
Challenge
<%
set YHConn=Server.CreateObject("ADODB.Connection")
YHConn.Open ConnectS
MyQuery = "select * from chschool where SchoolID > 0 order by School, orgclass"
set YHSchoolRS= Server.CreateObject("ADODB.RecordSet")
YHSchoolRS.Open MyQuery , YHConn, 3, 3
do while not YHSchoolRS.EOF %>
<%=YHSchoolRS("School")%>
<%=YHSchoolRS("OrgClass")%>
<%
MyQuery = "select * from chorgchallenge where SchoolID =" & YHSchoolRS("SchoolID") & " order by chorgname"
set YHChallengeRS= Server.CreateObject("ADODB.RecordSet")
YHChallengeRS.Open MyQuery , YHConn, 3, 3
do while not YHChallengeRS.EOF %>
<%=YHChallengeRS("chorgname")%>
<%
if YHChallengeRS("Accept") = 0 then %>
Not Accepted
<%else %>
Accepted <%'YHChallengeRS("AcceptDate")%>
<% End If%>
<%
YHChallengeRS.movenext
loop
%>
<%
YHChallengeRS.close
set YHChallengeRS=Nothing
%>
<%
YHSchoolRS.movenext
loop
%>
<%
YHSchoolRS.close
set YHSchoolRS=Nothing
YHConn.close
SET YHConn=nothing
%>