At 11:08 -0600 28/01/2011, Puneet Kishor wrote:
>Can't really say what you are doing wrong, but you code is needlessly
>complicated; all those tildes are making my eyes swim.
I also have difficulty interpreting escaped toothpicks, and I didn't
joint the sqlite list to have my Perl style polished. Besides, there
is absolutely no way the Perl could be made less complicated.
>I would do the
>following
>
>my $q = "Delete c10";
>$q =~ s/(\d+)//;
>my $sth = $dbh->prepare('DELETE FROM contacts WHERE rowid = ?');
>my $rows_affected = $sth->execute($q);
Why would you do this rather than use $dbh->do ? It seems to add a
line of code to no purpose. And besides, whereas the 'do' routine
works fine in the standalone script, yours works in neither.
JD
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
