Populating TEXTAREA from MEMO field

Results 1 to 3 of 3

Thread: Populating TEXTAREA from MEMO field

  1. #1
    Join Date
    Dec 1969
    Posts
    113

    Default Populating TEXTAREA from MEMO field

    Is it possible to populate a TEXTAREA with the data from a db&#039s MEMO field? Or any field for that matter?

  2. #2
    Anders Rask Guest

    Default RE: Populating TEXTAREA from MEMO field

    If i understand your question, you want to insert a field from your database into a textarea. You can do this quite easy as follows:<BR><BR>&#039First establish your ADO connection<BR>&#060;%<BR>Set MyConn=Server.CreateObject("ADODB.Connection")<BR> MyConn.Open "MyDSN"<BR>Set RS=MyConn.Execute("SELECT My_MEMO_field FROM MyTable")<BR>&#037;&#062;<BR>&#060;textarea rows="6" name="MyMemoField" cols="50">&#060;% = RS("My_MEMO_field")&#060;/textarea><BR>&#039 OBS the SQL syntax may vary from DB to DB the above will work on Access97<BR><BR>Hope this helps<BR>Anders

  3. #3
    Join Date
    Dec 1969
    Posts
    113

    Default RE: Populating TEXTAREA from MEMO field

    That was so obvious I feel foolish! Thanx for the help!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •