CodeAve.com CodeAve.com - ASP - Database Table Display
ASP
·Read/Write
·Script Writers
·Database Display
·Response Objects
·Server Variables
·Random Events
·Articles
·Miscellaneous
·Contents
·What's New?
JavaScript
CSS
HTML
Maps
Links
Mail List
Search
Sitemap


 


Displaying A Saved Query (Access)
Have your queries already saved in Access?  You can display them in .asp.  Instead of writing the sql for your query directly into your .asp page you can simply reference a query saved in Access.  Utilizing our state_info db and a query saved in Access named states_after_1865 (SELECT statename, year, entered FROM state_order WHERE year > 1865 ORDER BY entered;). You can easily display data normally only viewable in Access or reports made from Access available through the browser.
View the Output
Text View
Print View
Mail this Link
Download the Code
View the Data

<%
accessdb="state_info" 
cn="DRIVER={Microsoft Access Driver (*.mdb)};"
cn=cn & "DBQ=" & server.mappath(accessdb)
Set rs = Server.CreateObject("ADODB.Recordset")

sql = "states_after_1865"

rs.Open sql, cn
%>


<p>
U.S. States in order admitted into the union after the Civil War. 
</p><table>
<%
rs.MoveFirst
do while not rs.eof
%>

<tr>
<td>&nbsp;<%= rs("entered") %>&nbsp;</td>
<td>&nbsp;<%= rs("year") %>&nbsp;</td>
<td>&nbsp;<%= rs("statename") %>&nbsp;</td>
</tr>

<%
rs.movenext
loop%>
</table>

 

 

 



ASP: What's New? | Articles | Script Writers | Database Display | Read/Write
Server Variables | Response Objects | Random Events | Miscellaneous
HTML: Forms | Hyperlinks | Headers | Tables | Hyperlinks | Headers | Text Display
JavaScript: Document Info | Forms | Images | Navigation | Script Writers
CSS: Basics | Page Display | Text Display | Script Writers | Miscellaneous
  • 2014 michael kors
  • air max women 2013
  • 2014 michael kors
  • air max 2014
  • oakley glasses
  • oakley glasses

  • Maps: Map Script Writers | Bing Maps | Google Maps
  • bottes fr
  • ugg boot
  • Privacy Statement

    CodeAve.com is hosted by MyHosting.com
    Donate Food Online with a Mouse Click at TheHungerSite.com
    Donate Land Online with a Mouse Click at TheRainForestSite.com
    © 1999 - 2017 CodeAve.com
    All Rights Reserved

  • Kids jordan 6 rings
  • Jordan retro 10
  • Jordan retro 3