Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. A thief

A thief

Scheduled Pinned Locked Moved The Lounge
database
24 Posts 17 Posters 1 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • C 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]

    realJSOPR Offline
    realJSOPR Offline
    realJSOP
    wrote on last edited by
    #9

    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

    1 Reply Last reply
    0
    • realJSOPR 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

      P Offline
      P Offline
      Paul Conrad
      wrote on last edited by
      #10

      :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

      1 Reply Last reply
      0
      • L Lost User

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

        F Offline
        F Offline
        fred_
        wrote on last edited by
        #11

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

        1 Reply Last reply
        0
        • C 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]

          C Offline
          C Offline
          CPallini
          wrote on last edited by
          #12

          :-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]

          L 1 Reply Last reply
          0
          • R Rama Krishna Vavilala

            I use this one a lot:

            select * from tablename where 1 = 2

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

            M Offline
            M Offline
            MrEyes
            wrote on last edited by
            #13

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

            1 Reply Last reply
            0
            • R Rama Krishna Vavilala

              I use this one a lot:

              select * from tablename where 1 = 2

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

              M Offline
              M Offline
              Member 96
              wrote on last edited by
              #14

              ? 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

              R 1 Reply Last reply
              0
              • C 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]

                L Offline
                L Offline
                led mike
                wrote on last edited by
                #15

                CPallini wrote:

                My 5.

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

                P 1 Reply Last reply
                0
                • L Lost User

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

                  S Offline
                  S Offline
                  Single Step Debugger
                  wrote on last edited by
                  #16

                  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.

                  S 1 Reply Last reply
                  0
                  • M Member 96

                    ? 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

                    R Offline
                    R Offline
                    Rama Krishna Vavilala
                    wrote on last edited by
                    #17

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

                    1 Reply Last reply
                    0
                    • S 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.

                      S Offline
                      S Offline
                      Single Step Debugger
                      wrote on last edited by
                      #18

                      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.

                      L 1 Reply Last reply
                      0
                      • S 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.

                        L Offline
                        L Offline
                        Lost User
                        wrote on last edited by
                        #19

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

                        I are troll :)

                        1 Reply Last reply
                        0
                        • R Rama Krishna Vavilala

                          I use this one a lot:

                          select * from tablename where 1 = 2

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

                          M Offline
                          M Offline
                          Miszou
                          wrote on last edited by
                          #20

                          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

                          R 1 Reply Last reply
                          0
                          • M Miszou

                            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

                            R Offline
                            R Offline
                            Rama Krishna Vavilala
                            wrote on last edited by
                            #21

                            Neat! I ought to remember this!

                            1 Reply Last reply
                            0
                            • L led mike

                              CPallini wrote:

                              My 5.

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

                              P Offline
                              P Offline
                              PIEBALDconsult
                              wrote on last edited by
                              #22

                              Speaking of hijacking threads; as I recall, a few months ago, there was a minor competition to see who could do it best.

                              L 1 Reply Last reply
                              0
                              • P PIEBALDconsult

                                Speaking of hijacking threads; as I recall, a few months ago, there was a minor competition to see who could do it best.

                                L Offline
                                L Offline
                                led mike
                                wrote on last edited by
                                #23

                                PIEBALDconsult wrote:

                                a few months ago

                                I was just inducted today[^], that's why I made that comment ;)

                                1 Reply Last reply
                                0
                                • L Lost User

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

                                  Z Offline
                                  Z Offline
                                  Zhat
                                  wrote on last edited by
                                  #24

                                  how about: Delete DumbAss from CP_List_Of_Jerks where DumbAss = 'onyang2' Better yet: Delete * from Life where DumbAss = 'onyang2'

                                  1 Reply Last reply
                                  0
                                  Reply
                                  • Reply as topic
                                  Log in to reply
                                  • Oldest to Newest
                                  • Newest to Oldest
                                  • Most Votes


                                  • Login

                                  • Don't have an account? Register

                                  • Login or register to search.
                                  • First post
                                    Last post
                                  0
                                  • Categories
                                  • Recent
                                  • Tags
                                  • Popular
                                  • World
                                  • Users
                                  • Groups