in reply to DBI::ODBC Delete Error

(Warning: Untested code)

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
    CountZero, your suggestion worked great, thanks!

    --
    paul