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