Jeff,
Not sure I follow you, using a unique index??
On Mon, 27 Aug 2001 14:35:42 -0500, "Jeff Eckermann" <[EMAIL PROTECTED]>
wrote:
>>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 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();
>>
>>$sqlquery = qq|SELECT tagid FROM tags WHERE tagnumber = ?|;
>>$sth = $dbh->prepare($sqlquery) or dbError("Error: $DBI::errstr");
>>
>>for my $tags (@tagnums) {
>>$sth->execute($tags);
>> my($id) = $sth->fetchrow_array();
>>$id and error("The Tag Number entered: $tagid is already in our
>>database","Duplicate Tag Number");
>> }
>>
>>}
>>
>>the @tagnums array stores the multiple tagid numbers and I need to loop thru
>>each one to make sure it's not already in the tags table. Is this the best
>>may
>>to approach this??
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
