|
Overview: RSFast - Table
Example
by Charles Carroll
the library Rsfast can make tables in a simple
way. Here is the Access database samplee:
filename=/learn/rsfast_current/rsfast-tableaccess.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 Tables</title>
</head>
<body bgcolor="#FFFFFF">
<%
dim rsparms, conntest
set rsparms=server.CreateObject("Scripting.Dictionary")
rsparms.Add "accdb", "/learn/test/biblio.mdb"
rsparms.add "sql", "select * from publishers where state='NY'"
rsparms.add "template", "table"
'rsparms.add "debug", true
Call RsFast(rsparms)
' Include below line if you want to see millisecond timing
'Call PerfDisplay(rsparms)
set rsparms=nothing
%>
</body>
</html>
Here is the SQLserver database sample:
filename=/learn/rsfast_current/rsfast-tablesql.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 Tables</title>
</head>
<body bgcolor="#FFFFFF">
<%
dim rsparms, conntest
conntest="DSN=student;uid=student;pwd=magic"
set rsparms=server.CreateObject("Scripting.Dictionary")
rsparms.Add "conn", conntest
rsparms.add "sql", "select * from publishers where state='NY'"
rsparms.add "template", "table"
'rsparms.add "debug", true
Call RsFast(rsparms)
' Include below line if you want to see millisecond timing
'Call PerfDisplay(rsparms)
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.
|