A thief

Lost User

select * from tablename where(1<2); Works on any database

Ennis Ray Lynch Jr

Its Friday so I am a little slow. What the problem?

Need custom software developed? I do C# development and consulting all over the United States.
If you don't ask questions the answers won't stand in your way.
Doing a job is like selecting a mule, you can't choose just the front half xor the back half so when you ask me to do a job don't expect me to do it half-assed.

Baconbutty

I think OP has sh1t for brains.

My new favourite phrase - "misdirected leisure activity"

realJSOP

He's on yang2. It must be some sort of new oriental mind expanding drug...

"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

Chris Meech

:wtf: :wtf: :wtf: It didn't work on mine :confused: :confused: :confused:

select * from tablename where (1<2)
*
ERROR at line 1:
ORA-00942: table or view does not exist

:)

Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

Graham Bradshaw

Chris Meech wrote:

It didn't work on mine

I'm not surprised. The OP's SQL was written on a blue background - yours is on a yellow background.

Lost User

All you need now is access to a database... which you should never, ever be given. Use your specially crafted h4ck3r skills to root some boxes, yo!

Check out the CodeProject forum Guidelines[^]

Rama Krishna Vavilala

I use this one a lot:

select * from tablename where 1 = 2

modified on Friday, February 20, 2009 12:53 PM

realJSOP

even though both of you spelled "*" correctly...

"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

Paul Conrad

:laugh:

"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

fred_

OK either I'm really old or tired. I Don't get this

CPallini

:-D My 5.

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles]

MrEyes · modified on Friday, February 20, 2009 12:53 PM

I prefer this one myself: select top 42 * from tablename where('the meaning of life' != 'answered');

Member 96 · modified on Friday, February 20, 2009 12:53 PM

? Were you making a subtle joke that I missed? How is that different than select * from tablename?

"It's so simple to be wise. Just think of something stupid to say and then don't say it." -Sam Levenson

led mike

CPallini wrote:

My 5.

What about your 5? Are you trying to hijack this thread?

Single Step Debugger

Hey, onyang2 try this: delete from tablename where(1 < 2). Cool isn’t it?

The narrow specialist in the broad sense of the word is a complete idiot in the narrow sense of the word. Advertise here – minimum three posts per day are guaranteed.

Rama Krishna Vavilala

Sorry! corrected the query. I meant to say where 1 = 2 not 1 != 2.

Single Step Debugger

I was one-voted. Obviously some idiot executed the statement upon his database.

The narrow specialist in the broad sense of the word is a complete idiot in the narrow sense of the word. Advertise here – minimum three posts per day are guaranteed.

Lost User

That must be the first one-vote that actually carries satisfaction - it made my day :cool:

I are troll :)

Miszou · modified on Friday, February 20, 2009 12:53 PM

Actually, I've gotten into the habit of adding a where 1=1 clause to all my queries. It makes it really easy to comment out different clauses for testing, because every line starts with and. select * from tablename where 1=1 and condition1 and condition2 and condition3 In the above example, you can simply comment out (using --) any of the where clauses without worrying about trailing any leading or trailing and.

The StartPage Randomizer - The Windows Cheerleader - Twitter