Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using Access DBs and ASP
- Thread starter mlocurci
- Start date
Here is what I do:
Note: first add an Access database and let Front Page create a Global.asa file with a connection in it
<html>
<%@ Language=VBScript %>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>
<%
Set fp_conn = Server.CreateObject("ADODB.Connection"
Set fp_rs = Server.CreateObject("ADODB.Recordset"
fp_conn.Open Application("Mail-List_ConnectionString"
fp_rs.Open "Select * From [INS Members];", fp_conn, 1, 3, 1
fp_rs.movefirst
%>
<body>
<p align="center"><b><font size="5">Members</font></b></p>
<table width="1028" border="1">
<thead>
<tr>
<td width="87"><b>Salutation</b></td>
<td width="92"><b>FirstName</b></td>
<td width="91"><b>LastName</b></td>
<td width="79"><b>Address</b></td>
<td width="53"><b>City</b></td>
<td width="59"><b>State</b></td>
<td width="48"><b>Zip</b></td>
<td width="99"><b>Phone Home</b></td>
<td width="99"><b>Phone Work</b></td>
<td width="96"><b>Pager</b></td>
<td width="65"><b>FAX</b></td>
<td width="70"><b>E-mail</b></td>
</tr>
</thead>
<tbody>
<%do while not fp_rs.eof%>
<tr>
<td width="87"><%=fp_rs("Salutation"%></td>
<td width="92"><%=fp_rs("FirstName"%></td>
<td width="91"><%=fp_rs("LastName"%></td>
<td width="79"><%=fp_rs("Address"%></td>
<td width="53"><%=fp_rs("City"%></td>
<td width="59"><%=fp_rs("State"%></td>
<td width="48"><%=fp_rs("Zip"%></td>
<td width="99"><%=fp_rs("Phone Home"%></td>
<td width="99"><%=fp_rs("Phone Work"%></td>
<td width="96"><%=fp_rs("Pager"%></td>
<td width="65"><%=fp_rs("FAX"%></td>
<td width="70"><a href="<%=fp_rs("E-mail"%>"></a> </td>
</tr>
<%fp_rs.movenext%>
<%loop%>
</tbody>
</table>
<%Set fp_conn = nothing%>
<%Set fp_rs = nothing%>
</body>
</html>
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
Note: first add an Access database and let Front Page create a Global.asa file with a connection in it
<html>
<%@ Language=VBScript %>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>
<%
Set fp_conn = Server.CreateObject("ADODB.Connection"
Set fp_rs = Server.CreateObject("ADODB.Recordset"
fp_conn.Open Application("Mail-List_ConnectionString"
fp_rs.Open "Select * From [INS Members];", fp_conn, 1, 3, 1
fp_rs.movefirst
%>
<body>
<p align="center"><b><font size="5">Members</font></b></p>
<table width="1028" border="1">
<thead>
<tr>
<td width="87"><b>Salutation</b></td>
<td width="92"><b>FirstName</b></td>
<td width="91"><b>LastName</b></td>
<td width="79"><b>Address</b></td>
<td width="53"><b>City</b></td>
<td width="59"><b>State</b></td>
<td width="48"><b>Zip</b></td>
<td width="99"><b>Phone Home</b></td>
<td width="99"><b>Phone Work</b></td>
<td width="96"><b>Pager</b></td>
<td width="65"><b>FAX</b></td>
<td width="70"><b>E-mail</b></td>
</tr>
</thead>
<tbody>
<%do while not fp_rs.eof%>
<tr>
<td width="87"><%=fp_rs("Salutation"
%></td><td width="92"><%=fp_rs("FirstName"
%></td><td width="91"><%=fp_rs("LastName"
%></td><td width="79"><%=fp_rs("Address"
%></td><td width="53"><%=fp_rs("City"
%></td><td width="59"><%=fp_rs("State"
%></td><td width="48"><%=fp_rs("Zip"
%></td><td width="99"><%=fp_rs("Phone Home"
%></td><td width="99"><%=fp_rs("Phone Work"
%></td><td width="96"><%=fp_rs("Pager"
%></td><td width="65"><%=fp_rs("FAX"
%></td><td width="70"><a href="<%=fp_rs("E-mail"
%>"></a> </td></tr>
<%fp_rs.movenext%>
<%loop%>
</tbody>
</table>
<%Set fp_conn = nothing%>
<%Set fp_rs = nothing%>
</body>
</html>
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
- Status
Similar threads
