ASP Script Issues

seloerch · Joined: 14 Oct 2004 Posts: 1

I currently have a database linked to a web form to input data into the database. What I am needing to do now if figure out why I am getting error messages form the new page I've started. Keep in mind I'm just starting in this area.

Here is the code:

<%
Set getone=Server.CreateObject("adodb.connection")
getone.open "VUSNInventory"

rm = request.querystring("rm")

sql_info = "Select * from tblVUSNInventory where uniqueID='" & rm & "'"

SET displayeveryone = getone.Execute(sql_info) %>

<html>
<head>
</head>
<body vlink="blue">

<p align="center">To update/modify this record click on the ID hotlink.<br>
Or click <a href="pget.asp">here</a> to return to the entire list</p>

<P>
<table border="0"cellpadding="2" align="center">

<table border="1">
<tr>
<td><% response.write "rm" %></td>

<% DO UNTIL displayeveryone.EOF %>
<tr>
<td><% response.write displayeveryone("rm") %></td>

<% foundperson.MoveNext
loop %>
</table>
<a href="index.asp?ID=<% Response.Write foundperson("rm") %>"><% Response.Write foundperson("rm") %></a>

</body>
</html>

Any pointers would be great.

Thanks, Scot

Shinz · Posted: Thu Oct 14, 2004 7:47 pm Post subject: Re: ASP Script Issues

"thinks this should be in the ASP + ASP.ET category..."