Results 1 to 4 of 4

Thread: blank lines

  1. #1
    Join Date
    Jul 2003
    Posts
    4

    Unanswered: blank lines

    This may be an incredibly easy fix, but I can't figure it out!

    I'm working with xp_sendmail, and I'm trying to get it send out 2 separate queries.

    The problem is that in the body of the e-mail, it puts the right after each other, so it's kind of bad to look at.

    Is there any way I can insert a few blanks lines in between these 2 queries ? I tried a simple "print ' ' ", but I get access violation errors.

    Suggestions?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Well, this may not be an elegant solution, but you can always place a few statements like:

    select ''

    between your queries to add some blank space. Actually, this may print line separators defpending on your connection configuration, but you can also try something like this:

    select char(13) + char(13) + char(13) + char(13) + char(13)

    ...which will pad your output with five carriage returns.

    blindman

  3. #3
    Join Date
    Jul 2003
    Posts
    4
    Well that works, but as you said, the line separator shows up, which is kind of an eyesore. Do you or anyone else know any workarounds to this?

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Use the Char(13) method and you can include as many line-feeds as you want and you should only get one separator for the statement.

    blindman

Posting Permissions

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