in reply to System call

Are you looping over the queries, calling prepare() and execute() within that loop?

Being right, does not endow the right to be rude; politeness costs nothing.
Being unknowing, is not the same as being stupid.
Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

Replies are listed 'Best First'.
Re^2: System call
by Win (Novice) on Dec 21, 2004 at 16:04 UTC
    Along the lines of: 
    
 my $Return_results = "Select * from Result_storage_keep where Unique_
+identifier LIKE ".$Request_id." AND Aggregated_area = Instance_name A
+ND Disease_cat = Cause_catagory\;";

  my $sth_C = $dbh->prepare($Return_results) or die "Couldn't prepare 
+query: ".$dbh->errstr;
  
  $sth_C->execute() or die "Couldn't execute query: ".$sth_C->errstr;

    [download]
    Yes
[reply]
[d/l]

In Section Seekers of Perl Wisdom