Hi,
I'm writing a program that uses DBI/Mysql and does a
*lot* of selects and inserts/updates. (One short run
did 2809 and 5714 respectively).
I've used Devel::DProf with it - in an attempt to get
an idea of any performance problems - and am getting
some interesting data on test runs. One thing t
medical Informatics
> Vanderbilt University Medical Center
>
>
>
> -Original Message-
> From: Henry McGuinness
> [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 11, 2004 12:15 PM
> To: [EMAIL PROTECTED]
> Subject: DBD::mysql
>
>
> Hi folks,
>
ite. (PPM3 appears to have older versions of
the DBD on it)
regards
Henry
>
> -Original Message-
> From: Henry McGuinness
> [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 11, 2004 12:15 PM
> To: [EMAIL PROTECTED]
> Subject: DBD::mysql
>
>
> Hi f
Hi folks,
This seems to be a DBI issue. I've just reinstalled
most things so I'm running:
Activestate Perl 5.8.4
MySQL 4.1.5 ("gamma" but it should be ok surely?)
DBI 1.43
DBD::MySQL 2.9004
running on Windows XP professional.
Tried to do a simple select (works fine from MYSQL in
command prompt
Hi,
--- Jonathan Leffler <[EMAIL PROTECTED]> wrote:
>
> Not being aware that there was an ActiveState
> version of Perl for any
> platform other than MS Win32, there's no way I can
> answer that.
Well, there are ActivePerls for Linux and Solaris,
though I've never made use of them. Also:
htt
Hi,
Does anybody have experience using DBI with
Activestate's Perl for HP-UX 11? Does the PPM work in
the same way as it does for the Windows version.
Specifically, a colleague of mine wants to use
DBD::Informix, and had given up on the re-compiling
perl + module with gcc.
PPM would make his li
See
http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Mail_C3/Gossamer_Mail_Discussion_F11/DBI_Confusion_P151183/
for one discussion of a similar error message.
(Otherwise have you loaded Apache::DBI before DBI in
your config/startup files? If not you may have
problems?)
HTH
Henry
> However, when I do a "random" query I get some blank
> pages. I traced this to
> the DBI Log using the "DBH->Trace(2, /tmp/DBI.log)".
> I found that sometimes
> the "execute()" returns "0E0". Does anybody knows
> why??
If I remember rightly 0E0, in DBI, means "Success" ie
:
your query work
I'm not an expert at this by any means. But 2 things
come to mind:
1) Apache::DBI doesn't like being loaded by Apache
_after_ DBI is loaded. So if you have perlrequired DBI
earlier in your httpd.conf file or "use DBI;" appears
in a perl module loaded before Apache::DBI, it could
cause problems.
I assume you're doing this as a CGI to return records
from a dastabase.
I've just done this myself - basically redoing the
select statement for each new page, with a LIMIT
statement in MySQL saying eg: LIMIT 21,10 (meaning
start at 21 and select the next 10)
Of course, doing it this way you have
Hi Ilya,
err...I think I'm right in saying you don't actually
need Apache::DBI for using DBI with mod_perl. It just
makes a persistent database connection, so you don't
re-connect and disconnect from your database every
time the program runs.
regards
Henry
--- "Sterin, Ilya" <[EMAIL PROTECTED
Thanks Paul
Yes I can find it with 2.1.4 but I suspect we were
using the latest version (PPM 3/2 or 3/3).
Can't access the machine we were using, will look in
the morning. How do I get an older PPM, does anyone
know?
I will contact Activestate...
Thanks again for your help
Henry
--- [EMA
Hi Guys,
Does anyone know why DBD::MYSQL isn't there any more
when you look for it using PPM with the latest
ActiveState Perl? I'm sure it was there till not too
long ago.
It doesn't seem to be in the repository when you do
search DBD::MySQL or install DBD::MySQL.
(and I've tried every version
13 matches
Mail list logo
