Insert : how to get the primary key

Hi, I'm currently writing a Perl script which insert lots of data into a database. When I insert a row in a table, I need to get the PRIMARY KEY which has been affected to this table, because I will use it to reference this record in an other table. Currently, I issue a INSERT, and then a SELECT

Can't locate loadable object for module DBI in @INC

Hi! I've read a part of a mailing list that says:"I'm sorry to keep cluttering up the list with my ignorance, but I can't seem to get this working. From a CPAN shell, I've tried "install DBI", "recompile DBI" and pretty much anything else I could think of. Whenever I run a script using DBI

bugs in DBD::ODBC 0.43

Thanks, Jeff. I've installed DBD::ODBC version 0.43, and it seems to have fixed the problem of memory access violation on exit. However: (1) I was hoping that the new version would also fix another possibly related bug that I noticed yesterday in version 0.28, namely, that repeated executions

RE: Oracle 11i

Oracle 11i is the Oracle applications release numbering scheme - do you mean Oracle Database 8i/9i? The Oracle::DBD module can access these. Rick Michaud -Original Message- From: PC210018 [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 4:42 PM To: dbi-users Cc: PC210018 Subjec

Oracle 11i

Is there a module for accessing Oracle 11i stored procedures? All of my experience has been with access SQL7. Any info would be appreciated. Thanks Phil Carner NCR [EMAIL PROTECTED]

(Fwd) DBI-1.30 x DBD-ODBC 0.43 - Perl crashes !

- Forwarded message from Jan Matejka <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] From: "Jan Matejka" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: DBI-1.30 x DBD-ODBC 0.43 - Perl crashes ! Date: Thu, 18 Jul 2002 18:28:58 +0200 Sorry, Typo in Subject

RE: DBI-1.30 x DBD-ODBC 0.43 - Perl crashes !

Great!!! I hope that's all it was ;-) Be careful with Oracle's ODBC drivers, though, they sometimes change a LOT between versions. Jeff > > > I was using ActiveState Perl 5.6.1 build 629 and Oracle ODBC driver > 8.01.07.00. > > After upgrade to Oracle ODBC driver 8.01.75.00 (the same version yo

DBI-1.29 problem

Hi, I am install DBI-1.29 to connetect mysql database and perl5.6.1 on Tru64. I have installed : Data-Dumper-2.101.tar.gz DBI-1.29.tar.gz Data-ShowTable-3.3.tar.gz Msql-Mysql-modules-1.2219.tar.gz When I installed DBI-1.29.tar.gz, 'perl5.6.1 Makefile.PL', it gives me message: *** Not

Re: DBI-1.29 problem on Tru64

-- Original Message -- From: "Qingjuan Gu" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> Date: Thu, 18 Jul 2002 13:49:55 -0400 >Hi, > >I am install DBI-1.29 to connetect mysql database and perl5.6.1 on Tru64. > >I have installed : >Data-Dumper-2.101.

(Fwd) DBI-1.20 x DBD-ODBC 0.43 - Perl crashes !

- Forwarded message from Jan Matejka <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] From: "Jan Matejka" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: DBI-1.20 x DBD-ODBC 0.43 - Perl crashes ! Date: Thu, 18 Jul 2002 18:13:40 +0200 Using Windows2000, Acti

datasource null?

I have DBI 1.21 installed - when I run this script #!/usr/bin/perl -w use strict; use DBI; # List directories in @INC. foreach my $dir (@INC) { print "$dir\n"; } print "DBI Version $DBI::VERSION\n"; # ### Probe DBI for the installed drivers my @drivers = DBI->available_drivers(); ### Iterat

re: please unsubscrie me from this group!

unsubscribe me from htis group...

RE: How to check a DBI installation?

Here is what I use to check things out on my Perl installation. Mark use strict; use DBI; # List directories in @INC. foreach my $dir (@INC) { print "$dir\n"; } print "DBI Version $DBI::VERSION\n"; # ### Probe DBI for the installed drivers my @drivers = DBI->available_drivers(); ### Iterate t

ANNOUNCE: DBI 1.30

file: $CPAN/authors/id/T/TI/TIMB/DBI-1.30.tar.gz size: 257016 bytes md5: 30e6b539fb36da93c862c7c7df0f3bf8 =head2 Changes in DBI 1.30,18th July 2002 Fixed problems with selectrow_array, selectrow_arrayref, and selectall_arrayref introduced in DBI 1.29. Fixed FETCHing a handle

CPAN Upload: T/TI/TIMB/DBI-1.30.tar.gz

The uploaded file DBI-1.30.tar.gz has entered CPAN as file: $CPAN/authors/id/T/TI/TIMB/DBI-1.30.tar.gz size: 257016 bytes md5: 30e6b539fb36da93c862c7c7df0f3bf8 No action is required on your part Request entered by: TIMB (Tim Bunce) Request entered on: Thu, 18 Jul 2002 14:26:19 GMT R

ANNOUNCE: DBD::ODBC 0.43

Changes: Fix for FoxPro (and potentially other) Drivers! Add support for DBI column_info Fix for binding undef value which comes from dereferencing hash Fix to make all bound columns word (int) aligned in the buffer. See the POD documentation in ODBC.pm for more details. Also, those interes

How to check a DBI installation?

Hi there! For test purposes I tried to execute a perl prog at a customers solarix box, which dumps an informix table to STDOUT. It failed, because perl didn't find the DBI.pm . I found some DBI/DBD::Informix related files in /usr/informix/tmp/perl/... .. Because I'm not very experienced

Re: mysql<->combo box

It seems not to be a DBI problem. It is an HTML problem. I think. my $i=0; printf "\n"; while ( @row = $sth->fetchrow ){ printf "$row[i]\n"; i++; } printf "\n"; Please don't talk out of topic. hope this help man. - Original Message - From: "Vanna Chhu