What I do is:
my $statement = q{select 1 from x where xyz = ?};
Prepare:
my $exist_sth = $dbh->prepare( $statement );
Then call selectrow_array with a scalar:
$does_exists = $dbh->selectrow_array($statement, undef, $key_to_check );
Tom
On Fri, Jul 06, 2001 at 05:08:56PM -0400, James Kufrovich wrote:
> Hi.
>
> I'd like to check for the existence of data in a row of a database
> (MySQL), if given the value of a primary key. ("Is there already a row in
> the database that has this value as a key?") I don't care what data is in
> the row, or if more than one row (!!) is found. I'd hope that whatever
> method I use will stop searching the database after it finds the first
> match.
>
> What would be the best way to go about this? Is there a special
> method that can do this, or would I have to use selectrow_array (or
> fetchrow_array or one of those) and then see if it finds anything? I
> suppose I can call 'finish' as soon as a match is found, if the method (or
> whatever) doesn't stop by itself. I'd appreciate any tips. Thanks.
>
> Jamie Kufrovich
>
> Egg, eggie (at) sunlink (dot) net
> FMSp3am/MSp3am A- C+ D H+ M+ P+++ R+ T W Z+
> Sp#/p++ RL->CT a+ cl++ d? e++ f h* i+ j p+ sm+
--
Thomas A. Lowery
See DBI/FAQ http://tlowery.hypermart.net
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
