RE: Deleting records while parsing query results (in Perl DBI)?

2003-03-01 Thread Don Read
ExpiryDate On 28-Feb-2003 Jeff Snoxell wrote: Hi, If I run a mysql query then work through the results of that query one at a time, deleting the record sometimes eg: while (my $href = $sth-fetchrow_hashref()) { if ($href-{'ExpiryDate'} eq '2003-02-22 00:00:00') { # Do something

Deleting records while parsing query results (in Perl DBI)?

2003-02-28 Thread Jeff Snoxell
Hi, If I run a mysql query then work through the results of that query one at a time, deleting the record sometimes eg: while (my $href = $sth-fetchrow_hashref()) { if ($href-{'ExpiryDate'} eq '2003-02-22 00:00:00') { # Do something # then... $db-do(DELETE FROM MyTable WHERE