hi

advance thanks. in asp if i give the enter button in the text area it stores in the database as a pipe symbol. while retrieving that record i can't get the data into that text area. how i can eliminate this problem. Thanks

Kalyanaraman Narayanan

Are u explicitly storing pipe charecter in textarea..? Because in database newline charecter is stored i think, and while retriving data, it displays data as entered.


Om Prakash

I believe the enter button should not store a pipe.

I run this function every time I do an insert, will fix your problem Id say:

  Function StoreText(theText)
    StoreText = ""
    on error resume next
    StoreText = CStr(theText)
    if (len(StoreText) > 0) Then
      StoreText = Replace(StoreText, """", """, 1, -1, 1)
      StoreText = Replace(StoreText, "'", "''", 1, -1, 1)
      StoreText = Replace(StoreText, vbCrLf, "<BR>", 1, -1, 1)
    end if
  End Function

When you do am insert also run the trim function, should be run on all inserts and updates where the value has come from user input, Use it like so:

trim(storeText(request.form("formElementName")

Wind is your friend
Matt

After you use the StoreText function to insert or update, use the following when getting data back out to show in the texarea:

Function DisplayMemo(theText)
   if (len(theText) > 0) Then DisplayMemo = Replace(theText, "<BR>", vbCrLf)
End Function

<textArea>DisplayMemo(rs(0))</textArea>

Wind is your friend
Matt

Thanks to all. i had used the replace function before entering into the database. it solves my problem. thanks to all
Kalyanaraman Narayanan