I haven't looked at Apache::DBI but will the following code for DBI work
for the Apache::DBI?
use DBI;
$dbh = DBI->connect('dbi:mysql:mydb','foo', 'hoo');
$sql = "SELECT * FROM mytab";
$sth = $dbh->prepare($sql);
$sth->execute || die "Could not execute SQL statement: $!\n";
thanks,
-rkl
> I would use Apache::DBI.
>
> Denis
>
>
>
>
> Lust auf mehr - http://maedls.at
>
> "THINK THE WEB WAY."
> ---------------------------------------------------
> NCM - NET COMMUNICATION MANAGEMENT GmbH
> ---[ Denis Banovic - CTO
> mailto:[EMAIL PROTECTED]
> ---[ Mühlstrasse 4a
> AT - 5023 Salzburg
> Tel. 0662 / 644 688
> ---[ Fax: 0662 / 644 688 - 88
> http://www.ncm.at
> ---------------------------------------------------
>
>
> -----Ursprüngliche Nachricht-----
> Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 26. September 2003 08:19
> An: [EMAIL PROTECTED]
> Betreff: Using mysql
>
>
> Is this the correct database package, DBI, to use with mod_perl 2?
>
> Also is there a connection caching?
>
> thanks,
> -rkl
>
