Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 @ 12:53 PM
Points: 14,433, Visits: 37,807
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
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: 2 days ago @ 7:24 PM
Points: 33,930, Visits: 18,039
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