Re: DBI-Performace-Problem

2002-12-02 Thread Tim Bunce
On Sun, Dec 01, 2002 at 05:41:42PM -0800, Jared Still wrote: It can be. Even a soft parse requires a latch in the database SGA, and since all latches are serialized, it could be a problem in a busy system. I am far from the expert in parsing and latching, but i do plan to run some tests

How do I build a search engine for a MySQL database?

2002-12-02 Thread Oriol Portell - UV
Hi, I'm running MySQL and Perl 5.6 on a Win32 machine. I'm a very unexperienced Perl programmer, but I need to build a serach engine for a MySQL database which parses the values entered in a text field (in simple and advanced query sintaxes similar to those used in Yahoo or Altavista) and

Problem installing perl+dbi+dbd-oracle on HP-UX

2002-12-02 Thread Carlos Barroso
Hy. I'm trying to compile and install perl 5.6.1 on HP-UX. When I run make it gives me the following error: Bad character (octal 76), line 679Make: . Stop. I thought it was because of the make binary. So I installed the depot gmake, and now it gives me the following error:

Re: Problem installing perl+dbi+dbd-oracle on HP-UX

2002-12-02 Thread Tim Bunce
Possibly due to errors in Oracle's own Makefile' (which DBD::Oracle copies chunks of). What do those lines in the generated Makefile say (and pay special attention to whether lines start with spaces or tabs). Tim. On Mon, Dec 02, 2002 at 12:35:52PM -, Carlos Barroso wrote: Hy. I'm trying

Re: DBI 1.32 Warning

2002-12-02 Thread Tim Bunce
On Mon, Dec 02, 2002 at 12:30:04PM +0100, H.Merijn Brand wrote: On Mon 02 Dec 2002 12:28, H.Merijn Brand [EMAIL PROTECTED] wrote: On Mon 02 Dec 2002 02:32, David Wheeler [EMAIL PROTECTED] wrote: Tim, Got just one warning with the new 1.32 release on Mac OS X 10.2.2: HP-UX 10.20

RE: Problem installing perl+dbi+dbd-oracle on HP-UX

2002-12-02 Thread Carlos Barroso
In the makefile it has lines like the following: av$(OBJ_EXT): built-in I don't know what are they for!? How can I correct this problem? -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 2 de Dezembro de 2002 13:23 To: Carlos Barroso Cc:

Re: Problem installing perl+dbi+dbd-oracle on HP-UX

2002-12-02 Thread Tim Bunce
On Mon, Dec 02, 2002 at 01:56:42PM -, Carlos Barroso wrote: In the makefile it has lines like the following: av$(OBJ_EXT): built-in I don't know what are they for!? How can I correct this problem? Try just deleting those lines. Tim. p.s. The README says don't email me

RE: Problem installing perl+dbi+dbd-oracle on HP-UX

2002-12-02 Thread Carlos Barroso
I've deleted the lines as you said, and the following error appeared: make: *** No rule to make target `command', needed by `miniperlmain.o'. Stop. I looked at the makefile and it has lines like the following: av$(OBJ_EXT): command line So I deleted them too. After deleting

Re: Problem installing perl+dbi+dbd-oracle on HP-UX

2002-12-02 Thread Tim Bunce
Something looks fairly broken. Send me (directly) a copy of your generated Makefile. Tim On Mon, Dec 02, 2002 at 03:27:08PM -, Carlos Barroso wrote: I've deleted the lines as you said, and the following error appeared: make: *** No rule to make target `command', needed by

RE: Problem installing perl+dbi+dbd-oracle on HP-UX

2002-12-02 Thread Jeff Urlwin
I've deleted the lines as you said, and the following error appeared: make: *** No rule to make target `command', needed by `miniperlmain.o'. Stop. I do not believe the dbi-users mailing list is the best place to get help on building perl itself for HP-UX. There are other places

Problem installing DBI on HPux 11.00

2002-12-02 Thread Taylor, Malcolm
Title: Problem installing DBI on HPux 11.00 I am having trouble installing DBI-1.30 on my HPUX Unix system. I attach a file with the details of the 'make' failure. I did manage to install it on my test machine (which should be identical, but obviously isn't quite !!) I would appreciate any

DBI::Proxy + Oracle 8i worked fine. Upgraded to 9i = broken?

2002-12-02 Thread daedalus
Hi all, I've been using DBI::Proxy with DES encryption to connect a bastion host web server through a firewall to some internal Oracle DBs. All has been well for a couple of years with a mix of Oracle 8.0.5 and 8.1.5 on their side and DBI 1.14 and DBD:Oracle 1.06 on mine. Over the holiday

Re: How to insert a question mark?

2002-12-02 Thread David Wheeler
On Sunday, December 1, 2002, at 10:16 PM, Anton Pitts wrote: I'm running postgresql 7.3, perl 5.6.0, DBI 1.30 on mac os x 10.2 and am having trouble with inserting values ending in a question mark. What version of DBD::Pg are you using? If it's older than 1.20, please give 1.20 a try.

RE: How to insert a question mark?

2002-12-02 Thread Anton Pitts
Thanks for the suggestions. That's definitely a bug. For now, try to escape it with \? Escaping with \? inserts \NULL into the db. Same for ? (inserts NULL) which a friend suggested trying. , or if that doesn't work, then try using a placeholder ? and then bind 'val?' to it. I'm not sure

RE: DBD-Informix-1.04.PC1 build errors on Solaris 8

2002-12-02 Thread Cosby, Christopher
The -KPIC wasn't the problem. Updated my DBI to DBI-1.32 and it now works. Some parse error on line 102 with the - operator. Christopher S. Cosby SciCare Software Services 770.236.1128 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November

Re: Bug Report - DBD::Informix 1.04.PC1 (incorrect pre-requisite version of DBI)

2002-12-02 Thread Jonathan Leffler
Dear Mike, I can reproduce your problem with DBI 1.20 and DBD::Informix 1.04.PC1 on Solaris 8 with Perl 5.6.1. I will investigate further, but my immediate reaction is that maybe the problem is that I have included a change that requires a newer version of DBI than 1.20, but didn't set the

Re: How to insert a question mark?

2002-12-02 Thread Anton Pitts
I'm actually using DBD::PgPP at version 0.40; I can't say I'm sure why I picked that one over DBD::Pg. Although I just tried installing DBD:Pg v 1.20, and it failed at make test with : t/01connect.Can't locate Test/More.pm in @INC (@INC contains: blib/arch blib/lib

Getting table names

2002-12-02 Thread Brad Smith
Is there some place online that lists the acceptible commands to retrieve information about a database? For instance, I would like to be able to ask an Access database which tables are available, then, within each table, what the names of the columns are. I guess this is again one of those

Re: How to insert a question mark?

2002-12-02 Thread David Wheeler
On Monday, December 2, 2002, at 01:43 PM, Anton Pitts wrote: I'm actually using DBD::PgPP at version 0.40; I can't say I'm sure why I picked that one over DBD::Pg. Although I just tried installing DBD:Pg v 1.20, and it failed at make test with : t/01connect.Can't locate Test/More.pm

Re: Getting table names

2002-12-02 Thread Thomas A. Lowery
See perldoc DBI view methods tables, table_info, column_info (meta data). On Mon, Dec 02, 2002 at 06:29:20PM -0500, Brad Smith wrote: Is there some place online that lists the acceptible commands to retrieve information about a database? For instance, I would like to be able to ask an

Re: How to insert a question mark?-solved

2002-12-02 Thread Anton Pitts
Right you are. No problems with DBD::Pg. Thanks, anton. On Monday, December 2, 2002, at 01:43 PM, Anton Pitts wrote: I'm actually using DBD::PgPP at version 0.40; I can't say I'm sure why I picked that one over DBD::Pg. Although I just tried installing DBD:Pg v 1.20, and it failed at

Problems retrieving table names

2002-12-02 Thread Brad Smith
Reading over the mailing list archives, I found some information about getting table names. Unfortunately, the information that I retrieve includes a lot of stuff, none of which are the names of the tables. Here is the code: my $dbh = DBI-connect('dbi:ODBC:database_name) || die DBI::errstr;

table names worked... but...

2002-12-02 Thread Brad Smith
Ok, I managed to get the table names of an Access database. One question, though: what is all the information in the first few variables of a scalar that read something similar to MSysAccess...? Do I just need to offset by 5~6 each time I want to display the table names? Thanks in advance.

Re: table names worked... but...

2002-12-02 Thread Thomas A. Lowery
#!/usr/bin/perl -w use DBI; print $DBI::VERSION\n; my $dbh = DBI-connect() or die unable to connect: , $DBI::errstr; my @tables = $dbh-tables() or die Tables failed: , $DBI::errstr; foreach my $table (@tables) { print table: $table\n; } $dbh-disconnect; exit; Results:

Re: Problems retrieving table names

2002-12-02 Thread Thomas A. Lowery
On Mon, Dec 02, 2002 at 08:39:17PM -0500, Brad Smith wrote: foreach $i (@tables) { print $tables[$i]br; } Hmmm ... surprised you get anything here. @tables is an array. @tables = qw/a b c/; foreach $i (@tables) { first time in the loop $i == 'a'; So $tables[$i] ==

RE: table names worked... but...

2002-12-02 Thread Jeff Urlwin
You could, in the loop, do something like: next if ($tablename =~ /^MSys/); Regards, Jeff -Original Message- From: Brad Smith [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 8:54 PM To: [EMAIL PROTECTED] Subject: table names worked... but... Ok, I managed

Fw: Strange web log errors

2002-12-02 Thread Dean Arnold
Someone reported the following error occuring w/ DBI 1.32 and DBD::Chart: [Tue Dec 3 00:55:57 2002] nul: DBD::Sponge::db do failed: No rows attribute supplied to prepare at c:/Perl/site/lib/Deakin/Base.pm line 2822. [Tue Dec 3 00:55:57 2002] nul: DBD::Sponge::db prepare failed: No rows

Connecting MS Access Database with DBI

2002-12-02 Thread jad
I have Active State Perl 5.6. I've used PPM install DBI. I'm using this code: # # Perl script that talks with the Northwinds database using an # ODBC DSN of Northwind. # use DBI; use Data::Dumper; my $dbh = DBI-connect( dbi:ODBC:Northwind, Admin, , {RaiseError = 1, PrintError = 1,

Re: Connecting MS Access Database with DBI

2002-12-02 Thread Thomas A. Lowery
On Mon, Dec 02, 2002 at 09:37:58PM -0600, jad wrote: I have Active State Perl 5.6. I've used PPM install DBI. I'm using this code: Did you install DBD-ODBC? # # Perl script that talks with the Northwinds database using an # ODBC DSN of Northwind. # use DBI; use Data::Dumper; my

PASS DBI-1.32 MSWin32-x86-multi-thread 4.0

2002-12-02 Thread randy
This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/. Please cc any replies to [EMAIL PROTECTED] to keep other test volunteers informed and to prevent duplicate effort. -- all tests passed after running