Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Code not displayed properly Expand / Collapse
Author
Message
Posted Wednesday, March 18, 2009 7:57 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 29, 2011 2:59 PM
Points: 473, Visits: 606
If I type the code below using the operators instead of the bolded words it gets posted like this: salesMonth 0

salesMonth lessorequal @month and YTD = 0 OR salesMonth = @month and YTD notequal 0

Somehow it is interpreted as a HTML tag or something.


---------------------------------------------
Nothing is impossible.
It is just a matter of time and money.
Post #678483
Posted Wednesday, March 18, 2009 8:37 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:07 AM
Points: 12,903, Visits: 32,145
testing regular text vs the {code} blocks:
with ampersand LT semicolon escapes:
salesMonth <= @month and YTD = 0 OR salesMonth = @month and YTD <> 0
as typed
salesMonth 0

salesMonth   0

yes you are right...seems to be stripping out the stu assuming HTML tags. Doesn't matter if it's regualr text or {code}


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #678549
Posted Wednesday, March 18, 2009 8:51 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 29, 2011 2:59 PM
Points: 473, Visits: 606
I think the editor should automatically translate the less then and more then into HTML escape sequences. I do not use HTML that frequently to remember all the escape sequences.

It appears the problem becames 'visible' when the LT and GT signs are in the same line. The below examples both have the same text but the text in example 2 is all in one line and is interpreted as a HTML.

EXAMPLE 1
sales < 0
and
sales > 0

EXAMPLE 2
sales 0


---------------------------------------------
Nothing is impossible.
It is just a matter of time and money.
Post #678567
Posted Thursday, March 19, 2009 2:07 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:59 PM
Points: 31,082, Visits: 15,529
If you enclose code in the [ code ] tags (to the left), it should work.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #679887
Posted Thursday, March 19, 2009 2:11 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 29, 2011 2:59 PM
Points: 473, Visits: 606
Trying if it works.
(It did not in the preview)

EXAMPLE 2
sales   0




---------------------------------------------
Nothing is impossible.
It is just a matter of time and money.
Post #679893
Posted Thursday, March 19, 2009 2:20 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 29, 2011 2:59 PM
Points: 473, Visits: 606
Steve,
Either I did not understand what your instructions or it still does not work.

That part "(to the left)" is not quite clear to me.


---------------------------------------------
Nothing is impossible.
It is just a matter of time and money.
Post #679908
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse