Line Break in SQL Value

Discussion in 'ASP General' started by James, Jun 6, 2005.

  1. James

    James Guest

    We've built a page that allows users to enter items that will ultimately
    become a list. One particular user enters them into the textarea on the
    page and for some reason always puts a hard return into the textarea before
    she submits. This goes into SQL as a line break and it's screwing up how
    the page renders.

    How do I find this via code so that I can replace it? I've tried looking
    for chr(13) + chr(10) and vbCr and vbCrLf and replacing them with "" but it
    doesn't seem to work. Am I missing something?

    Thanks,
    James
     
    James, Jun 6, 2005
    #1
    1. Advertising

  2. James

    b.Wurm Guest

    Hello!

    chr(13) + Chr(10) is the same as vbCrLf.
    Did you allready try vbLf?

    regards
    b.wurm


    "James" <> schrieb im Newsbeitrag
    news:...
    > We've built a page that allows users to enter items that will ultimately
    > become a list. One particular user enters them into the textarea on the
    > page and for some reason always puts a hard return into the textarea
    > before
    > she submits. This goes into SQL as a line break and it's screwing up how
    > the page renders.
    >
    > How do I find this via code so that I can replace it? I've tried looking
    > for chr(13) + chr(10) and vbCr and vbCrLf and replacing them with "" but
    > it
    > doesn't seem to work. Am I missing something?
    >
    > Thanks,
    > James
    >
    >
     
    b.Wurm, Jun 6, 2005
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Hugo
    Replies:
    10
    Views:
    1,368
    Matt Humphrey
    Oct 18, 2004
  2. kaushikshome
    Replies:
    4
    Views:
    806
    kaushikshome
    Sep 10, 2006
  3. Replies:
    12
    Views:
    996
  4. Dev_SH
    Replies:
    0
    Views:
    675
    Dev_SH
    Dec 30, 2010
  5. Jules
    Replies:
    6
    Views:
    157
    Jules
    Jul 15, 2003
Loading...

Share This Page