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

Scripts: SQLcode displays in 1 line Expand / Collapse
Author
Message
Posted Friday, October 28, 2011 7:15 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 3, 2014 3:11 AM
Points: 389, Visits: 306
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
Posted Saturday, October 29, 2011 6:05 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 5:13 PM
Points: 33,100, Visits: 15,210
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
Posted Wednesday, November 2, 2011 3:47 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 3, 2014 3:11 AM
Points: 389, Visits: 306
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
Posted Wednesday, November 2, 2011 4:33 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:48 AM
Points: 21,388, Visits: 9,604
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
Posted Tuesday, November 8, 2011 5:37 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 3, 2014 3:11 AM
Points: 389, Visits: 306
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
Post #1201964
Posted Thursday, August 9, 2012 10:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 2, 2014 3:07 PM
Points: 4, Visits: 174
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
Posted Thursday, August 9, 2012 10:19 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 5:13 PM
Points: 33,100, Visits: 15,210
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 »

Add to briefcase

Permissions Expand / Collapse