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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pulling Info from an ACCESS database

Status
Not open for further replies.
DaveNamou

DaveNamou

IS-IT--Management
Feb 7, 2002
175
US
I have a simple database with one table and 3 columns

Engineer.mdb
[EngineerName] [EngineerTitle] [EngineerNumber]

This database is changed quite often.

I would like to make a web page that builds a list from the items in the Database.

How do I pull information from a database to display it in an html page?

The database would be stored in the default directory of the website. C:\Inetpub\
Thank you Dave Namou, MCSE CCEA
 
Sort by date Sort by votes
Thanks, I'm new to all of the items you listed. But the website you gave me had a good basic sample using ASP. I just need to reverse engineer it to fit my needs.

Thanks again Dave Namou, MCSE CCEA
 
Upvote 0 Downvote
Here's how to do it using an Access database and ASP:

The data connection string ("objDC.Open") may not be appropriate for the database you are using. To determine the right data connection string, take a look at this site
Im pretty sure the SQL statement here will work on any SQL database, as well as Access.

<%@ Language=VBScript %>
<html><body>
<%
dim objdc, cmdTmp, objrs
set objdc = Server.CreateObject(&quot;ADODB.Connection&quot;)
set cmdTmp = Server.CreateObject(&quot;ADODB.Command&quot;)
set objrs = Server.CreateObject(&quot;ADODB.Recordset&quot;)
objDC.Open &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot; & Server.Mappath(&quot;yourdatabasename.mdb&quot;) & &quot;;&quot;
dim strFacStaffName
strFacStaffName = Request.Form(&quot;FacStaffName&quot;)
cmdTmp.ActiveConnection = objdc
cmdtmp.CommandText = &quot;SELECT EngineerName, EngineerTitle, EngineerNumber FROM YourTableName Order By Engineername ;&quot;
objrs.Open cmdTmp,,1,3
%>
<table border=1 cellpadding=5 bgcolor=&quot;#ddd777&quot;><tr valign=&quot;middle&quot;><td>
<h2><font color=&quot;#000066&quot;>Engineer List</font></h2>
</td>
</tr>
</table>
<%
if objrs.EOF then
Response.Write&quot;<h1>There are no records</h1><br><br><br>&quot;
End If
%>
<p>
<table border=0 cellspacing=5 cellpadding=2>


<%
Do While Not objRS.EOF
Response.Write &quot;<tr><td><b><i><font color='#000066'>Engineer Name:</b></i></font></td><td>&quot; & objRS(&quot;EngineerName&quot;) & &quot;</td></tr>&quot;
Response.Write &quot;<tr><td><b><i><font color='#000066'>Engineer Title:</b></i></font></td><td>&quot; & objRS(&quot;EngineerTitle&quot;) & &quot;</td></tr>&quot;
Response.Write &quot;<tr><td><b><i><font color='#000066'>Engineer Number:</b></i></font></td><td>&quot; & objRS(&quot;EngineerNumber&quot;) & &quot;</td></tr>&quot;

objRS.MoveNext
Loop
objRS.Close
Set objRS = Nothing
objdc.Close
Set objdc = Nothing
%>

</table>
</body></html>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lmcate
  • Locked
  • Question
From HTML Page open an MDB files on the server and work
Replies
0
Views
186
lmcate
lmcate
cae154
  • Locked
  • Question
Body of email not appearing in correct font on iPhone and iPad
Replies
1
Views
736
spamjim
spamjim
SitesMasstec
  • Locked
  • Question
How to have an HTML opened automatically in an e-mail
Replies
3
Views
184
spamjim
spamjim
waubain
  • Locked
  • Question
Prevent user from getting a 404 error if click on a hover text displaying a hidden image. 1
Replies
5
Views
219
jjgupta915
jjgupta915
usarmycwo
  • Locked
  • Question
Any FrontPage users still around? 1
Replies
4
Views
772
feherke
feherke

Part and Inventory Search

Sponsor

Back
Top