Re: DBI, duplicates

2005-06-14 Thread Ing. Branislav Gerzo
Ing. Branislav Gerzo [IBG], on Tuesday, June 14, 2005 at 21:10 (+0200) thinks about: IBG> my ($id) = $dbh->selectrow_array("select id from IBG> db_url where id = ?", {}, $url); ahm, maybe I'm too tired or blind, don't see that - I have error in select statement :) -- ...m8s, cu l8r,

DBI, duplicates

2005-06-14 Thread Ing. Branislav Gerzo
Hi all, I'm using MYSQL, and have this weird problem, here is self-explaining snippet: sub save_url { my $url = shift || die "Need url!"; my ($id) = $dbh->selectrow_array("select id from db_url where id = ?", {}, $url); unless ($id) { my $sth = $dbh->prepa