Scripts: SQLcode displays in 1 line

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » SQLServerCentral.com Website Issues » Scripts: SQLcode displays in 1 line

Scripts: SQLcode displays in 1 line

Rate Topic

Display Mode

Topic Options

Author

Message

Rhox

Posted Friday, October 28, 2011 7:15 AM

Old Hand

Group: General Forum Members
Last Login: Friday, May 03, 2013 5:54 AM
Points: 388, Visits: 293

I try to submit a script.
But when I paste the code it's displayed as 1 line.

Tried to copy/paste it from SSMS, notepad, MS Word,... but always 1 line

How can I properly paste my code (readeable) before I publish it?

Post #1197470

Steve Jones - SSC Editor

Posted Saturday, October 29, 2011 6:05 PM

SSC-Dedicated

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

I would try pasting it in notepad, and ensure it has the line breaks, then cut/paste from notepad (after saving) to the form.

Are you pasting in the script code box or the description box? Which browser?

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1197775

Rhox

Posted Wednesday, November 02, 2011 3:47 AM

Old Hand

Group: General Forum Members
Last Login: Friday, May 03, 2013 5:54 AM
Points: 388, Visits: 293

I've tried to use Notepad, but still 1 line in the code box.
I use IE9.
When I'm at work, I will try to use Chrome...

Post #1199158

Ninja's_RGR'us

Posted Wednesday, November 02, 2011 4:33 AM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 10:55 PM
Points: 21,357, Visits: 9,534

Rhox (11/2/2011)

I've tried to use Notepad, but still 1 line in the code box.
I use IE9.
When I'm at work, I will try to use Chrome...

I have that same problem when I open .txt attachements on this site. The browser treats the file as html and that completely screws up any formatting.

Not sure if this is what you are doing but it may help.

Post #1199181

Rhox

Posted Tuesday, November 08, 2011 5:37 AM

Old Hand

Group: General Forum Members
Last Login: Friday, May 03, 2013 5:54 AM
Points: 388, Visits: 293

Rhox (11/2/2011)

I've tried to use Notepad, but still 1 line in the code box.
I use IE9.
When I'm at work, I will try to use Chrome...

Even in Chrome, I can not paste into the SQL code box Sad

Post #1201964

michaellascuola

Posted Thursday, August 09, 2012 10:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 11:20 AM
Points: 4, Visits: 171

I'm having the same issue. I bullheadedly tried to make it work entering the script one line at a time, using different browsers, using a browser via remote control software. Even wrote an autohotkey script.

I've been trying to paste a stupid 51-line script for more than an hour.

How can such an advanced website in such an advanced society prevent a 20+ year old technology like paste?

Post #1342807

Steve Jones - SSC Editor

Posted Thursday, August 09, 2012 10:19 AM

SSC-Dedicated

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

It's got to be a security thing. I've pasted in scripts today from both SSMS and Notepad, with FF and Chrome, and they work.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1342817

« Prev Topic | Next Topic »

Permissions