|
Overview: RSFast - Lists
Cached Example
by Charles Carroll
Here are some listboxes combined
with caching features. Here is the code:
filename=/learn/rsfast_current/rsfast-lists-cached.asp
<%@ enablesessionstate=false%>
<%option explicit%>
<%
response.buffer=true
server.scripttimeout=40
%>
<!--#include file="lib_rsfast.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>rsfast-lists-cache</title>
</head>
<body bgcolor="#FFFFFF">
<%
dim rsparms,conntest
conntest="DSN=student;uid=student;pwd=magic"
set rsparms=server.CreateObject("Scripting.Dictionary")
'rsparms.add "debug", true
rsparms.add "conn", conntest
rsparms.add "sql", "select distinct city from publishers"
rsparms.add "template", "list"
rsparms.add "templatename", "city"
Call RsFast(rsparms)
response.flush
rsparms.item("sql")="select distinct state from publishers"
rsparms.item("templatename")="state"
rsparms.item("cachemin")=10
Call RsFast(rsparms)
response.flush
rsparms.item("sql")="select distinct zip from publishers"
rsparms.item("templatename")="zip"
rsparms.item("cachemin")=10
Call RsFast(rsparms)
response.flush
set rsparms=nothing
%>
</body>
</html>
The library file that does
all the work is at:
http://www.learnasp.com/freebook/asp/rsfast-lib.aspx
so go there to cut and paste the include file if needed.
|