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.
  • 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