At 16:44 +0000 28/01/2011, Black, Michael (IS) wrote:
>Me thinkst you need to put singled quotes around $q{BUTTON}.
>
>my $rows = $dbh->do("DELETE FROM contacts WHERE rowid =\'$q{BUTTON}\'");
SInce the statement is in double quotes I surely wouldn't want to
escape the single quotes, but, as I said orignially I've tried with
single quotes round the integer (which surely is not necessary) and
it works with orcwithout in the coeected standalone script I posted
but stops execution of the script dead in the cgi script.
>You also don't appear to be checking for any error....which you
>should be seeing. I don't Perl/DBI well enough to show how to do
>that one.
Since exectuon dies I there is no way of displaying any error.
JD
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
