<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit. FP_CharSet = "windows-1252" FP_CodePage = 1252 %> Query

ASP & Access 2000 Database Demonstration, Aug 2000, by Fhayden.com
<--- Return to Fhayden.com

Query by School
Query by Last Name
Query by First Name
Add to List
Update Email
Delete Record
List Everyone


How Does
This Work


Query by School

Select a School
<% fp_sQry="SELECT * FROM PVSD_email WHERE (Location LIKE '::Location::') ORDER BY Last_Name ASC" fp_sDefault="Location=" fp_sNoRecords="" fp_sDataConn="Database1" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="ID" fp_sMenuValue="ID" fp_iDisplayCols=5 fp_fCustomQuery=False BOTID=0 fp_iRegion=BOTID %>
ID Last_Name First_Name Email Location
No records returned.
<%=FP_FieldVal(fp_rs,"ID")%> <%=FP_FieldVal(fp_rs,"Last_Name")%> <%=FP_FieldVal(fp_rs,"First_Name")%> <%=FP_FieldVal(fp_rs,"Email")%> <%=FP_FieldVal(fp_rs,"Location")%>

Created by F. Hayden Cochran, PVHS Teacher, on Aug. 2000
Why?.....Just for fun......I always wanted to demonstrate how ASP and database web sites worked.