[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Fill text box with data using ASP

Posted on 1998-10-27
2
Medium Priority
?
211 Views
Last Modified: 2013-12-25
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
0
Comment
Question by:pizzuti
2 Comments
 
LVL 28

Accepted Solution

by:
sybe earned 800 total points
ID: 1855958
<%
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
 

Author Comment

by:pizzuti
ID: 1855959
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Suggested Courses
Course of the Month18 days, 19 hours left to enroll

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question