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

 

?
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.