TexasCHLforum.com

Nice!

Server error....
Ewww....who wrote that SQL query?

SQLGeek wrote:Server error....

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

Ewww....who wrote that SQL query?

That's nothing compared to some of the SQL monstrosities I've written at work.

AJ80 wrote:

SQLGeek wrote:Server error....

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

Ewww....who wrote that SQL query?

That's nothing compared to some of the SQL monstrosities I've written at work.

<hijack on>

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>

AJ80 wrote:

SQLGeek wrote:Server error....

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

Ewww....who wrote that SQL query?

That's nothing compared to some of the SQL monstrosities I've written at work.

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.

I feel the sock-puppets pain.