Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Site Related Discussions
 Code Tags, Max width

Author  Topic 

DBA in the making
Aged Yak Warrior

638 Posts

Posted - 2010-03-30 : 18:09:15
Is it possible to enforce a maximum widths for lines within code tags? At the moment, if someone post 100's of characters on a single line within code tags, the forum renders that in a single line. The makes some threads difficult to read. It might be a good idea for the forum software to somehow limit this to say 120 characters, at which point a CR will be inserted.

Failing that, perhaps moderators could edit such code when they see it, or ask the person who posted it to edit it. There's really no need to have such a large number of characters on a single line.

There are 10 types of people in the world, those that understand binary, and those that don't.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-30 : 22:37:10
If you have a particular thread in mind, just let me know.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-03-31 : 00:08:45
Love your sig DBA in the making
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-03-31 : 01:35:17
quote:
Originally posted by tkizer

If you have a particular thread in mind, just let me know.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog


http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=140635

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-03-31 : 03:55:05
I made a suggestion in the thread that Madhi points to - specifically this post:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=140635#552885

One thought: Could perhaps have some SQL that SPLITS the lines in a Code Block (in order to get the Max Line Length) and rejects it if too long.

Suggestions for suitable validation errors messages pls?, I'll kick off with one:

"You call that formatted? Pah!"
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-03-31 : 03:56:40
I think there was something, way back?, that could colour code SQL submissions? Maybe that could be leveraged for line-width too ...

... but I don't see much appetite to modernise the forums at all here, which I think is a pity.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-31 : 12:48:51
quote:
Originally posted by madhivanan

quote:
Originally posted by tkizer

If you have a particular thread in mind, just let me know.


http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=140635



I meant for me to go edit so that the horizontal bars are removed.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-04-01 : 03:05:03
Start a new thread for "Threads that need MOD editing" ? (i.e. like the SPAM thread)

... just a thought ...
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-04-01 : 04:28:46
quote:
Originally posted by Kristen

Start a new thread for "Threads that need MOD editing" ? (i.e. like the SPAM thread)

... just a thought ...



I doubt that will work effectively

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-04-01 : 05:46:02
Indeed, on past performance, but I think it does at least put it in a place where some batch admin MOD-ing can be done.
Go to Top of Page

DBA in the making
Aged Yak Warrior

638 Posts

Posted - 2010-04-06 : 14:54:57
Here's one that's far too wide:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=142444

There are 10 types of people in the world, those that understand binary, and those that don't.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-06 : 15:18:01
Fixed.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

DBA in the making
Aged Yak Warrior

638 Posts

Posted - 2010-04-06 : 15:21:22


There are 10 types of people in the world, those that understand binary, and those that don't.
Go to Top of Page

DBA in the making
Aged Yak Warrior

638 Posts

Posted - 2010-04-08 : 09:17:45
Here's another candidate:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=142670

There are 10 types of people in the world, those that understand binary, and those that don't.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-08 : 13:36:02
Fixed.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

DBA in the making
Aged Yak Warrior

638 Posts

Posted - 2010-04-27 : 07:28:50
This is a particularly bad one. It flatlined my CPU for about 15 seconds while firefox rendered the page.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=143586

------------------------------------------------------------------------------------
Any and all code contained within this post comes with a 100% money back guarantee.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-27 : 12:23:52
I'd fix it, but I just don't have the time for that one. I spent a few minutes on it and gave up. What's worse is that the wide part of the code is repeated in a few other posts, which would mean editing those too. Perhaps someone else has more time to fix it, but I throw in the towel on that one!

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

DBA in the making
Aged Yak Warrior

638 Posts

Posted - 2010-04-27 : 12:37:49
I was hoping you could replace it with Really long comma delimited string.

------------------------------------------------------------------------------------
Any and all code contained within this post comes with a 100% money back guarantee.
Go to Top of Page
   

- Advertisement -