Alright...I have a
very simple database consisting of one table with one column..the db name is Roster and the column name is Alias. I made a page where data can be put into it (I can't figure out how to edit and delete though
) and I have the script that actually puts the information into the database.
Now this is where I'm having trouble. I want to put the database information onto a webpage in tables. I've tried so hard but to no avail. What code is needed to do this? I figured it wouldn't be so hard with only one table and column. Here is my other script.
Form:
<html><head>
<TITLE>Update Roster</TITLE>
</head><body bgcolor="#FFFFFF">
<form action="db.asp" method=post>
<font face="Arial" size="2">Alias:</font> <INPUT NAME="name" MaxLength=20><p>
<INPUT TYPE=submit><p><INPUT TYPE=reset>
</form></body></html>
and db.asp .. :
<%
Dim adoCon
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("roster.mdb")
'adoCon.Open "DSN=roster"
adoCon.Execute "INSERT INTO Roster (Alias) VALUES (" & "'" & request.form("name") & "'" & ")"
%>
<html>
<head>
<title>Thanks!</title>
<style>
A:link { color: #000000; text-decoration: none }
A:visited { color: #000000; text-decoration: none }
A:hover {color: #000000; text-decoration: none}
</style>
</head>
<body>
<table bgcolor="#666666" width="25%" align="center" border="1" bordercolor="#000000" cellspacing="0" cellpadding="0" style="border-collapse: collapse">
<tr>
<td width="100%" align="center"><font face="arial" size="2" color="gold">Thanks!</font></td>
</tr>
<tr>
<td width="100%" align="center"><font face="arial" size="2" color="gold"><a href="index.asp">Go Back</a></font></td>
Now how do I display this data? Any help is appreciated. Thank you for your time.
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
