I have created a database that has a table for the active data,
and a table that basically captures the changes to that table. The
second table has all of the same fields as the first with one extra and
that being to capture a date of the change. I know that I can write a
piece of code to
The latests Dev-2_9 branch in CVS fixes the Mac OS X issue as well, if
you want to try out this version (prepared statements and embedded code
included)
regards,
Patrick
On Sep 5, 2004, at 12:08 PM, Joris Verboomen wrote:
That worked. I first tried going back to 4.1.3 but that didn't change
an
Darren,
Eventually, we could possibly have a method to detect version
the best way I know of to get mysql version is in an SQL call via DBD:
"show global variables like 'version'" in the database, or
$database_version = $dbh->get_info(18) (more info on this in 'perldoc
DBI')
The version that supp
Tim Bunce wrote:
Can anyone else using cygwin reproduce the problem? Or not?
I can't. Output below.
--
Jeff
Perl: 5.008005(cygwin-thread-multi-64int)
OS : cygwin (1.5.10(0.11642))
DBI : 1.43
DBD::Sponge : 11.10
DBD::File : 0.31
Guiseppe,
I have today committed the missing Makefile.PL.embedded today in CVS,
Thank you for your email!
regards,
Patrick
On Sep 6, 2004, at 4:15 AM, Giuseppe Maxia wrote:
Hi, Patrick,
thanks for making these changes, which were really needed.
I tested both the prepared statements and the support
On Wed, Sep 08, 2004 at 05:42:50PM -0400, Paul Galbraith wrote:
> Tim Bunce wrote:
>
> >Probably a problem with the test rather than the DBI. Can you dig
> >into it a little more? It's probably something to do with trace_to_file()
> >in t/10examp.t
>
> I'm just learning perl, so I'm out of my dep
Tim Bunce wrote:
Probably a problem with the test rather than the DBI. Can you dig
into it a little more? It's probably something to do with trace_to_file()
in t/10examp.t
I'm just learning perl, so I'm out of my depth here...
It seems to be related to the -T perl option specified in t/10examp.t.
Just a curiosity at this point... Is there a way to do this
using the quick quotes method?
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Wieland Pusch [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 0
On Sep 8, 2004, at 3:04 AM, Bart Lateur wrote:
Is there anything foreseen to disconnect a DBI connection, in a
mod_perl
(2) setup with Apache::DBI, in case nothing has been requested in
several minutes time? Do the connections stay open forever, or does the
database timeout all by itself? (I suspe
The oddly named "MySQL ComCon Europe" conference will take place
in Frankfurt in November: http://mysqlcomconeurope.com/
I'll be presenting my Advanced DBI tutorial on the pre-conference
workshop day. I think it's the first time I've presented it in Europe.
I hope to see some of you there.
Ti
Just goes to prove that one should always look on CPAN before writing
almost anything ..
NIPP, SCOTT V (SBCSI) wrote:
The suggestion of using Text::CSV_XS was the winner. This is a
very simple module to use. Thanks for the feedback though.
On Wed, 2004-09-08 at 12:04, Bart Lateur wrote:
> Is there anything foreseen to disconnect a DBI connection, in a mod_perl
> (2) setup with Apache::DBI, in case nothing has been requested in
> several minutes time? Do the connections stay open forever, or does the
> database timeout all by itself?
On 2004-09-07 08:40:33 -0600, Reidy, Ron wrote:
> I've never seen before insert trigger being slower than doing the same
> thing in the client code. I guess it would depend on what you are
> doing in the trigger and how many sequences are cached (but the amount
> cached would also have the same ef
Is there anything foreseen to disconnect a DBI connection, in a mod_perl
(2) setup with Apache::DBI, in case nothing has been requested in
several minutes time? Do the connections stay open forever, or does the
database timeout all by itself? (I suspect it does, anyway)
The only thing I see in Apa
Hallo BRIAN,
I like your solution with foreach and bind_param. Just add the prepare
like this:
$sth = $dbh->prepare("INSERT INTO AllMid_Data VALUES(?".(",?" x 21).")")
or print "Error with INSERT _prepare_ $DBI::errstr\n";
Tuesday, September 7, 2004, 9:31:15 PM, you wrote:
CBDB> This should work
15 matches
Mail list logo
