|
|
|
|
|
| | |
| |
Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Need help on taking info from more than one table in a db from an ASP page [URGENT] |
|
From: |
rtfm-now |
|
Date: |
5/27/2001 4:45:26 PM |
|
IP: |
62.0.96.120 |
I have a db called db.mdb (MS-Access 97) and I have there two tables (texts & projects). I also have an asp file (default.asp) and on two different place inside this asp page I wonna call to info stored in the db, in one place of the page to info in the texts table and in other place in the asp page to the info in the projects table.
How can I do it? I tried to use to connections like this:
<%
On Error Resume Next
Response.Write "<table border=Ƈ' cellpadding=Ɔ' cellspacing=Ɔ' width=颼%' bordercolor='white'>"
Response.Write "<tr width=颼%'><td width=颼%' bgcolor='black'><div align='center' valign='top'>"
Response.Write "<font size=ƈ' color='white'><b>:: Texts ::</b></font></div></td></tr>"
Response.Write "<tr width=颼%'><td width=颼%'>"
Response.Write "<table border=Ƈ' cellpadding=Ɔ' cellspacing=Ɔ' width=颼%' bordercolor='black'>"
Response.Write "<tr width=颼%'><td width=颼%' bgcolor='silver' dir='rtl'><div align='right'>"
Response.Write "<font size=ƈ' color='black'><b>"
Set C = Server.CreateObject("ADODB.Connection")
C.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db/site.mdb"))
Set R = Server.CreateObject("ADODB.Recordset")
R.ActiveConnection = C
R.Open "SELECT TOP 10 id, title FROM texts ORDER B |
Follow Up - Re: Need help on taking info from more than one table in a db from an ASP page [URGENT] - J. Paul Schmidt 5/28/2001 9:50:22 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
