Thanks for the suggestions that I received.
We finally managed to find and correct the issue so I thought I'd share it
with the group to close this thread.
Essentially, if we try to use a local catalog entry for the DB2 10.5
database we consistently get slow response times (4s for 32-bit version a
t;, $end - $start);
return $dbh;
}
getDatabaseHandle();
1;
We've tried various things (like switching from 32-bit to 64-bit, using
ActivePerl instead of then vendor's Perl 5.10 implementation) and nothing
seems to improve it.
If any body can offer up any sort of suggestion, I'd be most grateful -
we're truly stumped.
Thanks,
Andrew
are you reading all of the rows at once? It is possible that the
results set is too large to fit into memory- get a count of the number
of rows that would be returned to eliminated that as a possibility.
On 07/01/2013 06:20 PM, KOTAGIRI, RAMPRASAD wrote:
Environment:
Perl v5.8.4 built for
Thank you all for your replies. I am indeed talking about working with
multiple back ends (oracle, mysql, or any valid DBI module) in the same
query.
I'll post any follow-up questions to the dev list.
Andrew
On 06/26/2013 08:26 AM, Andrew Snyder wrote:
I want to write a query like:
s
can you run strace, or the HP equivalent, to see what system calls are
getting made and what files are and are not found?
the system call that doesn't return is likely where the problem is.
Check the time stamp of any file that is loaded to see if it was changed
recently. Any file that it lo
databases, 'columnar' is one or columnar databases, and 'web' is the
Apache logs on one or more web servers. The dbi driver would be
configured to connect to the correct databases and filter web hits based
on 'client_id'.
Has somebody written that already?
Thanks,
Andrew
Amar,
I suspect that you want to know about DBI first, and then about
DBD::Sybase.
For DBI, try this
http://dbi.perl.org/
For DBD::Sybase, try this
http://www.google.com/search?q=dbd+sybase&sourceid=ie7&rls=com.microsoft:en-us:IE-SearchBox&ie=&oe=
Steve,
First, a caveat: I've never used mysql, so I could be totally off-base
here.
Perhaps this behavior is the result of some implicit transaction, so
the first SELECT begins a transaction, and the DBMS wants to present a
consistent view of the database (that is, return the
I suggest that we move this discussion to dbi-dev.
On 11/09/11 18:14, Tim Bunce wrote:
On Fri, Sep 09, 2011 at 03:50:53PM +0100, Andrew Ford wrote:
Currently DBD::Gofer::dr:connect() contains code to set up the transport:
my $transport_class = delete $go_attr{go_transport
my ($self, $request) = @_;
return $executor->execute_request( $request );
}
1;
This would be suitable for middleware modules to wrap.
Andrew
Thinking about how middleware could be implemented in DBD::Gofer - see
below ...
Tim Bunce wrote:
On Thu, Sep 08, 2011 at 01:19:17PM +0100, Andrew Ford wrote:
and I would quite like to get this module onto CPAN and would like some
feedback as to
whether "the expert" thin
Tim Bunce wrote:
On Thu, Sep 08, 2011 at 01:19:17PM +0100, Andrew Ford wrote:
and I would quite like to get this module onto CPAN and would like some
feedback as to
whether "the expert" thinks it is a bad idea. I think it would be a useful
addition to the testing
ar
make
make test
make install
-Original Message-
From: Matthew Ramadanovic [mailto:matthew.ramadano...@yale.edu]
Sent: Tuesday, February 22, 2011 6:37 AM
To: Nguyen, Andrew; dbi-users@perl.org
Subject: RE: DBI error
Have you made sure your environment points to
Hi,
I am Andrew Nguyen with Pacific Life. We are using Perl DBI-1.28 in Oracle
8.1.7 for many years. We just upgraded our Oracle to 10.2.0. And now the
DBI does not work anymore.Please advise what to do. Thank you in advance
for your help.
OS: HP-UX 11.11.
Oracle: 10.2.0.4
PATH to
> /opt/Oracle/instantclient_10_2.
Yes, we have ORACLE_HOME=/opt/Oracle/instantclient_10_2. I don't have
LD_LIBRARY_PATH set, but instead we put /opt/Oracle/instantclient_10_2 into
/etc/ld.so.conf and ran ldconfig.
Thank you very much for your help.
Andrew.
point me to a
precompiled package, or tell me where to find the files I seem to be missing in
order to build it myself?
Thanks,
Andrew.
arlier versions, even though passwords are
> > stored in encrypted form in the user table, knowledge of the encrypted
> > password value could be used to connect to the MySQL server.) Section
> > 5.3.2.3, “Password Hashing in MySQL”, discusses password encryption further.
> >
Yes, I am only talking about remote connections. This sounds like a
great idea Alexander, and it certainly looks doable in PHP:
http://themetricsystem.rjmetrics.com/2009/01/06/php-mysql-and-ssh-tunneling-port-forwarding/
Here's hoping that it will be just as easy to do it with Perl and DBI.
> I
@Philip: You were correct. Thanks for the advice; I'm new to Perl, and I
didn't realize that wasn't correct. After changing it as you suggested, the
program seems to work. Again, thanks.
@Martin: I'll take a look around the system I'm working with and see if I can
figure out where the auto
I am working with a perl file intended to enter a postgresql database (as user
postgres), select a list of key values based on one of those values and delete
any records which match the returned results. The purpose of the program is to
delete inactive records from the database that are over tw
::DBD 1.19 could not?
Thanks.
Andrew McFarlane
_
Valentines Day -- Shop for gifts that spell L-O-V-E at MSN Shopping
http://shopping.msn.com/content/shp/?ctId=8323,ptnrid=37,ptnrdata=24095&tcode=wlmtagline
;t safely send the encryption key to the
client, since the channel you send it is insecure.
Hope this helps.
Andrew Baumhauer
n-Capture Consulting
e I'm installing
DBI via 5.8, can anyone tell me what's going on here? Thanks.
Regards,
Andrew
I've included the gory details below per the
README including:
1. A complete log of a complete build, e.g.:
perl Makefile.PL (do a make realclean first)
make
mak
row 4: column: nch (uft8) smiley face'
# in t/nchar_test_lib.pl at line 344.
# got: '&:'
# expected: '\x{263A}'
ok 72 - byte_string test of row 4: column: descr smiley face
ok 73 - nice_string test of row 4: column: descr smiley face
#row 4: DUMP(nc
Hi John. Here's the info:
Red Hat Enterprise Linux AS release 3 (Taroon Update 5)
uname -a:
Linux ** 2.4.21-32.ELsmp #1 SMP Fri Apr 15 21:17:59 EDT 2005 i686
i686 i386 GNU/Linux
Thanks, Andrew
-Original Message-
From: John Scoles [mailto:[EMAIL PROTECTED]
Sent: Thursday
_test_lib.pl at line 344.
# got: '&:'
# expected: '\x{263A}'
ok 72 - byte_string test of row 4: column: descr smiley face
ok 73 - nice_string test of row 4: column: descr smiley face
# row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58
ok 74 - number of rows fetched
On Wed, Nov 30, 2005 at 02:58:15PM -0700, Michael Fuhr wrote:
>
> Shouldn't that be 8.0 and later? That's when savepoints were
> introduced. Or are you referring to something else?
Doh. Indeed. I was _thinking_ os something else, but not referring
to something else.
A
Certainly, MySQL's support of transactions is
occasionally pretty dodgy, unless you use the strict mode.
But it's worth knowing that in Pg 8.1 and later, you can wrap such
things in a subtransaction and get out of it that way.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
I remember w
l ./Makefile.PL PREFIX=$HOME/modules -Duse64bital
?
Thank you.
Andrew
"Bjorn Naessens" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Rebuild perl with -Duse64bitall flag. There have recent been a number of
problems with this ( it's the same error as some people
Also, outside of the loop you're printing the variable "p1", not "field1".
That's why that value is printing.
>print "go
here";
Andy
-Original Message-
From: Ronald J Kimball [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 09, 2005 4:43 PM
To: 'MCMULLIN, NANCY'; dbi-users@perl.org
On Fri, Jul 09, 2004 at 08:08:37AM +0200, Michael Peppler wrote:
> On Thu, 2004-07-08 at 21:42, Andrew Pimlott wrote:
>
> > - Have the database drivers set the close-on-exec flag of the fd used to
> > connect to the database. This makes sense to me, because after an
&g
debugger is probably pretty heavy already. Also, is there a clean,
portable way to ask "is this fd open?"?
Anyhow, a night's sleep and Tim's opinion convince me that this is
clearly the right approach.
Andrew
he usual issues with global
destruction, but if it can be done it should work.
Opinions?
Andrew
On Fri, 2004-06-11 at 02:14, Jeff Urlwin wrote:
> > I noticed what looks like a typo bug in dbd-odbc 1.09. Line
> > 139 has 8/ instead of */ Is that the same in your version?
>
> Why don't we do this (er, the "royal we"). Can you get subversion and pull
> the latest so we are talking apples and
RH7.3 system left
> to test on.
LOL. Fair enough. I will be slowly migrating services to more recent
rh/fedora builds once I can determine that important things won't break.
I know certain really important things that will.
So Jeff do you have these packages available somewhere? I
lid type argument of `->'
dbdimp.c:3951: warning: passing arg 1 of `fprintf' makes pointer from
integer without a cast
dbdimp.c:3952: invalid type argument of `->'
dbdimp.c:3957: warning: passing arg 1 of `fprintf' makes pointer from
integer without a cast
dbdimp.c:3958: warn
L2k server?
Thanks,
---
(o< Andrew Elliott phone: 989.907.2155
//\ Router/IP Lvl 2 Support pager: 989.929.0525
V_/_ XO Communicationstext page: [EMAIL PROTECTED]
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Yes. This also works.
Andrew
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: February 25, 2004 5:21 PM
To: Howell, Andrew
Cc: 'Tim Bunce'; '[EMAIL PROTECTED]'
Subject: Re: DBD:Oracle "perl Makefile.PL" problem
On Wed, Feb 25, 2004 at 04
Changing "cc=echo" to "cc=" seems to have fixed the problem.
Applying the changes below in a separate also run seemed to fixed the
problem.
Andrew
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: February 25, 2004 3:58 PM
To: Howell, Andrew
C
bytes=8, prototype=define
Linker and Libraries:
ld='gcc -B/usr/ccs/bin/', ldflags =' -L/usr/local/lib '
libpth=/usr/local/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lbind -lnsl -lgdbm -ldb -ldl -lm -lc
perllibs=-lsocket -lbind -lnsl -ldl -lm -lc
libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' -R
/usr/local/lib/perl5/5.8.3/sun4-solaris/CORE'
cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under solaris
Compiled at Feb 10 2004 22:57:54
@INC:
/usr/local/lib/perl5/5.8.3/sun4-solaris
/usr/local/lib/perl5/5.8.3
/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris
/usr/local/lib/perl5/site_perl/5.8.3
/usr/local/lib/perl5/site_perl
.
#
Have fun.
Andrew Howell
Network Analyst
Technology Infrastructure Division
City of Ottawa
(613) 580-2424 x23194
[EMAIL PROTECTED]
might be hard to get the transaction back into a
consistent state after an error. So it might be a lot of work to write
that patch. :-(
Andrew
On Wed, Feb 25, 2004 at 12:35:07AM +, Tim Bunce wrote:
> On Tue, Feb 24, 2004 at 03:25:09PM -0500, Andrew Pimlott wrote:
> > I am using DBD::Pg, and I noticed that after a statement causes an
> > error, subsequent statements (until rollback) fail with "current
> &
redesign the application around this need, but I would
rather just set the disabled flag. Real deletion can be attempted in
the background if needed.
Andrew
l
within one transaction? I don't know of any way to check for
referential integrity violations without actually trying to delete the
thing. If I can't come up with a better solution, I guess I'll just
set disabled and forget about trying to delete.
Andrew
[1] http://www.postgresql.org/docs/current/static/plpgsql-errors-and-messages.html
#x27;t realize until now that it's not being
> thrown in the others.
As Tim suggested, I bet that what you're seeing is dependent on some
feature of the programs (and how they interact with the garbage
collector), not the DBDs.
Andrew
good to warrant keeping it. I guess it cold be an option,
though.
Incidentally, you already don't get the warning during global
destruction, so it isn't that reliable.
Andrew
On Sat, Feb 14, 2004 at 12:39:29AM +, Tim Bunce wrote:
> Here's what I've added to DBI 1.41:
>
> =item C (boolean)
>
> The C attribute is true if the handle object has been "executed".
This looks perfect, thanks!
Andrew
e committed or rolled-back, the connection
itself is garbage, so there's nothing wrong with letting the garbage
collector handle it.
> For feature-rich dbms's, there are
> well documented cases of outages caused by irresponsible applications.
I'm going to start using "feature-rich" like that. ;-)
Andrew
On Wed, Feb 11, 2004 at 04:24:31PM +, Tim Bunce wrote:
> On Wed, Feb 11, 2004 at 08:15:12AM -0500, Andrew Pimlott wrote:
> > Ok, so you'd like to issue the warning in the dangerous case only, but
> > DBI doesn't have the necessary information. That seems like a rathe
nd, for drivers that can, use that to skip the warning.
Ok, so you'd like to issue the warning in the dangerous case only, but
DBI doesn't have the necessary information. That seems like a rather
conspicuous flaw in the design, but I'm glad there's a plan to fix it!
Thanks for the explanation.
Andrew
:-)
I'm using DBI 1.40 and DBD::Pg 1.31 on Debian "testing".
Andrew
/lib/DBD/ExampleP.pm line
217.
t/06attrs..dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 24-126
Failed 103/126 tests, 18.25% okay
-andrew
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 5:15 PM
I have Oracle 9i (64bit) installed on my Solaris 7 server.
I've installed:
perl 5.8.0
DBI 1.32
The DBD readme metions oci7 and oci8 but nothing about 32 or 64-bit versions.
When trying to install DBD-Oracle-1.12, I get:
-
chmod 644 O
Thanks for the follow-up. I knew that the method that I am currently
employing was probably not the best way. The description really makes a lot
of sense. I will see if I can make it work.
Thanks,
Andrew
-Original Message-
From: Hardy Merrill [mailto:[EMAIL PROTECTED]]
Sent: Tuesday
ding of the DBI module.
Thanks,
Andrew
-Original Message-
From: Steve Haslam [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 12:31 PM
To: 'Hughes, Andrew'; '[EMAIL PROTECTED]'
Subject: RE: Error Handling
> entered into the database. With this code, I r
)\n";
}#end: err_trap
.
######
Thanks,
Andrew
Hi folks,
I'm closely (re)scrutinising the DBD::Informix doco for 1.00.PC1 and notice
that it says
Note that you cannot specify ChopBlanks in [the attribute] list [for
connect].
Now, I am passing it, and it seems to be working. Is the doco out of date or
do I need to put that somewhere else?
Id
$db is your database name.
So how do you connect and talk to MySQL without an existing database
with DBI?
A
> -Original Message-
> From: Andrew Brosnan [mailto:andrew@;broscom.com]
> Sent: Friday, October 18, 2002 1:54 PM
> To: Hardy Merrill
> Cc: Post; [EMAIL PROTECTED]
>
On 10/18/02 at 2:43 PM, [EMAIL PROTECTED] (Jeff Zucker) wrote:
> Andrew Brosnan wrote:
>
> Did you try it? This works for me (notice there's no database
specified
> in the connection):
>
> my $dbh = DBI->connect("dbi:mysql:");
> $dbh->do(&qu
sume you misunderstood my question.
Just the way you might create a table or make a query by executing some
SQL via DBI, I want to be able to create a new database from my perl
script via DBI.
Thanks Hardy!
Andrew
> --
> Hardy Merrill
> Senior Software Engineer
> Red Hat, Inc.
>
&g
On 10/18/02 at 2:10 PM, [EMAIL PROTECTED] (Jeff Zucker) wrote:
> Andrew Brosnan wrote:
>
> > On 10/18/02 at 4:26 PM, [EMAIL PROTECTED] (Hardy Merrill) wrote:
> >
> >>What database are you using?
> >>
> > Not sure why it would matter, but MySQL.
>
;y')");
>
> $dbh->do("insert into db (host, db, user, select_priv, insert_priv,
> update_priv, delete_priv, create_priv, drop_priv, grant_priv,
> references_priv, index_priv, alter_priv) values
> ('$ip','$database_name','$user',&
Hello List,
I'm looking to *create* a database with DBI. I couldn't glean this from
the docs. Seems like you first need to connect to a datasource(database)
to issue statements.
Is there a way to 'CREATE DATABASE DatabaseName;' with DBI?
Thanks,
Andrew
rl 5.6.1, DBI 1.27, and Net-Daemon 0.31,
thanks!
-andrew
;
Seems that it tightly binds parameters on a first execution, because
you'll get two non-null blobs. If you would exchange first insert
with second, you'll still get null in the first record, but in some
situations (cannot shrink large script to a viewable size) there
woul
is not equal. :(
--
Best regards,
Andrewmailto:[EMAIL PROTECTED]
Solaris, Oracle 9.2.0.1.0 with perl 5.6.1, DBI 1.20,
SS> DBD::Oracle 1.12.
So, should I say 'thanks' to ActiveState or MS? :)
--
Best regards,
Andrewmailto:[EMAIL PROTECTED]
How did you get around it?
thanks,
Andrew
quot;zero rows found" if ($retcode eq '0E0');
# =
#-- display any fetched rows
print "rows:\n";
my $rowref;
while (my $rowref = $sth->fetch) {
print " ", join(', ', @{$rowref}), "\n";
}
END SCRIPT ##
andrew crum -- [EMAIL PROTECTED] -- senior software developer @
metagenix, inc.
I think you'll need to provide details (simple scenario, exact error msgs,
proof that yetc) before anyone can provide help.
Suggested details: simple code that causes problem,
actual evidence/msgs associated with problem,
'perl -V' output
DBI
DBD-Oracle
At 09:40 AM 7/12/2002 +0530, you wrote:
>What are the installation modules necessary for connecting and executing
>queries from perl to oracle?
>
>Thanx
>Viji
I did not know what 'perlcc' was and so had to read a bit about it.
Given that your scenario is OK with 'perl', there is no need to question
your installation of DBI and DBD-Oracle modules.
Instead, the focus must be on perlcc and how it might have different
requirements than perl.
I searched w
Next question to answer:
Have you installed a DBD-Oracle module that would provide an Oracle
driver for the DBI?
At 08:50 AM 6/24/2002 -0700, you wrote:
>German,
>
>Estoy apesadumbrado. No tengo ninguna experiencia con el perlcc.
>
>--Thunder
>
>dbi-users,
>
>TRANSLATION:
>
>"When I exec
Yes.
gcc does not understand -KPIC. For gcc, substitute -fPIC.
Look for it in the Makefile.PL or possibly in the Makefile generated by
'make Makefile.PL'.
At 03:55 PM 6/21/2002 +0200, you wrote:
>Hallo,
>I have tried to install the Mysql module. By the instruction of
>http://www.mysql.com/doc
Try the module Text::CSV_XS
Andy
-Original Message-
From: NYIMI Jose (BMB) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 8:06 AM
To: [EMAIL PROTECTED]
Subject: Oracle_table to CSV file
Hello,
I would like to write a script (with DBI) that convert my Oracle table to
CSV fi
ren.
Each child issues SQL and exits.
The parent *would* therefore have a command to run, it would be something
like 'perl child.pl ' .
You apparently already have a script that (attempts to) both create new
processes and then use the child processes to launch SQL.
At 11:04 A
All,
I am at the end of my rope. I have searched the web and the archives and
have seen no solution to this posted, but I have seen some similar posts
out there. My proxy seems to be working just fine as long as I connect
from the local host. It fails when I try to connect from anywhere els
gcc does not know about 'KPIC' but a rough equivalent is 'fPIC'.
suggested remedy:
run 'make distclean'
if Makefile.PL contains 'KPIC' references, edit it now to change "KPIC"
to "fPIC".
run 'perl Makefile.PL'
if Makefile.PL did not contain 'KPIC' then edit 'Makefile' (or, if that
ke for example:
>ORACLE_HOME=/oracle/u01/app/oracle/product/8.1.6
>
>
>
>-Original Message-
>From: Andrew Crum [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, April 24, 2002 4:08 PM
>To: Mahdi A. Sbeih; [EMAIL PROTECTED]
>Subject: RE: Oracle version of Informix
>DBD_I
At 01:30 PM 4/24/2002 -0500, you wrote:
>Hi Andrew,
>
>It seems I was not clear enough, let me explain,
>
>When compiling DBD-Informix, the INFORMIXDIR will
>be hard coded in the in the compiled DBD-Informix,
>
>This way If the INFORMIXDIR changes for any reason,
>I
gt; > I know this may sound simple for you guys, but I am an
> > Informix DBA, and never used Oracle before, so some
> > hints will be appreciated.
> >
> >
> >
> > Regards,
> > Mahdi.
> >
> >
> >
-
Andrew Crum --- Metagenix, Inc.
ghan [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, April 23, 2002 4:02 PM
> > To: [EMAIL PROTECTED]
> > Subject: Connecting to MS SQL 2000?
> >
> >
> > What DBD module do I need to connect to a MS SQL 2000 DB?
> >
> > Thanks
> > Ravi
>
>
>_
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
-
Andrew Crum --- Metagenix, Inc.
hank you for this great module. Thanks!
Best regards,
Andrew Ivanov.
--- DBI.xs.orig Thu Feb 7 18:27:39 2002
+++ DBI.xs Thu Feb 7 18:29:10 2002
@@ -2960,8 +2960,10 @@
SvROK_off(DBI_LAST_HANDLE);
XSRETURN(1);
}
-if ( !ok ) { /* warn() may be changed to a debu
/Oracle 1.07 and DBI 1.20/Oracle 1.12.
Attached is also the make outputs as instructed in the README from
DBD::Oracle
Regards,
Andrew
oratest.pl
Description: Binary data
make.out
Description: Binary data
Tim Bunce wrote:
> On Tue, Oct 30, 2001 at 02:42:51PM -0800, Andrew Peebles wrote:
> > Can't get the sucker to build ... no trouble building lots 'o other
> > things, but not this. Details:
> >
> > /usr/ccs/bin/as: "/var/tmp/ccMwwld6.s", li
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
-Original Message-
From: Smithson, Michael (M.E.) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 3:39 PM
To: 'Hamilton, Andrew Mr RAYTHEON 5 SIG CMD'
Subject: RE: Can't locate DBD/mysql.pm
Also, you can invoke the use lib pragm and type the following:
us
You might check where the DBD installed. Some of them install in /usr/local
instead of /usr. Sounds like what has happened. That's one of the things
you have to look out for when using rpms.
Regards,
Drew
-Original Message-
From: pkp team [mailto:[EMAIL PROTECTED]]
Sent: Thursday, Aug
I use it on NT and matter of fact just reinstalled the latest version of AS
perl and DBI without incident. All works as it should.
Good Luck,
Drew
-Original Message-
From: Falk [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 10, 2001 10:15 AM
To: [EMAIL PROTECTED]
Subject: ActivePerl DB
new one which I want it to find. How do I specify an unorthodox
place such as ~/perllibs to search for .so's before the usual locations?
'use lib' and $LD_LIBRARY_PATH do not appear to make a difference.
Any help much appreciated.
-Andrew Hawkes
attached the version we are currently running.
<>
Thanks
Andrew Peters
The information contained in this email is intended only for the
use of the intended recipient at the email address to which it
ha
Jim Longino wrote:
>
> This message was cancelled from within Mozilla.
This feature is apparently not working yet
--
Kind regards
Andrew Higgs
HI,
Pallavi Patil wrote:
>
>
> Is MSAccess is okay or I should go for some other
> database?
>
You could try InterBase. It is currently available for free and runs on
windows or Linux.
--
Kind regards
Andrew Higgs
Adding the commas is really a PERL question.
To insert commas use "join" on the array.
Something like: $joinedline=join(',',@row);
This will take all fields and combine them, seperated with a comma. You will have
an issue if your text has commas in it so you have to qoute the text fields or if yo
Hi all
Is there a way in which I can create a database (using DBI, of course)? All
the examples I have seen seem to connect to a database rather than creating
one.
Is this possible?
--
Kind regards
Andrew Higgs
Greg,
Try changing your comparisons, for example: ($za01 == "QS") to ($za01 eq 'QS')
or a pattern match, like ($za01 =~ m/QS/). This is more of a PERL issue than DBI
related to
it's use of strings.
Andy
-Original Message-
From: Greg Wardawy [mailto:[EMAIL PROTECTED]]
Sent: Mon
Chris,
I usually get this when my database is not running. Or if the listener is
down. Check your host and sid, make sure the listener is up.
Regards,
Drew
-Original Message-
From: Chris Saunders [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 11:50 AM
To: [EMAIL PROTECTED]
Sub
On Thu, Jun 14, 2001 at 03:16:05PM -0700, traja wrote:
> How do I get the headers (column names) when I do a select thro' DBI.
> fetchrow will fetch only the data. I need to display the headers as
> well.
>From the DBI perldocs:
NAME (array-ref, read-only)
Returns a reference
On Wed, Jun 13, 2001 at 07:06:55PM -0400, Philip Mak wrote:
> I've been experimenting with a programming technique idea I had that I
> call "Object Oriented Databases". The goal of the technique is to make
> programming database driven websites easier by allowing the website code
> (I use Apache::
This isn't possible on solaris. There isn't an ld.so.conf. I recall having
the same problem a couple of years ago but can't for the life of me remember
how I solved it. Ajay, I'm still trying to come up with a solution for you.
Drew
-Original Message-
From: Ronald J Kimball [mailto:[E
1 - 100 of 114 matches
Mail list logo