Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw

Re^2: query linking

by monarch (Priest)
on Feb 11, 2009 at 03:51 UTC ( #742960=note: print w/replies, xml ) Need Help??

in reply to Re: query linking
in thread query linking

Oh, by the way, this seems fairly typical of code that I've witnessed in the investment banking industry. Biggest bunch of cowboys that ever lived.. God only knows how any of their financial transactions and calculations ever actually produced viable answers - clearly logical thought (such as programming) is way beyond the average investment banker coder..

Replies are listed 'Best First'.
Re^3: query linking
by CountZero (Bishop) on Feb 11, 2009 at 07:00 UTC
    I think you have found the secret of the present financial crisis. It was brought upon us by crappy SQL-code! LOL


    A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

Re^3: query linking
by ritzi86 on Feb 11, 2009 at 03:56 UTC
    monarch i seem to get this feeling that you can help me with this if u can i would definitely appreciate the help.. thanks a lot in advance..
      I cannot help you; if you don't understand the purpose of your program (i.e. the database query) then you have big problems.

      However, some pointers:

      • use the concat operator, i.e. instead of $sqlcode = "$sqlcode AND ( blah )"; say $sqlcode .= "AND ( blah )";
      • reformat your SQL query as I have done to try and make the SQL easier to understand
      • print out your query after constructing it (e.g. print( $sqlcode );)
      • pay close attention to your errors - does Perl generate warnings? Does your database generate warnings?

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://742960]
[stevieb]: it is exceptionally difficult I'm finding to debug a dist that is x-platform, where on each platform you're wrapping a different binary. Trying to co-ordinate a successful test run where tests are extensive is a nightmare, especially when the dist...
[stevieb]:'re testing is a test system itself. 10+ documented issues fixed, another half dozen found while fixing the original ones. I'm getting there...
[stevieb]: Then throw in changes to Windows that throws everything you trusted right out the window.
[shmem]: that's why it is called "Windows"
[stevieb]: shmem thanks for the 'insight' :P
[shmem]: good thing that Sun already took "OpenWindows", otherwise I'd not stop to shudder imagining an "OpenWindows" from MS
[shmem]: more garbage in, more garbage out that would be
[stevieb]: I found that win10 broke a C# library I was using for one project while enhancing tests for a Perl dist, which breaks other Perl dists, and I'm about to throw my hands up on berrybrew. win2k12 broke one thing, win10 breaks something...
[stevieb]: ...unrelated which requires replacing a lot of code and a whole lib. I'm about to go nix only ffs

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (8)
As of 2017-03-28 22:02 GMT
Find Nodes?
    Voting Booth?
    Should Pluto Get Its Planethood Back?

    Results (342 votes). Check out past polls.