Hello, all --
Some reports coming as CSV from a front-end/database written in/for an
old version of foxpro are broken because of misplaced newlines.
To illustrate:
my @data;
my $oldtotal;
while (@data = $sth->fetchrow_array()){
$oldtotal= $total;
map { $total += $_=~m#[\r\f]+#g } @data;
print
Michael Gray wrote:
source databases available, or I would do some testing and patching
myself. There's no free version of Oracle for Windows is there? I run
Cygwin.
Hmm, I wonder what could be causing this to happen. I have only open
Jeff's pointed out the free version.
This morning, 11
Okay, thanks.
Tim.
p.s. The best way to identify a release candidate is with a post-it note
on your monitor to remind you to install the full release over it :)
On Wed, Nov 12, 2003 at 03:29:36PM -, Martin J. Evans wrote:
>
> On 12-Nov-2003 Tim Bunce wrote:
> > On Wed, Nov 12, 2003 at 01:48
On Wed, Nov 12, 2003 at 04:19:47PM +0100, Jos I. Boumans wrote:
>
> On 12-nov-03, at 14:27, Tim Bunce wrote:
>
> >>if i tell DBI to connect to a postgres db, but i don't have DBD::Pg
> >>installed, it will not give me a warning of any kind, including when
> >>DBI->trace(5) is set, that
> >>i do n
On Wed, 12 Nov 2003, Dan Anderson wrote:
> If I insert a row into mySQL with an indexed auto incrementing column,
> id, how do I get the id of the last inserted row?
>
For right now, you do this:
$insertid = $dbh->{'mysql_insertid'};
However, In the next version of DBD::mysql you will be able
or see the "last_insert_id" section in DBI 1.38* documentation...
*The last_insert_id method was added in DBI 1.38.
-Original Message-
From: Dan Anderson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 10:14 PM
To: Colin Wetherbee
Cc: [EMAIL PROTECTED]
Subject: Re: How do I
> By the way, this isn't the place to ask that question.
Sorry, PHP has a function to get the last row id. Didn't realize I had
to use SQL. That explains why my search found nothing. :-)
Thanks again,
Dan
Dan Anderson said:
> If I insert a row into mySQL with an indexed auto incrementing column,
> id, how do I get the id of the last inserted row?
Use the LAST_INSERT_ID() function.
Or, see these pages:
http://www.mysql.com/doc/en/Getting_unique_ID.html
http://www.mysql.com/doc/en/mysql_insert_id.ht
If I insert a row into mySQL with an indexed auto incrementing column,
id, how do I get the id of the last inserted row?
Thanks in advance,
Dan
Did you have to make it yourself, or could you just use ppm?
>From a DOS prompt try:
ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/DBD-Oracle.ppd
Quoting Diego Gabriele <[EMAIL PROTECTED]>:
> Hi,
>
> I'm not able to create the Makefile for DBD module. The OS is winXP, I'm
> using ActivePerl
On 12-nov-03, at 14:27, Tim Bunce wrote:
if i tell DBI to connect to a postgres db, but i don't have DBD::Pg
installed, it will not give me a warning of any kind, including when
DBI->trace(5) is set, that
i do not have the necessary driver installed. It simply silently
fails.
Works for me:
$ per
Hi,
I'm not able to create the Makefile for DBD module. The OS is winXP, I'm
using ActivePerl 5.8.0 and DBD-Oracle-1.14. DBI are already installed.
Oracle Home is c:\oracle\ora92. Perl is in c:\Perl.
When I type:
perl Makefile.pl
the console output is following:
Using DBI 1.38 installed in
On Thu, 6 Nov 2003, Tim Bunce wrote:
> On Wed, Nov 05, 2003 at 03:15:40PM +0100, Roman Hochleitner wrote:
> >
> > Hi!
> >
> > We are using Oracle 8.1.7 server/client under Redhat 7.1 perl 5.6.0 with
> > DBD::Oracle V1.14 and DBI V1.37.
> >
> > With the attached script I can reproduce a memory
On 12-Nov-2003 Tim Bunce wrote:
> On Wed, Nov 12, 2003 at 01:48:14PM -, Martin J. Evans wrote:
>> Tim,
>>
>> Whilst I'm trying to narrow this issue down to just DBI or DBD::ODBC here is
>> a
>> level 2 trace (against the now installed DBD::ODBC 1.06):
>>
>> [EMAIL PROTECTED] DBD-ODBC-1.06]$
On Wed, Nov 12, 2003 at 01:48:14PM -, Martin J. Evans wrote:
> Tim,
>
> Whilst I'm trying to narrow this issue down to just DBI or DBD::ODBC here is a
> level 2 trace (against the now installed DBD::ODBC 1.06):
>
> [EMAIL PROTECTED] DBD-ODBC-1.06]$ perl -w x.pl
> DBI 1.38-nothread dispat
I have now tried DBI 1.35 and DBD::ODBC 1.06 and they were OK so this would
indicate a problem in DBI 1.35?
[EMAIL PROTECTED] DBD-ODBC-1.06]# perl -e 'use DBD::ODBC; print $DBD::ODBC::VERSION;'
[EMAIL PROTECTED] DBD-ODBC-1.06]# perl -e 'use DBI;print $DBI::VERSION;'
[EMAIL PROTECTED] DBD-ODBC-1.06
I got this to compile. Someone in the Openview forum gave me the FTP site
for a Solaris server:
ftp://ftp.solidtech.com/pub/products/EmbeddedEngine/3.52/solidSDKe352ssx.tar.Z
The Solid Tech web site doesn't list any download information, so its not
easy to find. This tarball did have the li
Tim,
Whilst I'm trying to narrow this issue down to just DBI or DBD::ODBC here is a
level 2 trace (against the now installed DBD::ODBC 1.06):
[EMAIL PROTECTED] DBD-ODBC-1.06]$ perl -w x.pl
DBI 1.38-nothread dispatch trace level set to 2
-> DBI->install_driver(ODBC) for linux perl=5.008 p
There was no libsolodbc.so file in the Library that I downloaded from the
Solid FTP Site.
Joe
[EMAIL PROTECTED]
On Wed, Nov 12, 2003 at 12:34:08PM +0100, Roman Hochleitner wrote:
>
> repeated connects to 2 or more 8.1.7 DBs OR schematas DOES leak
> repeated connects to only ONE (or more) 9.2.0 DB DOES leak
> so the conclusion could be that it looks like the problem is more/only
> related to the DBD::Oracl
On Tue, Nov 11, 2003 at 05:44:40PM +0100, Jos I. Boumans wrote:
> Hi,
>
> I've just noticed something slightly inconvenient:
>
> if i tell DBI to connect to a postgres db, but i don't have DBD::Pg
> installed, it will not give me a warning of any kind, including when
> DBI->trace(5) is set, tha
On Tue, 11 Nov 2003, Terrence Brannon wrote:
> Michael Gray wrote:
>
> >Hs anyone had any luck getting DBIx::Recordset to pass its tests using
> >recent versions of perl, DBI and DBD::Oracle?
> >
> Angus Lees and myself have several patches for Recordset, most are
> archived in the embperl ma
Hi,
I've just noticed something slightly inconvenient:
if i tell DBI to connect to a postgres db, but i don't have DBD::Pg
installed, it will not give me a warning of any kind, including when
DBI->trace(5) is set, that
i do not have the necessary driver installed. It simply silently fails.
On
On Wed, Nov 12, 2003 at 09:28:54AM -, Martin J. Evans wrote:
> Hi,
>
> I have:
>
> [EMAIL PROTECTED] DBD-ODBC-1.06]$ perl -MDBI -e 'DBI->installed_versions'
> Perl: 5.008
> OS : linux
> DBI : 1.38
> DBD::mysql : 2.9002
> DBD::Sponge : 11
Hi,
I have:
[EMAIL PROTECTED] DBD-ODBC-1.06]$ perl -MDBI -e 'DBI->installed_versions'
Perl: 5.008
OS : linux
DBI : 1.38
DBD::mysql : 2.9002
DBD::Sponge : 11.09
DBD::Proxy : 0.2004
DBD::ODBC : 1.05
DBD::Multiplex : 0.9
DBD
25 matches
Mail list logo