in reply to DBI::ODBC Delete Error
What happens when you quote the parameter of areaID?
my $SQL = 'DELETE FROM [Production Words] WHERE areaId="ofn01506"';
Or even better, use a placeholder:
my $SQL = "DELETE FROM [Production Words] WHERE areaId=?"; my $sth = $DBH->prepare($SQL); $sth->execute('ofn01506') || die "Could not execute SQL statement ... +maybe invalid?\n$!";
Placeholders take care of the quoting automagically.
CountZero
"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Re: DBI::ODBC Delete Error
by vbrtrmn (Pilgrim) on Jan 07, 2004 at 23:21 UTC |