> - Forwarded message from Brant Winter <[EMAIL PROTECTED]> -
>
> Tim - I am having huge issues installing DBI on a Linux RedHat8.0
> server. I need it as a dependency for PerlDesk. Without it I cannot go
> any further. I am looking at some issues raised with you in the
> following forum,
- Forwarded message from Brant Winter <[EMAIL PROTECTED]> -
Delivered-To: [EMAIL PROTECTED]
From: "Brant Winter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: DBI t/40profile.t issues
Date: Thu, 29 May 2003 14:38:14 +1000
X-MDRemoteIP: 192.168.1.72
X-Return-Path: [EMAIL PROTECTED]
X
It looks like the .net libraries and compiler are first in the list. I
haven't tested with that. I still use VC98 from the command line. Are you
building perl with the .net compiler or are you using ActiveState?
Jeff
>
> Hi,
>
> I downloaded 1.05 of DBD::ODBC and manually attempted to
> in
Hi! list,
Could someone point me to the links which have
examples on how to manipulate data from two different
database handles.
I need to write a program which gets new policies or
renewals data from DB2 check in the Oracle database if
they already exist if not insert the new records after
verif
Hi,
I downloaded 1.05 of DBD::ODBC and manually attempted to install from dos prompt. The
failure occurs on step 2 of the install procedure. Unresolved external __ftol2. I
have .Net installed. Not sure if that is a problem.
OS= win2k
Perl=5.8.0
DBI=1.37
step1: perl Makefile.PL --> success
This is much faster and more accurate:
if ( DBI::looks_like_number($rv) ) {
...
}
Uses perl's own internal code.
Tim.
On Wed, May 28, 2003 at 02:36:26PM -0600, Ian Harisay wrote:
> I read the other responses. It is hard to determine what is happening
> without seei
(Take Two... a screwed up the dbi-users address)
Hi,
On Sun (solaris 8) I am rebuilding my perl tree using perl 5.8.0, DBD-Oracle
1.14 and my own bootstrapped build of gcc 3.2.3.
It appears I had to hack Makefile.PL to get a good link with oracle 9.2
(64bit version).
Oracle seems to
This will match empty string '', '..' and other non-numeric strings,
but will not match -1, 1.2e2, etc.
You better look in Perl Cookbook, Chapter 2, page 44.
-Original Message-
From: Ian Harisay [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 3:36 PM
To: Gregg Allen; [EMAIL PROT
I read the other responses. It is hard to determine what is happening
without seeing some code. but to simply determine if something is a
numeric value on could just use a regular expression:
($rv) = $sth->fetchrow_array();
if( $rv =~ /^[^0-9\.]*$/ ){ #-- the regex will work with unformatted
>
>
> Hi All
>
> I'm having the same problem.
>
> I've had a look in the Activestate 5.6 repositories
> http://ppm.activestate.com/PPMPackages/zips/6xx-builds-only/.
> I can find the DBD-Oracle PPM there.
>
> But the 5.8 repositories still doesn't have the DBD-Oracle PPM
> http://ppm.acti
Hi All
I'm having the same problem.
I've had a look in the Activestate 5.6 repositories
http://ppm.activestate.com/PPMPackages/zips/6xx-builds-only/.
I can find the DBD-Oracle PPM there.
But the 5.8 repositories still doesn't have the DBD-Oracle PPM
http://ppm.activestate.com/PPMPackages/zip
On Wed, May 28, 2003 at 12:31:33PM -0400, Thomas Good wrote:
> Hi, how does one use LIKE and a wildcard with variable binding??
>
> $q = qq |select * from x where y like ?|;
> ...
> $sth->execute($some_variable)
>
> where does the % go??
my $some_variable = '%here%';
The placeholder variables g
On Wed, May 28, 2003 at 12:25:36PM -0400, Gold, Samuel (Contractor) wrote:
> I believe you have to you use it like this:
>
> $q = qq |select * from x where y LIKE ?|;
>
> upper casing the LIKE.
Reserved words in SQL are case-insensitive. like is the same as LIKE is
the same as LikE.
Ronald
$stmt = $dbh->prepare( qq |select * from x where y like ?| );
$stmt->bind_param( 1, 'foo%bar' );
$stm->execute;
The '%' is part of the actual bound parameter.
-klm.
- Original Message -
From: "Thomas Good" <[EMAIL PROTECTED]>
To: "DBI Users" <[EMAIL PROTECTED]>
Sent: Wednesday,
On Wed, May 28, 2003 at 12:31:33PM -0400, Thomas Good wrote:
> Hi, how does one use LIKE and a wildcard with variable binding??
>
> $q = qq |select * from x where y like ?|;
> ...
> $sth->execute($some_variable)
>
> where does the % go??
The % must be part of the bound value. For example:
$sth
On Wed, 28 May 2003, Gold, Samuel (Contractor) wrote:
> I believe you have to you use it like this:
>
> $q = qq |select * from x where y LIKE ?|;
>
> upper casing the LIKE.
Hi Sam, no it is already uppercase (and sql is not case sensitive)
but I am getting complaints if I do ?% after like OR if I
I believe you have to you use it like this:
$q = qq |select * from x where y LIKE ?|;
upper casing the LIKE.
HTH,
Sam Gold
-Original Message-
From: Thomas Good [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 12:32 PM
To: DBI Users
Subject: LIKE and Variable Binding
Hi, how doe
Hi, how does one use LIKE and a wildcard with variable binding??
$q = qq |select * from x where y like ?|;
...
$sth->execute($some_variable)
where does the % go??
TIA!
---
Thomas Good e-mail: [E
One other thing that I use DBD::CSV for is configuration. I maintain a system which
has multiple users each with a profile. I maintain a separate directory for each user
with CSV files in it. I can "connect" to the particular user's database easily at the
start of the process.
-Original Mes
[EMAIL PROTECTED] wrote:
in some cases one don't need really high performance but a well
organized place to store data. In this case DBD::CSV may could
be the solution. But what happens if the amount of data grows?
When the data grows, you can easily migrate from DBD::CSV to any other
DBD. You c
Hi,
in some cases one don't need really high performance but a well
organized place to store data. In this case DBD::CSV may could
be the solution. But what happens if the amount of data grows?
Is there any performance comparision between DBD::CSV based
applications and others (like DBD::Oracle o
David Wilson wrote:
Is is possible to create a database through CSV, or is DBI primarily
for accessing established databases? If possible, how do I create
a local database via DBI? If not, how do I manually create an empty
CSV database?
DBI works with database-drivers (DBDs) to communicate wi
DBD::CSV will allow you to create a "database" of CSV files. First create a
sub-directory to place the files. Then use CREATE statements to create the "tables"
(files). It's documented in the man page.
-Original Message-
From: David Wilson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 2
I am in the process of learning DBI. My immediate goal it to create
a CSV database which I will populate from local text files. I would
like to do this using a standalone Perl script.
Is is possible to create a database through CSV, or is DBI primarily
for accessing established databases? If po
sasi pillutla [EMAIL PROTECTED] wrote:
> How can i redirect to my error page if the database
> connection fails with the error message
Read the perldocs for DBI - specifically read up on
'RaiseError' and 'Transactions' - the transactions section
will show you how to trap errors using 'eval'. Once
25 matches
Mail list logo
