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

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

?

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.