Carriage return

Results 1 to 2 of 2

Thread: Carriage return

  1. #1
    DEFOSSE Guest

    Default Carriage return

    I want to insert a Description into a field of Type=TEXT through an ASP form to a SQL server6.5 DB. <BR>I can insert all the description (whatever the length of it) but when I retrieve it in my ASP page all the format has disappeared. No more carriage return appears. <BR><BR>My script is :<BR>set conn=server.createobject("ADODB.Connection")<BR>co nn.opensession "ConnectionString"<BR>msg=request.form("descriptio n")<BR>sql="insert into mytable (Mycolumn) Values &#039(" & msg & "&#039)"<BR>conn.execute(sql)<BR><BR>Do I have to first format the Request.Form("description") with a specific function ?<BR> Thanks,<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Carriage return

    You could do a...<BR><BR>msg = Replace(request.form("description"), vbCrLf, "&#060;RB&#062;")<BR><BR>Where &#060;RB&#062; is a standard HTML Break, but due to formatting problems, on this m-board, I switched it around.<BR><BR>HTH<BR><BR>Jerry

Posting Permissions

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