Solved

Fill text box with data using ASP

Posted on 1998-10-27
2
197 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 28

Accepted Solution

by:
sybe earned 200 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

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

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

Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
CTAs encourage people to do something specific to show interest in your company, product or service. Keep reading to learn why CTAs should always be thought of as extremely important, albeit small, sections of websites.
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmakerā€¦
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

691 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