Fill text box with data using ASP

How can I do this? I am trying to update an ASP. I need to have the data come up in the text box and then let the user update it and then submit it back to the database.  Please Help!

Thanks,

Dorothy
pizzutiAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
sybeConnect With a Mentor Commented:
<%
ID = Request("entiteit_id")
If ID <> "new" Then
  Set RS = Server.CreateObject("ADODB.Recordset")
  strSQL = "SELECT * "
  strSQL = strSQL & "FROM table "
  strSQL = strSQL & "WHERE ID = " & ID
  RS.Open strSQL, Conn, 1, 1
  strMyData = RS("MyDataField")
  RS.Close
End If
%>

<form action="Action.asp" METHOD="POST">
<input type="hidden" name="ID" value="<%=ID%>">

<TEXTAREA rows=20 cols=75 name="MyData" wrap="physical">
<%=strMyData%>
</TEXTAREA>


<input type="submit" name="Action" value="submit">
</form>

0
 
pizzutiAuthor Commented:
Thanks but I forgot to menton the most important part - I need to let them scroll through the database records in the text box.
If you can help great if not thanks for your help so far....

Dorothy
0
All Courses

From novice to tech pro — start learning today.