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

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


List the Employee's Email List

Warning....this ASP script works best on a T-1.
If you are viewing this on a 56K modem, then the 
script may "time-out" and not present a complete list.

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

Return to Top

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.