Code not displayed properly

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Tag Issues with Content » Code not displayed properly

Code not displayed properly

Rate Topic

Display Mode

Topic Options

Author

Message

JacekO

Posted Wednesday, March 18, 2009 7:57 AM

SSC-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

Lowell

Posted Wednesday, March 18, 2009 8:37 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 5:04 AM
Points: 11,606, Visits: 27,651

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

JacekO

Posted Wednesday, March 18, 2009 8:51 AM

SSC-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

Steve Jones - SSC Editor

Posted Thursday, March 19, 2009 2:07 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 9:03 PM
Points: 31,406, Visits: 13,723

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

JacekO

Posted Thursday, March 19, 2009 2:11 PM

SSC-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

JacekO

Posted Thursday, March 19, 2009 2:20 PM

SSC-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 »

Permissions