
Sock Puppet
Moderators: carlson1, Charles L. Cotton
Re: Sock Puppet
Server error....
Ewww....who wrote that SQL query?
Code: Select all
Error, query failed Table './securetheborder/section' is marked as crashed and last (automatic?) repair failedSELECT SC.*, S.directory, S.default_id, S.section FROM sectioncontent SC, section S WHERE SC.ID = 1 AND SC.section_id = S.section_id
Psalm 91:2
Re: Sock Puppet
That's nothing compared to some of the SQL monstrosities I've written at work.SQLGeek wrote:Server error....
Ewww....who wrote that SQL query?Code: Select all
Error, query failed Table './securetheborder/section' is marked as crashed and last (automatic?) repair failedSELECT SC.*, S.directory, S.default_id, S.section FROM sectioncontent SC, section S WHERE SC.ID = 1 AND SC.section_id = S.section_id

Re: Sock Puppet
<hijack on>AJ80 wrote:That's nothing compared to some of the SQL monstrosities I've written at work.SQLGeek wrote:Server error....
Ewww....who wrote that SQL query?Code: Select all
Error, query failed Table './securetheborder/section' is marked as crashed and last (automatic?) repair failedSELECT SC.*, S.directory, S.default_id, S.section FROM sectioncontent SC, section S WHERE SC.ID = 1 AND SC.section_id = S.section_id
EEP!! Memories!!!
Back in my Cold Fusion days, I was called in to speed up some of the web apps. Turns out that it's easy money when the original developers start with "Select * from ..." to sort and print 3 records of data!
</hijack>
American by birth, Texan by the grace of God!
Re: Sock Puppet
I'm sure but anytime I see things like "SELECT *"...I want to run away screaming. Not a fan of the non-ANSII joins either.AJ80 wrote:That's nothing compared to some of the SQL monstrosities I've written at work.SQLGeek wrote:Server error....
Ewww....who wrote that SQL query?Code: Select all
Error, query failed Table './securetheborder/section' is marked as crashed and last (automatic?) repair failedSELECT SC.*, S.directory, S.default_id, S.section FROM sectioncontent SC, section S WHERE SC.ID = 1 AND SC.section_id = S.section_id

Psalm 91:2
- Purplehood
- Senior Member
- Posts: 4638
- Joined: Thu May 29, 2008 3:35 pm
- Location: Houston, TX