DBD::mysql problem

When I try to run "make test" on DBD::mysql, I get a
ton of "unresolved symbol" errors looking for mysql
functions. For example:

/usr/lib/dld.sl: Unresolved symbol: mysql_store_result
(code) from blib/arch/auto/DBD/mysql/mysql.sl
/usr/lib/dld.sl: Unresolved symbol: mysql_stat (code)
from blib/arch/auto/DBD/mysql/mysql.sl
/usr/lib/dld.sl: Unresolved symbol: mysql_field_seek
(code) from blib/arch/auto/DBD/mysql/mysql.sl

I installed MySQL (version 4) from the HP-UX 11.0
binaries into /opt/mysql/mysql. When I run the "perl
Makefile.PL" command, I'm passing in
"--cflags=-I/opt/mysql/mysql/include
--libs=-L/opt/mysql/mysql/lib" (along with MySQL
database parameters).

Anyone have any idea what's missing?

Thanks




__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

DBD::mysql quoting hooks

Does anyone know of a way to alter the way DBD::mysql quotes bound
parameters? E.g.

$sth = $dbh->prepare('select foo from bar where id = ?');
$sth->execute(3);

DBD::mysql will quote 3 before using it to replace the ? placeholder.
I'd like a way to intercept this quoting step and decide for myself
whether to quote or not.

The problem I'm trying to solve is that I just upgraded some code that
used and older version of DBD::mysql that selectively quoted certain
values. Now the latest version quotes everything which breaks some code
(particular code that selects ENUM fields by their index rather than
their label).

I don't need a permanent fix, just something to make things work while I
figure out where this bad code is and update it. I'd like a hook rather
than just sticking with the old version DBD::mysql because I'd like the
hook to also shout out when it sees a bad usage.

Thanks!

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

DBD::mysql quoting hooks

Does anyone know of a way to alter the way DBD::mysql quotes bound
parameters? E.g.

$sth = $dbh->prepare('select foo from bar where id = ?');
$sth->execute(3);

DBD::mysql will quote 3 before using it to replace the ? placeholder.
I'd like a way to intercept this quoting step and decide for myself
whether to quote or not.

The problem I'm trying to solve is that I just upgraded some code that
used and older version of DBD::mysql that selectively quoted certain
values. Now the latest version quotes everything which breaks some code
(particular code that selects ENUM fields by their index rather than
their label).

I don't need a permanent fix, just something to make things work while I
figure out where this bad code is and update it. I'd like a hook rather
than just sticking with the old version DBD::mysql because I'd like the
hook to also shout out when it sees a bad usage.

Thanks!

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: DBD::mysql quoting hooks

On Tue, 25 May 2004, Garth Webb wrote:

> Date: Tue, 25 May 2004 11:17:09 -0700
> From: Garth Webb
> To: perl@lists.mysql.com
> Subject: DBD::mysql quoting hooks
>
> Does anyone know of a way to alter the way DBD::mysql quotes bound
> parameters? E.g.
>
> $sth = $dbh->prepare('select foo from bar where id = ?');
> $sth->execute(3);
>
> DBD::mysql will quote 3 before using it to replace the ? placeholder.
> I'd like a way to intercept this quoting step and decide for myself
> whether to quote or not.
>


$sth->bind_param(1, 3, SQL_INTEGER);
$sth->execute();

For more info look at the docs for bind_param.

Rudy



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: DBD::mysql quoting hooks

On Tue, 25 May 2004, Garth Webb wrote:

> Date: Tue, 25 May 2004 11:17:09 -0700
> From: Garth Webb
> To: perl@lists.mysql.com
> Subject: DBD::mysql quoting hooks
>
> Does anyone know of a way to alter the way DBD::mysql quotes bound
> parameters? E.g.
>
> $sth = $dbh->prepare('select foo from bar where id = ?');
> $sth->execute(3);
>
> DBD::mysql will quote 3 before using it to replace the ? placeholder.
> I'd like a way to intercept this quoting step and decide for myself
> whether to quote or not.
>


$sth->bind_param(1, 3, SQL_INTEGER);
$sth->execute();

For more info look at the docs for bind_param.

Rudy



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org