ritzi86 has asked for the wisdom of the Perl Monks concerning the following question:

hi i am a new user of perl. i have two sql queries written with perl script.the problem is when i run the script i need the queries to be linked and then run.but this is not happening.can you tell me what is wrong here.here is the script that is present in between the queries
...
$sqlcmd ="$sqlcmd and ("; $i = 0; foreach $contract_key (sort(keys(%contracts))) { $sqlcmd="$sqlcmd cc.contract_type = $contract_key"; $i++; if ($i < $contract_count) { $sqlcmd=" $sqlcmd or "; } } $sqlcmd="$sqlcmd )"; ...... thanks in advance

Replies are listed 'Best First'.
Re: query linking
by shekarkcb (Beadle) on Feb 11, 2009 at 09:04 UTC