<% Set Conn = Server.CreateObject("ADODB.Connection")
conn.open "dsn=community;uid=profiles;pwd=uwsc" %>
<% '-------------------------------------------------------------------------------------
' Get data from community kctrend1_03 database and build recordset called rsCounty for selected County
' -------------------------------------------------------------------------------------
sqlstmt= "Select * from kctrend1_03 where COUNTYID= '" & request("COUNTYID") & "'"
set rsCounty = conn.execute(sqlstmt)
'response.write sqlstmt
%>
2003 Kids Count Data Trends
Health
Low Birth Weight.
Less than Adequate Prenatal Care.
Infant Mortality
Family
Births to Mothers Under 18.
Births to Mothers Under 20.
Births to Mothers with Less Than a High School Education.
Births to Single Mothers.
Children in Single Parent Families
Education
Not Ready for First Grade.
Students Failing Grades 1-3.
Grade 3 Math Below Standards.
Grade 3 Reading Below Standards.
Bottom Quartile Stanford/MAT Grade 4.
Grade 8 Math Below State Standards.
Grade 8 Reading Below State Standards.
Bottom Quartile Stanford/MAT Grade 9.
Students Not Passing All Parts of Exit Exam on First Attempt.
Dropout Rate.
Young Adults Not Completing High School
Economics
Poverty Rate.
Income of Families with Children