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
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
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:
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
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
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:
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
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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;
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.
#!/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:
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] ==
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
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
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,
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
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
30 matches
Mail list logo