- ASP - Database Table Display
·Script Writers
·Database Display
·Response Objects
·Server Variables
·Random Events
·What's New?
Mail List


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

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

U.S. States in order admitted into the union after the Civil War. 
do while not rs.eof

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





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 is hosted by
    Donate Food Online with a Mouse Click at
    Donate Land Online with a Mouse Click at
    © 1999 - 2018
    All Rights Reserved

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