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. my life at the moment

my life at the moment

Scheduled Pinned Locked Moved The Lounge
databasecom
22 Posts 11 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.
  • J Offline
    J Offline
    Jeremy Falcon
    wrote on last edited by
    #1

    Now, this is a complicated SQL statement... Clickety[^] Jeremy Falcon

    C J M J S 8 Replies Last reply
    0
    • J Jeremy Falcon

      Now, this is a complicated SQL statement... Clickety[^] Jeremy Falcon

      C Offline
      C Offline
      Chris Losinger
      wrote on last edited by
      #2

      X| Cleek | Losinger Designs | ClickPic | ThumbNailer

      1 Reply Last reply
      0
      • J Jeremy Falcon

        Now, this is a complicated SQL statement... Clickety[^] Jeremy Falcon

        J Offline
        J Offline
        Jeff Varszegi
        wrote on last edited by
        #3

        Please tell me your job isn't to WRITE that! Regards, Jeff Varszegi

        J 1 Reply Last reply
        0
        • J Jeremy Falcon

          Now, this is a complicated SQL statement... Clickety[^] Jeremy Falcon

          M Offline
          M Offline
          Marc Clifton
          wrote on last edited by
          #4

          You're not using that on my website, are you? :-D Marc Microsoft MVP, Visual C# MyXaml MyXaml Blog

          J 1 Reply Last reply
          0
          • J Jeremy Falcon

            Now, this is a complicated SQL statement... Clickety[^] Jeremy Falcon

            J Offline
            J Offline
            Jason Hooper
            wrote on last edited by
            #5

            This only looks like a complicated SQL statement. If you look closely, you'll see it's a very simple SELECT operation from one table, with no joins, and without even any WHERE clauses. The presence of two very different character sets and the length itself of the query is long, and these make it seem complex. But I've written more complicated SQL in a tenth the space... I'm sure most of us have. :) - Jason (SonorkID 100.611) The Code Project - Orange makes the art grow fonder

            J 1 Reply Last reply
            0
            • J Jason Hooper

              This only looks like a complicated SQL statement. If you look closely, you'll see it's a very simple SELECT operation from one table, with no joins, and without even any WHERE clauses. The presence of two very different character sets and the length itself of the query is long, and these make it seem complex. But I've written more complicated SQL in a tenth the space... I'm sure most of us have. :) - Jason (SonorkID 100.611) The Code Project - Orange makes the art grow fonder

              J Offline
              J Offline
              Jeremy Falcon
              wrote on last edited by
              #6

              This was called a joke. It was meant to be funny. :| Jeremy Falcon

              A V P 3 Replies Last reply
              0
              • M Marc Clifton

                You're not using that on my website, are you? :-D Marc Microsoft MVP, Visual C# MyXaml MyXaml Blog

                J Offline
                J Offline
                Jeremy Falcon
                wrote on last edited by
                #7

                There goes the surprise. :) Jeremy Falcon

                1 Reply Last reply
                0
                • J Jeremy Falcon

                  Now, this is a complicated SQL statement... Clickety[^] Jeremy Falcon

                  S Offline
                  S Offline
                  Stefan Pedersen
                  wrote on last edited by
                  #8

                  Damn! Your graphics cards seems to be broken... or is it something I just drank??? Konichiwa! :) And if the paths that I have followed/have tread against the flow/there is no need for sorrow I am coming home Return, Crüxshadows

                  J 1 Reply Last reply
                  0
                  • S Stefan Pedersen

                    Damn! Your graphics cards seems to be broken... or is it something I just drank??? Konichiwa! :) And if the paths that I have followed/have tread against the flow/there is no need for sorrow I am coming home Return, Crüxshadows

                    J Offline
                    J Offline
                    Jeremy Falcon
                    wrote on last edited by
                    #9

                    Stefan Pedersen wrote: Your graphics cards seems to be broken Nah, my computer stayed up late last night drinking too much silicon. :) Jeremy Falcon

                    1 Reply Last reply
                    0
                    • J Jeff Varszegi

                      Please tell me your job isn't to WRITE that! Regards, Jeff Varszegi

                      J Offline
                      J Offline
                      Jeremy Falcon
                      wrote on last edited by
                      #10

                      Nope, just debugging it. Jeremy Falcon

                      1 Reply Last reply
                      0
                      • J Jeremy Falcon

                        Now, this is a complicated SQL statement... Clickety[^] Jeremy Falcon

                        G Offline
                        G Offline
                        Gary R Wheeler
                        wrote on last edited by
                        #11

                        You really know how to hurt a guy. My life at the moment is occupied with getting my language translation tool working such that it satisfies the Japanese engineers where I work. This tool is used by translators to edit the .RC files for each language that our application will support. Over the last few days, I figured out the following items:

                        • My application (the one being translated) is compiled for UNICODE, which is supposed to make supporting Far Eastern languages simpler.
                        • The resource script is compiled into UNICODE text in the .EXE/.DLL.
                        • My translator program is also compiled for UNICODE, thereby making translation text handling easier. So far, so good.
                        • .RC files must be encoded as MBCS (multibyte character set, not UNICODE)

                        Screeeeeechh! Bang, bang, CRUNCH! (sound of wheel cover rolling off into distance) What brain-dead son of a chihuaha and a rhesus monkey thought that one up! I have to read the text from the .RC file as MBCS, translate the relevant bits to UNICODE, let the user edit them, and then translate them from UNICODE back to MBCS just so the stupid resource compiler can turn the text back into UNICODE. By the way, did I mention that if you set the code page for the .RC file to 1200 (UNICODE), the farking IDE (.NET 2003) will no longer load the file? Grrr.


                        Software Zen: delete this;

                        J 1 Reply Last reply
                        0
                        • G Gary R Wheeler

                          You really know how to hurt a guy. My life at the moment is occupied with getting my language translation tool working such that it satisfies the Japanese engineers where I work. This tool is used by translators to edit the .RC files for each language that our application will support. Over the last few days, I figured out the following items:

                          • My application (the one being translated) is compiled for UNICODE, which is supposed to make supporting Far Eastern languages simpler.
                          • The resource script is compiled into UNICODE text in the .EXE/.DLL.
                          • My translator program is also compiled for UNICODE, thereby making translation text handling easier. So far, so good.
                          • .RC files must be encoded as MBCS (multibyte character set, not UNICODE)

                          Screeeeeechh! Bang, bang, CRUNCH! (sound of wheel cover rolling off into distance) What brain-dead son of a chihuaha and a rhesus monkey thought that one up! I have to read the text from the .RC file as MBCS, translate the relevant bits to UNICODE, let the user edit them, and then translate them from UNICODE back to MBCS just so the stupid resource compiler can turn the text back into UNICODE. By the way, did I mention that if you set the code page for the .RC file to 1200 (UNICODE), the farking IDE (.NET 2003) will no longer load the file? Grrr.


                          Software Zen: delete this;

                          J Offline
                          J Offline
                          Jeremy Falcon
                          wrote on last edited by
                          #12

                          Gary R. Wheeler wrote: .RC files must be encoded as MBCS (multibyte character set, not UNICODE) :wtf: That's news to me. (Un)fortunately, this app is in VB, and as my luck would have it - most VB programs don't take advantage of resource scripts. We're pulling the translations from a SQL database (the app is used over a citrix server). Gary R. Wheeler wrote: By the way, did I mention that if you set the code page for the .RC file to 1200 (UNICODE), the farking IDE (.NET 2003) will no longer load the file? LOL! That's about all I can say. So far, we've been doing all the Japanese development on a Japanese version of Windows XP with minimal problems. Of course, we're also using VB6 too. (insert sigh here) Jeremy Falcon

                          G 1 Reply Last reply
                          0
                          • J Jeremy Falcon

                            Now, this is a complicated SQL statement... Clickety[^] Jeremy Falcon

                            P Offline
                            P Offline
                            Prakash Nadar
                            wrote on last edited by
                            #13

                            now i see why software jobs are outsourced to India rather than China.:laugh:


                            God is Real, unless declared Integer.

                            A 1 Reply Last reply
                            0
                            • J Jeremy Falcon

                              This was called a joke. It was meant to be funny. :| Jeremy Falcon

                              A Offline
                              A Offline
                              Anthony_Yio
                              wrote on last edited by
                              #14

                              I think the DBMS is powerful as it supports multilingual field name in the SQL script. I think some DBMS only support English. Sonork 100.41263:Anthony_Yio Life is about experiencing ...

                              1 Reply Last reply
                              0
                              • P Prakash Nadar

                                now i see why software jobs are outsourced to India rather than China.:laugh:


                                God is Real, unless declared Integer.

                                A Offline
                                A Offline
                                Anthony_Yio
                                wrote on last edited by
                                #15

                                Those are Kanji(Japanese) words by the way. Sonork 100.41263:Anthony_Yio Life is about experiencing ...

                                P 1 Reply Last reply
                                0
                                • A Anthony_Yio

                                  Those are Kanji(Japanese) words by the way. Sonork 100.41263:Anthony_Yio Life is about experiencing ...

                                  P Offline
                                  P Offline
                                  Prakash Nadar
                                  wrote on last edited by
                                  #16

                                  dont matter, all look the same to me. :-)


                                  God is Real, unless declared Integer.

                                  1 Reply Last reply
                                  0
                                  • J Jeremy Falcon

                                    This was called a joke. It was meant to be funny. :| Jeremy Falcon

                                    V Offline
                                    V Offline
                                    Vadim Tabakman
                                    wrote on last edited by
                                    #17

                                    Just goes to show. Humour is sometimes wasted on the geek. hehe :~

                                    1 Reply Last reply
                                    0
                                    • J Jeremy Falcon

                                      This was called a joke. It was meant to be funny. :| Jeremy Falcon

                                      P Offline
                                      P Offline
                                      Paul Watson
                                      wrote on last edited by
                                      #18

                                      It is scary... funny but scary. Give me a pivot cube set with multiple unions and joins over your one anyday, you poor bugger. regards, Paul Watson Bluegrass South Africa Christopher Duncan quoted: "...that would require my explaining Einstein's Fear of Relatives" Crikey! ain't life grand? Einstein says...

                                      1 Reply Last reply
                                      0
                                      • J Jeremy Falcon

                                        Now, this is a complicated SQL statement... Clickety[^] Jeremy Falcon

                                        P Offline
                                        P Offline
                                        Paul Watson
                                        wrote on last edited by
                                        #19

                                        I sent that image around to the dev team as well as a new guy in London, I have honestly just had the following conversation on IM with him :-D (another co-worker is called Jeremy so when he saw the ~jeremy in the screenshot he thought he meant my co-worker, not you) Co-worker: whats that all about? Paul: I sent that to you Co-worker: ja and? Paul: Jeremy is learning Chinese. Microsoft is pushing for Chinese to be the preferred development language. Co-worker: what! Co-worker: really? Paul: Ask him. Co-worker: What the fuck are we going to do? None of us can speak Chinese, does this affect .NET? Paul: Konichiwa. I can speak some. Paul: Move with the times eh Co-worker: lol. Do we have to buy new software? Paul: No, Notepad supports it fine Co-worker: We use Notepad to dev!?!? Paul: :) relax... Paul: A friend sent me that SQL statement, he is working with a Chinese team and he had to debug that SQL statement. I just thought it was funny Co-worker: what a mission Paul: Indeed, but he gets free sake all day Co-worker: lol Thanks for the morning laugh Jeremy. regards, Paul Watson Bluegrass South Africa Christopher Duncan quoted: "...that would require my explaining Einstein's Fear of Relatives" Crikey! ain't life grand? Einstein says...

                                        J 1 Reply Last reply
                                        0
                                        • P Paul Watson

                                          I sent that image around to the dev team as well as a new guy in London, I have honestly just had the following conversation on IM with him :-D (another co-worker is called Jeremy so when he saw the ~jeremy in the screenshot he thought he meant my co-worker, not you) Co-worker: whats that all about? Paul: I sent that to you Co-worker: ja and? Paul: Jeremy is learning Chinese. Microsoft is pushing for Chinese to be the preferred development language. Co-worker: what! Co-worker: really? Paul: Ask him. Co-worker: What the fuck are we going to do? None of us can speak Chinese, does this affect .NET? Paul: Konichiwa. I can speak some. Paul: Move with the times eh Co-worker: lol. Do we have to buy new software? Paul: No, Notepad supports it fine Co-worker: We use Notepad to dev!?!? Paul: :) relax... Paul: A friend sent me that SQL statement, he is working with a Chinese team and he had to debug that SQL statement. I just thought it was funny Co-worker: what a mission Paul: Indeed, but he gets free sake all day Co-worker: lol Thanks for the morning laugh Jeremy. regards, Paul Watson Bluegrass South Africa Christopher Duncan quoted: "...that would require my explaining Einstein's Fear of Relatives" Crikey! ain't life grand? Einstein says...

                                          J Offline
                                          J Offline
                                          Jeremy Falcon
                                          wrote on last edited by
                                          #20

                                          Paul Watson wrote: Thanks for the morning laugh Jeremy. Ditto, it's Wed. morning over here and I just read your post and laughed. :) Jeremy Falcon

                                          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