hey,
Ive created a database with several fields. I have uploaded the database and am able to show the information in a asp page. Can anyone help me out with how to get it to show in a html table instead? the code i currently have is:
<% Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" &_
"DBQ=" & Server.MapPath("\ssp08\storer\shop.mdb")
objConn.Open
Dim objRS
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "shop", objConn, , , adCmdTable
%>
<table>
<tr><td> <% Response.Write objRS("Price")%></td></tr>
<tr><td><% Response.Write objRS("Description)%></td></tr>
</table>
<%
objRS.close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>