Hello db2perl,
Tuesday, June 19, 2001, 12:33:07 AM, you wrote:
I specified file instead of dir. Now i changed it to dir
and, heh, trace file appeared ;). Here is it
[ Process: 1104, Thread: 1024 ]
[ Date Time: 19/06/2001 10.54.23.08 ]
[ Product:
Hello,
the first of my problems has been solved (just a little error
when writing the data), the second one still occurs; here
is an example what happens:
The following SQL generates Output in Fixed-Format:
select
isnull(convert(char(4 ), gewinnspiel_nr ), space(4))
Hello,
the first of my problems has been solved (just a little error
when writing the data), the second one still occurs; here
is an example what happens:
The following SQL generates Output in Fixed-Format:
select
isnull(convert(char(4 ), gewinnspiel_nr ), space(4))
hi
after having some problems with 'perl Makefile' it ran succesfully with
a warning
Not (probably harmless): No library found for -lpq
Writing Makefile for DBD::Pg
then when i did make it gives me the following error
make
..
..
..
/usr/include/stdio.h:164: warning: `BUFSIZ'
Date sent: Mon, 18 Jun 2001 20:46:37 -0500
From: Aguztyn Garcia-Cruz [EMAIL PROTECTED]
Organization: Internet Cancun
To: [EMAIL PROTECTED]
Subject:HELP, HELP, HELP
Aguztyn,
What am I doing WRONG
I do not know
WE are having a problem in the installation of DBI module DBI-1.18
ON :
detail of platform sun solaris 2.8 version.
the error that is coming is that the module is unable to search perl.o
pl. let us know weather the perl.o is part of default installation or weather
we have to download it
From: Bodo Eing [EMAIL PROTECTED]
To: [EMAIL PROTECTED], Aguztyn Garcia-Cruz [EMAIL PROTECTED]
Date sent: Tue, 19 Jun 2001 12:31:42 +0200
Subject:Re: HELP, HELP, HELP
Priority: normal
Aguztyn,
What am I doing
The problem is exactly what it says: language optional software package not
installed
. You appear to be using a pre-built perl binary that was created using
/usr/ucb/cc which you have not installed in this host.
You need to either install the optional C compiler or install gcc and build
perl
Hello.
Someone asked me about installing oracle module on hp-ux. They said always failed in
install.
So I let they know how to compile in my experience. But it was same thing.
I tried to fix makefile file and write a documentation about this problems. but
anything coudn't help them.
I know
Hi,
The problem was solved. All I had to do is to set the LD_RUN_PATH variable in
the Makefile to {my oracle_home}/lib and then continue with make, test and install of
DBD.
But after this problem, I ran into another :-) ...I got the following error:
Software error:
Couldnt connect to
Then unless you can get pre-built copies of DBI and the necessary DBD
modules from the same source you got Perl from, you won't be able to use
DBI.
__Someone__ has to use a C compiler to build DBI and most of the DBD
modules.
I am not your private consultant. Please reply to the dbi-users
You probably need to set ORACLE_HOME in the environment of the process that
runs the webserver.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
-
I realized after posting that my error message and sample code are inconsistent - the
procedure is indeed called Step_Two and I AM passing in the correct number of
parameters. However, when I pass in NULL (undef in Perl) for at least one of the
parameters, the error message below results.
The distinct clause in an SQL query does not work in
some cases.
For example if I had a table/file Test with one column
say name
name
sanjiv
400-522
400-523
blah
the query 'select distinct name from Test' returns
only
sanjiv
400-522
blah
For some reason it treats 400-522 and 400-523
Hi,
I am trying to insert a record into an oracle database, and i need to
insert leave some of the fields null, but other time's I may need to
insert data into those fields within the same script. Does anyone
have any ideas how I might achieve the null business?
thanks very much
Edd Dawson
DBD::Oracle inserts null if the value of the bind parameter is undef.
Therefore if you have a scalar which is undef it will insert as null, other
time when it has a value it will insert the actual value. You must use
placeholders though. See docs.
Ilya
-Original Message-
From: Edd
Sanjiv Jivan wrote:
The distinct clause in an SQL query does not work in
some cases.
...
For some reason it treats 400-522 and 400-523 as the
same.
Are you running with warnings (-w)? If not, you should be. If so, you
will probably see something like this warning:
Argument 400-522
Hi,
I'm trying to install DBD 1.00 PC1 on my system and I'm stuck, any help
would be appreciated.
OS: Sun Solaris 5.6 sparc
Perl: v5.6.1 built for sun4-solaris
I've installed Informix server 7.3.1 + sql 7.30 + esql 5.10 + DBI 5.1
I've tried to set variables to demo table stores7 as well
When I
Mitch Helle-Morrissey wrote:
Maybe you are having some problems with string vs. numeric operations.
Yes. That's the problem.
I'm haven't ever used DBD::CSV, but maybe there is a quote() operator that
you can use, and send in the correct datatype?
This module (and DBD::AnyData also)
Thanx for the tips. I will definitely incorporate them. Something else must
have been gobbling up the database, 'cuz I finally got the query to run. The
bad news was that it took about 22 minutes, so now I get to figure out why.
Thanx, everybody, for the help.
ltg
-Original Message-
On Tue, Jun 19, 2001 at 07:09:40PM +0200, Christine Kluka wrote:
Now the error that I get is: xxx.cgi did not produce a valid header
(name without value:got line variable $i is not imported at xxx.cgi
line 65.) I need to declare the subroutine row in which the error is
found to do a fetchrow
has anyone succeeded in submitting
a query where placeholders would be mixed with data?
like in
INSERT INTO table_name ( foo, bar, john, doe)
VALUES (?, 'blah', ?, ?)
Thanks
Yes you can submit placeholders mixed with data ...
- Original Message -
From: Ilya Dyakov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 1:24 PM
Subject: mixed binding?
has anyone succeeded in submitting
a query where placeholders would be mixed with data?
Yes, that looks good, but what's not working. You need to tell us the error
and/or unexpected results before we can help you. But mixing placeholders
with data is totally fine.
Ilya
-Original Message-
From: Ilya Dyakov
To: [EMAIL PROTECTED]
Sent: 06/19/2001 2:24 PM
Subject: mixed
Hi,
I'm running the following:
Oracle 8.1.7 for solaris7/intel
Oracle 8.1.7 client for solaris7/intel
DBI versions 1.15 1.18
DBD::Oracle versions 1.0.6 1.0.7
PERL 5.6.1 5.005_003
Seems a simple database connection attempt without executing any sql scripts
ends up with a segmentation fault
Has anyone figured out how to call OCIPasswordChange from Perl (with or
without DBI)? The reason I'm asking that Oracle is saying that
OCIPasswordChange function should be used instead of 'alter user..' to
accomplish password changes. I'm hoping someone has figured out how to do
this using
Tai wrote:
Hi,
I'm running the following:
Oracle 8.1.7 for solaris7/intel
Oracle 8.1.7 client for solaris7/intel
DBI versions 1.15 1.18
DBD::Oracle versions 1.0.6 1.0.7
PERL 5.6.1 5.005_003
Add Oracle 8.1.6 client, solaris 2.6, perl 5.004_04, DBI 1.18,
DBD::Oracle 1.06 to the
Hi,
I'm trying to connect MySQL using the following code:
#!/usr/bin/perl -w
use CGI qw(:standard);
use DBI();
print header;
print start_html(mysql);
print h1(Lista de Medicamentos/Cosméticos);
$dbh = DBI-connect(DBI:mysql:fol,fol,passfrr27);
$sth = $dbh-prepare(SELECT CODE,DESCRIPTION
Juan,
I don't see location or port # in your connection string. Here is an example
of connecting to MySQL using default MySQL settings for port, and with the
MySQL daemon (service) running on the local machine. You don't have to
format it the same way, but you have to get all the elements into
Port number isn't required unless you are running your mysqld client on
other port than default.
what is happening when you execute the script?
have you tried connect(...) || die Cannot connectect to the database
$DBI::errstr\n; ?
Anton
-Original Message-
From: Steve Howard
Hi Anton,
At 18:32 19/06/01 -0700, Kokarski, Anton wrote:
Port number isn't required unless you are running your mysqld client on
other port than default.
what is happening when you execute the script?
Just shows the title.
have you tried connect(...) || die Cannot connectect to the database
At 10:09 PM -0300 6/19/01, Juan wrote:
Hi,
I'm trying to connect MySQL using the following code:
#!/usr/bin/perl -w
use CGI qw(:standard);
use DBI();
print header;
print start_html(mysql);
print h1(Lista de Medicamentos/Cosméticos);
$dbh = DBI-connect(DBI:mysql:fol,fol,passfrr27);
$sth =
Hi Paul,
Is this a request, or a quiz?
You don't perform any error-checking on your connect() call, for
one thing, so you don't know if (or why) it fails. That's your
first step:
$dbh = DBI-connect ( )
or die Connect failed: $DBI::errstr\n;
I added after send the first post, and
Hi,
I get the error when I try to connect.. :o((
What's wrong?
TIA,
Juan.
Just a thought, if the defaults are not working and:
1. you've verified you are trying to connect to the right server,
2. you have network connectivity to the right server from the server where
the scripts are running,
3. you have proper name resolution (since your script is trying
35 matches
Mail list logo