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