Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re^4: query linking

by monarch (Priest)
on Feb 11, 2009 at 04:20 UTC ( [id://742968]=note: print w/replies, xml ) Need Help??


in reply to Re^3: query linking
in thread query linking

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?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://742968]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (4)
As of 2024-03-28 16:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found