Howdy folks. This is my first post to this list (I'm a brand new
subscriber) though I've been using DBI for a while now.
I have a question regarding DBIx::Recordset. A module I downloaded just
today.
Firstly, this module will be of great use in something I'm building but
it would be of ev
Hello,
I have a minor bug fix and enhancement patch for DBD::Pg 1.01. It
concerns the "table_info" method. First, the bug fix: When selecting
information about views, the syntax
"c.relkind = 'r'" is used when it should be: "c.relkind = 'v'"
It's documented here that 'r' is used for "regular" ta
Can't get the sucker to build ... no trouble building lots 'o other
things, but not this. Details:
root@vader[188]# uname -a
SunOS vader 5.8 Generic_108528-07 sun4u sparc SUNW,UltraAX-i2
root@vader[189]# perl Makefile.PL
Remember to actually *read* the README file!
Use 'make' to build
On Thu, 25 Oct 2001 14:10:10 -0400
Jeff Boes <[EMAIL PROTECTED]> wrote:
> The following code fails with an 'Unterminated quote string' error.
>
> #!/usr/bin/perl -w
> use strict;
> use DBI;
> use Carp;
>
> my $dbh = DBI->connect('dbi:Pg:dbname=nexcerpt', '', '', {AutoCommit=>0,
>
The output told me to report this to the list, so here I am...
Oracle 8.1.7.2
perl -V:
Characteristics of this binary (from libperl):
Built under solaris
Compiled at Apr 3 1999 00:26:08
@INC:
/usr/local/lib/perl5/5.00503/sun4-solaris
/usr/local/lib/perl5/5.00503
/usr/local/lib
You can use the CPAN.pm module to install or update any module. As far as
fixing this, just install DBI with the correct perl version and then you'll
be able to use without modifying @INC. Otherwise you will have to modify
@INC in all scripts, which I wouldn't recommend because of some older per
Thanks! I think you must have found the answer, because that's certainly
true. I was using perl 5.6.0 until yesterday - I'm sorry, I should have
mentioned that before. DBI was installed while I was still running
5.6.0, it was actually in the process of trying to fix something else
that I ended
Yes, they all exist with the right permissions. I just tried changing
the ownership to that of the user trying to run the script, but that
didn't work, so I changed it right back!
Wilson, Doug wrote:
>> From: Jake Hoban [mailto:[EMAIL PROTECTED]]
>>
>> Can't locate loadable object for module
No, it's not that. The shebang says #!/usr/bin/perl, and "which perl"
returns the same path - although I've actually got it installed at
/usr/local/bin/perl as well (that was one of the options during the
installation).
[EMAIL PROTECTED] wrote:
> In your script's shebang line, are you perhap
This is because the script you are using is run with a different perl
version that was used to install DBI. Also you might of installed DBI in a
non standard directory, which will not append it to @INC. See perldoc
perlvar for more info on @INC.
Ilya
-Original Message-
From: Jake Hoban
> From: Jake Hoban [mailto:[EMAIL PROTECTED]]
>
> Can't locate loadable object for module DBI in @INC (@INC contains:
> /usr/local/lib/perl5/5.6.1/i686-linux /usr/local/lib/perl5/5.6.1
> /usr/local/lib/perl5/site_perl/5.6.1/i686-linux
> /usr/local/lib/perl5/site_perl/5.6.1
> /usr/local/lib/p
In your script's shebang line, are you perhaps using:
#!/usr/local/bin/perl
?
Try a "which perl" from the command line and see if it varies from your
shebang line. Perhaps /usr/bin/perl?
Jake Hoban wrote:
> Hi
>
> I'm new to this list, but I've looked through the archives before
> posting and
Hi
I'm new to this list, but I've looked through the archives before
posting and I can't find the exact answer to this, only a few ideas.
I'm running Red Hat Linux 7.1, using Perl 5.6.1 and trying to get DBI
1.20 to work. I've tried installing two different ways - by downloading
the tar.gz, r
I am doing CGI on the webserver and want "Session Management". I have looked
into Apache::Session and am trying to see if I can get that working but there
is lots of documentation to get it working with MySQL but I'm not sure if it
works with DB2. Anyone have any experiance with this? Thanks.
You are right, though not sure where, I remember seeing that they are
available in BDB tables, though now I know it's false after looking at mysql
docs.
Thanks.
Ilya
-Original Message-
From: [EMAIL PROTECTED]
To: Sterin, Ilya
Cc: 'Vuillemot, Ward W '; '[EMAIL PROTECTED] '
Sent: 10/30/01
I run a database with a lot of tables used only to reference two other tables.
Sometimes they use a couple other fields also.
After some testing, I preferred to use multiple selects (one per relationship
table) since the result of the query was getting way to huge when having 4-5
relationship tab
I believe it only supports FK's with InnoDB table handlers, not BDB, with the
recent release of 4.0 alpha... which is extermely "Buggy"... :)
>>On Tue, 30 Oct 2001 08:48:42 -0700, "Sterin, Ilya" <[EMAIL PROTECTED]> wrote:
>>This is not DBI related, so please post to appropriate list.
>>
>>My
Ilya,
Thank you for your help! This is undoubtedly old hat to you guys, but I was
confused by installation instructions for other modules that refer to a
PREFIX parameter that announces installation in nonstandard directories.
Anyway, I finally got DBI and DBD::Oracle installed successfully.
D
This is not DBI related, so please post to appropriate list.
MySQL did not support foreign keys until recently, and even now it's limited
to BDS tables.
Ilya
-Original Message-
From: Vuillemot, Ward W
To: [EMAIL PROTECTED]
Sent: 10/30/01 8:37 AM
Subject: MySQL and Foreign keys
I would
I would like to know how people handle foreign keys with mysql.
Has anyone ever created a relationships table for use with other tables? If
so, what types of fields did you find necessary to define the relationships?
How did you handle parent-child relationships -- when parents are deleted
all th
At 7:12 am -0800 30/10/01, Bill Moseley wrote:
>Hi,
>
>I've found a number of generic CGI scripts for simple table operations, but
>nothing great. Is there one that's well-coded, where I can simply specify
>the the column data types, and validation routines and be done? In a
>perfect world it wo
Hi,
I've found a number of generic CGI scripts for simple table operations, but
nothing great. Is there one that's well-coded, where I can simply specify
the the column data types, and validation routines and be done? In a
perfect world it would be Template-Toolkit based, too.
Thanks,
Bill Mo
Hi Ryan,
To connect to a remote database, all you need to do is catalog the remote
database. This means cataloging the node (ie. the server where the
database resides) then cataloging the database at that node.
Here's an extract from the DBD::DB2 perldoc:
Data Source Names (DSNs)
The data
Hi Dan,
> Can someone give me some examples of high-volume, high-profile sites using
> mod_perl and dbi?
A lot of people use Embperl (HTML::Embperl), often with mod_perl and DBI. You
can see some of these sites here:
=> http://perl.apache.org/embperl/Sites.pod.1.html
A lot of other people als
Gary L. Burnore wrote:
> At 16:14 10/29/2001, you wrote:
>
>> I get the following message when I run the make command on my system:
>>
>> I install the latest version of g++, but I think I am missing which
>> variable needs to be set in order for this to work. Please help.
>>
>> Jason
>>
>> mk
25 matches
Mail list logo
