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

This node falls below the community's threshold of quality. You may see it by logging in.

Replies are listed 'Best First'.
Re^4: query linking
by monarch (Priest) on Feb 11, 2009 at 04:20 UTC
    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?
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom