📄 imdbsamp1a.asp
字号:
<%@ LANGUAGE = "VBScript" %>
<html>
<head>
<title>Active Server Page to IMDB Sample</title>
</head>
<body BACKGROUND="/backgrnd.gif" BGCOLOR="FFFFFF">
<H2>Active Server Page to IMDB Sample (IMDBSamp1)</H2>
<p><font face="Arial">Read data from IMDB installed on \\<%= request.servervariables("SERVER_NAME") %> </font></h2>
<FORM ACTION="IMDBSamp1B.asp" METHOD=POST>
<TABLE CELLPADDING="5">
<TR><TD>
Provider<BR>
<SELECT NAME=cboProviders>
<OPTION>MSIMDB
</SELECT>
</TD>
<TD>The OLE DB provider that you will use to access data. Although in this sample you use MSIMDB exclusively, you can develop applications that use the same client to access multiple data stores.</TD></TR>
<TR><TD>
TableDSNs<BR>
<SELECT NAME=cboTableDSNs>
<OPTION>TableDSN=IMDB_DS1;Table=employee
<OPTION>TableDSN=IMDB_DS1;Table=authors
</SELECT>
</TD>
<TD>The TableDSNs select box is used to specify which table loaded in IMDB you will retrieve data from. During <B>Phase 2. Configuration</B>, you specified 2 tables that should be loaded into IMDB at startup. You can write clients that access tables that were loaded into IMDB from completely different databases.</TD></TR>
<TR><TD>
Display Data <INPUT NAME=chkDisplayRecords TYPE=CHECKBOX>
</TD>
<TD>Select this option to view the <B>Recordset</B> that is retrieved from IMDB.</TD></TR>
<TR><TD>
Sort <INPUT NAME=chkSortRecords TYPE=CHECKBOX>
on primary key <SELECT NAME=cboSort> <OPTION>ASC <OPTION>DESC </SELECT>
</TD>
<TD>You can Sort a <B>Recordset</B> in ascending or descending order. The Sort is performed on the primary key of the <B>Recordset</B></TD></TR>
<TR><TD>
Filter <INPUT NAME=chkFilterRecords TYPE=CHECKBOX> on primary key for values<BR>
>= <INPUT NAME=txtFilter1 TYPE=TEXT> AND <BR><= <INPUT NAME=txtFilter2 TYPE=TEXT>
</TD>
<TD>You can Filter a <B>Recordset</B> by its primary key on a contiguous range of records. For the <B>authors</B> table, the primary key is on the <B>au_id</B> column (a social security number), and appropriate values might be '1' and '5'. For the <B>employee</B> table, the primary key is on the <B>emp_id</B> column, and appropriate values might be 'D' and 'M'.</TD></TR>
<TR><TD>
<INPUT TYPE=SUBMIT VALUE="Submit">
</TD>
<TD>Click the Submit button to submit the form to the server and work with IMDBSamp1B.asp to retrieve the data.</TD></TR>
</TABLE>
</FORM>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -