-
From: <[EMAIL PROTECTED]>
To: "Jeff Eckermann" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 2:41 PM
Subject: Re: Looping multiple selects
Jeff,
Not sure I follow you, using a unique index??
On Mon, 27 Aug 2001 14:35:42 -0500, "J
de.
>>- Original Message -
>>From: <[EMAIL PROTECTED]>
>>To: <[EMAIL PROTECTED]>
>>Sent: Saturday, August 25, 2001 9:55 PM
>>Subject: Looping multiple selects
>>
>>
>>Hi All,
>>
>>I have a sub routine that needs to check to make s
How about a unique index on that field in the database? ISTM that this is
what you are trying to emulate with your code.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 25, 2001 9:55 PM
Subject: Looping multiple selects
Hi Al
> my($id) = $sth->fetchrow_array();
Minor speedup by binding the return, especially since it is a
single value. Might also be simpler to use select* sub's in
new DBI that will handle it in a single call.
Hi All,
I have a sub routine that needs to check to make sure that a group of tag id
numbers are not already in our database. But I'm not sure this is going to work
the way I think it will or there maybe a better way to do it. Here's the snip:
sub check_tag_num {
my @tagnums = shift();
$sqlquer
