Search Search

#1 worldwide
FREE Coding Lessons

since 1996
   THE BEST WAY to learn ASP & Asp.net!
Advertise Here!
click for details
Credits Host:
DiscountASP.net
Server Admin:
The "Team"
Contact Info.
Charles M. Carroll

my Blog
[prev. Lesson]  RSFast: Listbox Display Fast
     [next Lesson]  RSFast: Debug Info helps troubleshoot

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

<Test Script Below>


<%@ 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.

There are many worthy charities!!. But perhaps help starving children in Africa or South America AND help Charles too. a $5 tip buys him lunch at McDonalds, a $20 tip buys his kid Hitoshi a new computer game, a $39 tip buys his daughter Michiko a few nice outfits. See our donor list.