[code] blocks not respecting line feeds all of the sudden

Question

Post reply

[code] blocks not respecting line feeds all of the sudden

Lowell

SSC Guru

Points: 323518
More actions
February 23, 2009 at 11:19 am

#63507

all of the sudden today, code that i paste between {code} {/code} blocks (with square brackets) are losing their CrFl--newline whatever in them;
anyone know if there was a change to the editor?
if i preview before posting, it looks fine, but the final post loses then:
example:
--for users who are too lazy to type "SELECT * FROM"
CREATE procedure sp_show
--USAGE: sp_show gmact
@TblName varchar(128)
--WITH ENCRYPTION
As
Begin
exec('Select * from ' + @TblName)
End
--for users who are too lazy to type "SELECT * FROM"
CREATE procedure sp_show
--USAGE: sp_show gmact
@TblName varchar(128)
--WITH ENCRYPTION
As
Begin
exec('Select * from ' + @TblName)
End
or
[font="Courier New"]--for users who are too lazy to type "SELECT * FROM"
CREATE PROCEDURE sp_show
--USAGE: sp_show gmact
@TblName VARCHAR(128)
--WITH ENCRYPTION
AS
BEGIN
EXEC('Select * from ' + @TblName)
END      [/font]
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!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736210 More actions · Answer 1

Well that stinks.

Code test from here:

select *

from myTable

where Mycol = "test"

RBarryYoung SSC Guru Points: 143329 More actions · Answer 2

Looks OK to me. (Or has it been fixed already?)

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Lowell SSC Guru Points: 323518 More actions · Answer 3

yes it's fixed...my original posts had only single line that stretched a million characters....Steve's all over it apparently.

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!

Steve Jones - SSC Editor SSC Guru Points: 736210 More actions · Answer 4

I think I fixed it. There was a compression setting we were playing with to remove whitespace. Apparently it whacked the line feeds.