Please see the following example, this is an example program used to display book classification:
displayBooks.asp
<%@LANGUAGE=JavaScript%>
<html>
<body>
<formmethod=post>
Book classification; <%=getBooksListBox()%>
<p>
<inputtype=submit>
<%
functiongetBooksListBox()
{
BooksListBox=Application("BooksListBox")
if(BooksListBox!=null)returnBooksListBox;
crlf=String.fromCharCode(13,10)
BooksListBox="<selectname=Books>"+crlf;
SQL="SELECT*FROMBooksORDERBYName";
cnnBooks=Server.CreateObject("ADODB.Connection");
cnnBooks.Open("Books","Admin","");
rsstBooks=cnnBooks.Execute(SQL);
fldBookName=rstBooks("BookName");
while(!rstBooks.EOF){
BooksListBox=BooksListBox+"<option>"+
fldBookName+""+crlf;
rsstBooks.MoveNext();
}
BooksListBox=BooksListBox+""
Application("BooksListBox")=BooksListBox
'Note this sentence, the essence of Application technology should be
returnBooksListBox;
}
%>