|
| |
This page is a first test of using a database within a website using
FrontPage publishing software.
| Composer |
Composition |
Concert Date |
Conductor |
Soloist 1 |
Soloist 2 |
Soloist 3 |
Soloist 4 |
<%
fp_sQry="SELECT * FROM ""DMCO Concerts"" ORDER BY Composer ASC,Composition ASC,""Concert Date"" ASC"
fp_sDefault=""
fp_sNoRecords="| No records returned. | "
fp_sDataConn="Concerts"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=8
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
| <%=FP_FieldVal(fp_rs,"Composer")%>
|
<%=FP_FieldVal(fp_rs,"Composition")%>
|
<%=FP_FieldVal(fp_rs,"Concert Date")%>
|
<%=FP_FieldVal(fp_rs,"Conductor")%>
|
<%=FP_FieldVal(fp_rs,"Soloist 1")%>
|
<%=FP_FieldVal(fp_rs,"Soloist 2")%>
|
<%=FP_FieldVal(fp_rs,"Soloist 3")%>
|
<%=FP_FieldVal(fp_rs,"Soloist 4")%>
|
To search the database by composer:
| data ID |
Composer |
Composition |
Concert Date |
Conductor |
Soloist 1 |
Soloist 2 |
Soloist 3 |
Soloist 4 |
<%
fp_sQry="SELECT * FROM ""DMCO Concerts"" WHERE (Composer = '::Composer::')"
fp_sDefault="Composer="
fp_sNoRecords="| No records returned. | "
fp_sDataConn="Concerts"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=9
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
| <%=FP_FieldVal(fp_rs,"data ID")%>
|
<%=FP_FieldVal(fp_rs,"Composer")%>
|
<%=FP_FieldVal(fp_rs,"Composition")%>
|
<%=FP_FieldVal(fp_rs,"Concert Date")%>
|
<%=FP_FieldVal(fp_rs,"Conductor")%>
|
<%=FP_FieldVal(fp_rs,"Soloist 1")%>
|
<%=FP_FieldVal(fp_rs,"Soloist 2")%>
|
<%=FP_FieldVal(fp_rs,"Soloist 3")%>
|
<%=FP_FieldVal(fp_rs,"Soloist 4")%>
|
| ProductID |
ProductName |
SupplierID |
CategoryID |
QuantityPerUnit |
UnitPrice |
UnitsInStock |
UnitsOnOrder |
ReorderLevel |
Discontinued |
<%
fp_sQry="SELECT * FROM Products"
fp_sDefault=""
fp_sNoRecords="| No records returned. | "
fp_sDataConn="Sample"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=10
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>
| <%=FP_FieldVal(fp_rs,"ProductID")%>
|
<%=FP_FieldVal(fp_rs,"ProductName")%>
|
<%=FP_FieldVal(fp_rs,"SupplierID")%>
|
<%=FP_FieldVal(fp_rs,"CategoryID")%>
|
<%=FP_FieldVal(fp_rs,"QuantityPerUnit")%>
|
<%=FP_FieldVal(fp_rs,"UnitPrice")%>
|
<%=FP_FieldVal(fp_rs,"UnitsInStock")%>
|
<%=FP_FieldVal(fp_rs,"UnitsOnOrder")%>
|
<%=FP_FieldVal(fp_rs,"ReorderLevel")%>
|
<%=FP_FieldVal(fp_rs,"Discontinued")%>
|
|
