Hi,
I am having problem and need your attention. How to write an SQL statement for the
below in Oraperl:
$csr = &ora_open($lda,"select datetime, comments, user_id
from table1
where message = 'NEW USER'");
I knew that this w
I s it possible?
I've built DBI on Linux using for C++ parts lib.so.6(link to libc-2.1.3)
But i need to make work this bulit module on perl(5.6) installed on a remote
machine(CGI_hosting) with no such libc. I have onle ftp-access to my
directory and have no oportunity to install packages remotely
We have an application that uses the following query to get information
about tables in a SQL Server database. Everything (Perl, SQL Server, &
web server) runs under Windows. The name of the table ($table_name) is
usually input from a web form. The column names returned by the query
are
Hi All,
I need to get my db connection from a connection pool. Can anyone
suggest how to do this. I'd like to this without being tied to a
specific web server. Such as, Apache::DBI requires Apache.
Thanks for the help,
Ian
Hello,
I installed perl 5.6.1 and DBI-1.2.1 and have Interbase 5.0 running.
Perhaps the problem is that I have Interbase 5.0, but I noticed a similar
post a few weeks ago with no posted resolution. here is the problem:
I have aproblem installing DBD::Interbase-0.30.
---
That did it! Thank you all very much.
Creigh
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 3:13 PM
To: Tompkins, Creigh
Cc: [EMAIL PROTECTED]
Subject: RE: bind_param and space filled fields
I had this problem awhile back. You need to
I had this problem awhile back. You need to bind the variable to
SQL_CHAR type then the spaces will be retained. The SQL_VARCHAR type
will consider spaces as null.
Try using:
$sth->bind_param( ++$number, $hashref->{$key}, SQL_CHAR);
Gordon
-Original Message-
From: Tompkins, Creigh [ma
The problem is that I don't want them to be null. They come into the module
as space filled, for some reason bind_param is
converting them to nulls. At least I think so, or it's a surrounding quote
issue. Either way I can't get the space
filled field to remain that way through to the actual i
you could just check all your values for strlen or isset and assign NULL
to the ones that should be prior to passing off to bind_param function.
"Tompkins, Creigh" wrote:
>
> Help,
>
> I have a generic table wrapper that builds inserts on the fly using
> bind_param. It works fine until it trie
Help,
I have a generic table wrapper that builds inserts on the fly using
bind_param. It works fine until it tries to insert a space filled character
variable into a NOT NULL varchar2 table column.
It then produces the error:
DBI Error string=ORA-01400: cannot insert NULL into
("FACTORY"."MENU
Mark,
This sounds like a problem related to the permissions of the user running
the script from the web server. The oerr info for this error indicates:
12638, 0, "Credential retrieval failed"
// *Cause: The authentication service failed to retrieve the credentials
of a
// user.
//
"Scott R. Godin" wrote:
>
> The weird thing is, the same problem occurs even if I push some other
> test in front of the XML test. =:o (tried that last night)
Scott, there are problems between XML::Twig's file locking and AnyData's
file locking so nothing you do will get the tests to work on Lin
Mark Charshaf wrote:
>Hello,
>I just installed DB2 v7.1 (PE) on my RedHat Linux machine. I'm familiar with
>ADO on the Microsoft side with connecting to various DB's, but I'm very new
>to the Linux/Unix programming side.
>
>Where is the best place for a intermediate Perl programmer type to pick u
Jeff Zucker's newer versions of SQL::Statement do not show up when you
use CPAN.pm's shell to
m SQL::Statement
if one doesn't know of the newer version, one might be inclined to
believe it doesn't exist.
just FYI
print pack "H*", "4a75737420416e6f74686572204d61635065726c204861636b65722c
In article <061601c1f511$cf6ab2d0$05c3eed4@asarianhost>,
[EMAIL PROTECTED] (Mark) wrote:
> Hello,
>
> Just branching into the whole MySQL thing. :)
>
> Does anyone know a good place for examples on how to use DBI.pm?
>
> Thanks.
>
> - Mark
>
>
I found having this handy to be VERY useful:
Yes, install the modules see README, then read their respective perldocs.
You might also want to invest in "Programming the Perl DBI".
Ilya
-Original Message-
From: Mark
To: [EMAIL PROTECTED]
Sent: 5/6/02 9:22 AM
Subject: DBI newbie
Hello,
Just branching into the whole MySQL thing. :)
O'Reilly's Programming the Perl DBI was very helpful to me when I
started out with this...
--
Barbara E. Lindsey,
Phone: (352) 392-5198 ext. 314 Fax: (352) 392-8162
"The road goes ever on and on. "
- Bilbo Baggins
Hello,
Just branching into the whole MySQL thing. :)
Does anyone know a good place for examples on how to use DBI.pm?
Thanks.
- Mark
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Jeff Zucker) wrote:
> "Scott R. Godin" wrote:
> >
> > my e-mail below isn't working, and Jeff's mailserver is rejecting mail
> > from my comcast.net domain (my ISP) *sigh*
>
> Strange. I have some other email addresses but am traveling at the
That means you haven't installed it, installed it in a non-standard
location, or installed it under a different Perl than you are running the
script with.
One thing to make sure, is that if you have more than one perl installed on
the machine, you are installing and running it with the same one.
A new version (0.60) of SPOPS (Simple Perl Object Persistence with
Security) has been released to CPAN. (Version 0.59 was released
without fanfare to CPAN to fix version numbering issues kindly pointed
out by merlyn.)
SPOPS is a robust and powerful module that allows you to serialize
objects to D
Start with `perldoc DBI` and `perldoc DBD::DB2`. Then go get a copy of The
Good Book (aka Programming the Perl DBI).
***
Jeff Seger
Data Warehouse Engineer
Fairchild Semiconductor
[EMAIL PROTECTED]
***
On Mon, 6 May 2002 13:53:51 +0930 (CST), Wilkinson,Alex wrote:
>I have just installed the DBI.pm module manually.
>
>However, Perl cannot seem to find the module.
>
>eg.
>
>Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris
>/usr/perl5/5.00503 /usr/perl5/site_perl/5.005/
On Mon, 6 May 2002 08:39:37 +1000
"Michael Blackmore" <[EMAIL PROTECTED]> wrote:
>
> my ($col1,$col2,.) = split(/,/);
> $col1 = undef unless($col1);
>
>
> I realise that this is not strictly a DBI problem, really 'split'
> should return undef's, shouldn't it? Anyway I wondered if a
Howdy Crew,
I have just installed the DBI.pm module manually.
However, Perl cannot seem to find the module.
eg.
Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris
/usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005
.) at ./run-all-te
25 matches
Mail list logo