Box characters from SQL CRLF output

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Echooff3
    New Member
    • Jul 2007
    • 22

    #1

    Box characters from SQL CRLF output

    When returning results from a SQL query containing 'char(10) + char(13)' to a multiline textbox results in box characters instead of the line feed. How do i get VB.net to interphret the line feed correctly???

    Example:

    CUSTOMER_Addres s.Address + char(10) + char(13) + CUSTOMER_Addres s.City

    Returns:

    123 Fakestreet □□ Fake City
  • Killer42
    Recognized Expert Expert
    • Oct 2006
    • 8429

    #2
    Actually, the standard is CrLf. What you're putting in there is LfCr. Not the same thing.

    In fact, you might be better advised to use vbNewLine.

    Comment

    • Echooff3
      New Member
      • Jul 2007
      • 22

      #3
      GANGSTA! That worked! Thanks!

      Comment

      • Killer42
        Recognized Expert Expert
        • Oct 2006
        • 8429

        #4
        Originally posted by Echooff3
        GANGSTA! That worked! Thanks!
        Glad to help. :)

        Comment

        Working...