Db values to textarea problem

Results 1 to 2 of 2

Thread: Db values to textarea problem

  1. #1
    Join Date
    Dec 1969

    Default Db values to textarea problem

    Hi,<BR>I submit the following<BR>Line 1<BR>Line 2<BR>Line 3<BR>textarea values and use the Replace function like<BR><BR>Subsidiary = request.form("Subsidiary")<BR>Subsidiary = replace(Subsidiary, chr(13), "")<BR>Subsidiary = replace(Subsidiary, chr(10), "<BR>")<BR><BR>I run a report in the db and the Subsidiary field shows<BR>Line 1"&#060;"br"&#062;"Line 2"&#060;"br"&#062;"Line 3<BR>without the double quotes<BR><BR>Problem<BR>I call an asp page to view the results with<BR>Subsidiary = rs("Subsidiary")<BR>but the textarea is blank (text fields are OK)<BR><BR>What am I doing wrong? Any suggestions anyone.<BR>Thanks<BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Db values to textarea problem

    Try changing the positions of the quotes, as they appear to be in the wrong position, also I think the CRLF comes through as %0D%0A - I can&#039t remember without checking

Posting Permissions

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