Why isn't my vbcr working? 2

[Cloonalt]

I want a line break in the middle of this string. Can I do that? Maybe my syntax is wrong - it's just ignoring my vbcr.

Any help appreciated.

strSQL = "SELECT 'Matter Comments: ' + ISNULL(matter.mdesc2, '') + ' ' + " & _
"ISNULL(matter.mdesc3, '') + " & vbCr & " + 'Client Comments: ' + ISNULL(client.clname2, '') " & _
"AS Comments FROM matter INNER JOIN client ON matter.mclient = client.clnum " & _
"Where mmatter = " & "'" & Matter & "'" & _
"order by mmatter"

 

[DotNetGnat]

try this:

strSQL = "SELECT 'Matter Comments: ' + ISNULL(matter.mdesc2, '') + ' ' + " & _
        "ISNULL(matter.mdesc3, '')  + Char(10)+Char(13) +  'Client Comments: ' + ISNULL(client.clname2, '') " & _
        "AS Comments FROM matter INNER JOIN client ON matter.mclient = client.clnum " & _
        "Where mmatter = " & "'" & Matter & "'" & _
        "order by mmatter"

-DNG

 

[SkipVought]

Hi,

use vblf

Here is your evaluated string. What are you doing? Does not make sense summing what seen to be strings.
[tt]
"SELECT 'Matter Comments: ' + ISNULL(matter.mdesc2, '') + ' ' + ISNULL(matter.mdesc3, '') +
+ 'Client Comments: ' + ISNULL(client.clname2, '') AS Comments FROM matter INNER JOIN client ON matter.mclient = client.clnum Where mmatter = ''order by mmatter"
[/tt]


[tt][highlight blue][white]
^{~ ~}[/white][/highlight][highlight red][white] To be ^~[/white][/highlight][highlight blue][white]
^~ BE ^~[/white][/highlight][highlight white][blue] safe on the 4^{th ~}[/blue][/highlight][highlight blue][white]
^~ ADVISED ^~[/white][/highlight][highlight red][white] Don't ^~[/white][/highlight][highlight blue][white]
^{~ ~}[/white][/highlight][highlight white][blue] get a ^~[/blue][/highlight]
[highlight red][white] 5^th on the 3^{rd ~}[/white][/highlight]
[highlight white][blue] Or you might not ^~[/blue][/highlight]
[highlight red][white] Come 4^th on the 5^th 4^thwith ^~[/white][/highlight]
[/tt]


Skip,

_[red][/red]

 

[SQLDenis]

what about VbCrLf

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[gmmastros]

change:

[tt]
strSQL = "SELECT 'Matter Comments: ' + ISNULL(matter.mdesc2, '') + ' ' + " & _
"ISNULL(matter.mdesc3, '') + [blue]" & vbCr & " + [/blue] 'Client Comments: ' + ISNULL(client.clname2, '') " & _
"AS Comments FROM matter INNER JOIN client ON matter.mclient = client.clnum " & _
"Where mmatter = " & "'" & Matter & "'" & _
"order by mmatter"
[/tt]

To:

strSQL = "SELECT 'Matter Comments: ' + ISNULL(matter.mdesc2, '') + ' ' + " & _
        "ISNULL(matter.mdesc3, '')  + [!]Char(13) + char(10) + [/!] 'Client Comments: ' + ISNULL(client.clname2, '') " & _
        "AS Comments FROM matter INNER JOIN client ON matter.mclient = client.clnum " & _
        "Where mmatter = " & "'" & Matter & "'" & _
        "order by mmatter"

By doing it this way, SQL Server server will add the cr lf for your (using their ascii values). If you test this in Query Analyzer, you won't see the seperate lines because QA always 'chops' them off.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[gmmastros]

Correction: Query Analyzer ignores cr's and lf's when displaying in grid mode. By showing the results in text mode, you will see the cr lf's.

Here's how...

Select 'Line 1:' + Char(13) + Char(10) + 'Line 2:'

Copy/paste to QA. press F5. If you're in grid mode (which is the default), you'll see:

[!]Line 1: Line 2:[/!]

Now, right click in the window, select Results In Text and run again. Now you'll see:

[tt][blue]
----------------
Line 1:
Line 2:

(1 row(s) affected)[/blue][/tt]


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Cloonalt]

Thank you! That worked.