***  From dbi-users - To unsubscribe, see the end of this message.  ***
   *** DBI Home Page - http://www.symbolstone.org/technology/perl/DBI/ ***

I have several questions:

What is the most efficient way/best way of doing this:

# this is a multiple row insertion

$sth = $dbh-> prepare( qw(
	INSERT INTO TABLE
        (First, Last, Address, Phone)
        VALUES(?,?,?,?)
)

# put this is a loop
# @values will have different
@values = ($fname,$lname, $address, $phone);
$sth-> execute(@values);
# end loop

Am I doing this correctly?
What is the value of $sth returned by $dbh-> prepare() method?



--

Antonio W. Lagnada
Silicon Optimization
http://wwwmm.lsil.com/~alagnada (internal)
(612) 921 8533

-- Binary/unsupported file stripped by Listar --
-- Type: text/x-vcard
-- File: alagnada.vcf
-- Desc: Card for Antonio W. Lagnada



------------------------------------------------------------------------------
To unsubscribe from this list, please visit: http://www.isc.org/dbi-lists.html
If you are without web access, or if you are having trouble with the web page,
please send mail to dbi-users-request@[...].org with the subject line of
'unsubscribe'.
------------------------------------------------------------------------------