<% ' 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

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

Query by 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.