You do not actually use Apache::DBI in your script. Please Read the
documentation.
> -Original Message-
> From: Mikael Hansen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 4:38 PM
> To: Perl DBI users
> Subject: Problem with require_version via package DBI
>
>
> Hi I have
Hi I have a small problem
I have an Apache 1.3.17, mod_perl-1.25, perl-5.6.0, ApacheDBI-0.88 and
DBI-1.15 on a Solaris 2.8 box.
I get the following error when running perl -c myStartupFile.pl:
Can't locate object method "require_version" via package "DBI" at
/q/app3w/perl-5.6.0/lib/site_perl/5.
- Original Message -
From: "K. Suresh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 2:55 PM
Subject: DBI - MySQL problem
> Hello All
>
> I am new user for DBI, DBD. I have problem installalling DBI.
>
> I have downloaded DBI-1.14 and compiled as per the inst
At 2:36 PM +1000 5/9/01, Michael Blackmore wrote:
>Dear dbi-users,
>
>I know this is not strictly dbi, however it is a problem when trying to
>insert 0's into an Oracle database. My problem is that I have a column in a
>table that can contain NULL, 0, or 1. I want to read from this table and
>in
Hello All
I am new user for DBI, DBD. I have problem installalling DBI.
I have downloaded DBI-1.14 and compiled as per the instrutions given
in README.
Also I have downloaded Msql-Mysql-modules-1.2215 and compiled as per the
instructions given in README.
=
Dear dbi-users,
I know this is not strictly dbi, however it is a problem when trying to
insert 0's into an Oracle database. My problem is that I have a column in a
table that can contain NULL, 0, or 1. I want to read from this table and
insert the data into another table, or update the data if
First let me recommend a good book on this topic "Advanced Perl Programming"
published by O'Reilly. Really covers XS deeply and thoroughly. Might help.
I've never embedded DBI/DBD's in any C/C++ program, so I'll leave it for
others to comment. I can imagine there would be some platform depende
Email on behalf of Mark Riehl (he is having problems posting
All,
What's the best way to approach this? I'm trying to put together an
application that needs to be flexible enough to use multiple databases
(MySQL and Oracle are the first two). I've done some experimenting with
Perl/DBI
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, May 08, 2001 at 12:59:39PM -0700, Michael A. Chase wrote:
> That's one of the banes of email lists. The reply-to address for any mail
> you send here is your email address, so if it bounces from any of the
> billions of addresses in the list,
Oops - the syntax is "ln -s " so
use "ln -s /usr/local/bin/gcc /usr/local/bin/cc" instead.
Marc
-Original Message-
From: Marc Beasley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 4:22 PM
To: Louie Iacona; '[EMAIL PROTECTED]'
Subject: RE: Trying to build with gcc on Solaris ..
Hi,
Try "ln -s /usr/local/bin/cc /usr/local/bin/gcc" and make sure
that /usr/local/bin is ahead of /usr/ucb in your path. This
will let the make program find gcc even though you specified
CC=gcc. This might be considered a hack, but it worked for
me!
Marc
-Original Message-
From: Lo
I didn't have raiseerror on, so I turned it on and just got the same message,
aborted (core dumped). Here is a much larger chunk of the code. It reads a |
delimited file. Some of the fields are further delimited with ^. One of the
data lines looks like:
PID|1||243||SIXEL^CARL^M^^^||19261024|M||
Ray,
I did remove everything and sart all over, this is what I am having as
errors now.
Lamine Diatta
lamine-[root] /PERL-DBI:
lamine-[root] /PERL-DBI:
lamine-[root] /PERL-DBI:
lamine-[root] /PERL-DBI: ls
dbi-1.15.tar
lamine-[root] /PERL-DBI:
lamine-[root] /PERL-DBI:
lamine-[root] /PERL-DBI: ta
Yes, I totally forgot about that... seems like you just mentioned that to
me not too long ago. I guess I forgot since I can't use placeholders in
my code because Sybase won't allow it with stored procs.
Sorry 'bout that.
On Tue, 8 May 2001, Ronald J Kimball wrote:
> On Tue, May 08, 2001 at 03:
Your best bet would be to get the sources and build Perl and your desired
modules from scratch using gcc. That way all the settings will be
consistent.
--
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 h
To get much further, we will need to see enough of your code to make some
sense of it.
Do you have $dbh->{RaiseError} set? If not, you may have a failure
somewhere else with no indication of what occurred.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give
gcc thinks the directory it is trying to write its temporary files is full.
Could it be trying to use a non-existent or excessively large directory?
--
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 hobbi
- Original Message -
From: Louie Iacona <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, May 08, 2001 9:36 PM
Subject: Trying to build with gcc on Solaris ...
> Hello - I'm attempting to build the current DBI on
> Solaris 2.8. We did not purchase the
That's one of the banes of email lists. The reply-to address for any mail
you send here is your email address, so if it bounces from any of the
billions of addresses in the list, you get the bounce message. The
turnaround at the list server is quick enough that you can just wait a half
hour to s
On Tue, May 08, 2001 at 03:29:30PM -0400, Sherry Graham wrote:
> I commented out the binds. So I just have:
>
> $patient_title = $dbh->quote($patient_title);
> print "HERE $patient_title\n";
> $sth->execute($first_name, $last_name, $middle_initial, $patient_ti
Hello - I'm attempting to build the current DBI on
Solaris 2.8. We did not purchase the C development option pack,
so we're relying on gcc.
How do I get the Makefile.PL script
to generate a Makefile appropriate for gcc??
I tried the following command line
$ make CC=gcc
This list is for discussing problems and issues involving database access
via Perl. I am reasonably sure you found Tim's address in the same context.
Your friendly local DBA should be able to help you resolve TNS errors.
--
Mac :})
** I normally forward private database questions to the DBI mail
I commented out the binds. So I just have:
$patient_title = $dbh->quote($patient_title);
print "HERE $patient_title\n";
$sth->execute($first_name, $last_name, $middle_initial, $patient_title,
$person_id);
By the way, the print types HERE NULL.
Sherry Graham
Sorry, major oversight in my haste:
Using Oracle 8.0.6
Platform:
osname=solaris, osvers=2.7, archname=sun4-solaris
uname='sunos sun05 5.7 generic_106541-07 sun4u sparc
sunw,ultra-enterprise '
hint=recommended, useposix=true, d_sigaction=define
bincompat3=n useperlio=undef d_sfi
"M.W. Koskamp" wrote:
> Sounds logical. undef would be translated to the keyword NULL.
> Quoting that would give NULL.
> What exactly do yuo mean by a core dump.
> Dit the script die with a DBI error message, or did the process core dump?
> Does the field patient title allow null values?
>
> M
Kind folks,
I have looked in the archives, and although I have found some (older)
similar descriptions of my problem, I have found no responses that appear to
be solutions.
Below is included a snippet of an attempt to install DBD::Oracle 1.06.
Starting out with 'perl Makefile.PL' I get the outp
- Original Message -
From: Sherry Graham <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, May 08, 2001 8:55 PM
Subject: Re: Use of Null
> The problem with using the execute to call the variables, is that the last
one
>
> is bind_param_inout. I don't know of a way to tell the
The problem with using the execute to call the variables, is that the last one
is bind_param_inout. I don't know of a way to tell the execute call that it
needs to put a value in that parameter.
But, just for testing sake, I put all the variables in the execute. I did
$patient_title = $dbh->q
On Tue, May 08, 2001 at 01:35:17PM -0400, Richard Lytle wrote:
> Hi,
>
> I am able to prepare a select query to an Ingress database requesting
> multiple column values from 1 table where a column value matches a
> variable value, ie,"my $sth->prepare("SELECT p.fname, p.lname, p.dob,
> p.sex, p.id
Hi,
I am able to prepare a select query to an Ingress database requesting
multiple column values from 1 table where a column value matches a
variable value, ie,"my $sth->prepare("SELECT p.fname, p.lname, p.dob,
p.sex, p.idnum FROM emppid p WHERE p.idnum=$idnum"). This query works.
When I try to
In the docs shouldn't this be changed...
***
If `PrintError' is also on, then the
`PrintError' is done before the `RaiseError'
***
to
***
If `PrintError' is also on, then the
`PrintError' is done before the `RaiseError'
though 'RaiseError' will override 'Pr
Got it, thanks.
Ilya Sterin
-Original Message-
From: Tim Bunce
To: Sterin, Ilya
Cc: 'Tim Bunce '; ''Neil Lunn ' '; '''[EMAIL PROTECTED]' ' '
Sent: 05/08/2001 10:40 AM
Subject: Re: executing atomic transactions in DBI
On Tue, May 08, 2001 at 08:26:43AM -0600, Sterin, Ilya wrote:
> Here a
On Tue, May 08, 2001 at 08:26:43AM -0600, Sterin, Ilya wrote:
> Here are the quotes from the docs regarding PrintError
>
>
>
> PrintError' (boolean, inherited)
> This attribute can be used to force
> errors to generate warnings (using `warn')
> in addition
I am using DBD::ASAny. I am calling a stored procedure to insert rows
into a table. Some of the parameters that I want to pass might have null
in them, but I am having trouble using a variable and place holder that
has the value undef. It keeps core dumping. Here is the code that I'm
working wi
On Tue, May 08, 2001 at 05:01:28PM +0300, LIBASOV IOANNIS wrote:
> I'm realy sorry about that.
> I received the reply seying that my message could not be delevered ("Mailbox
> is full" or something like that) and resent the message once again.
FYI, those come from subscribers with broken email sy
oops should have read all of it first
-Original Message-
From: Masocol, Raymond [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 12:20 PM
To: 'Mamadou Lamine Diatta'; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: make DBI problems
Hi,
if you look at your output it states yo
Hi,
if you look at your output it states you don't have enough space.
regards
Ray
-Original Message-
From: Mamadou Lamine Diatta [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 12:12 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: make DBI problems
Dear all,
I am having p
Dear all,
I am having problems installing DBI and I need help. Here is the output
of the command I have run so far.
Lamine Diatta
lamine-[root] /PERL-DBI/DBI-1.15: hostname
lamine
lamine-[root] /PERL-DBI/DBI-1.15:uname -a
SunOS lamine 5.6 Generic_105181-05 sun4u sparc SUNW,Ultra-60
lamine-[roo
Why do you have you error checking disabled. Send the whole script so that
I can duplicate on my system.
Ilya Sterin
-Original Message-
From: LIBASOV IOANNIS
To: [EMAIL PROTECTED]
Sent: 05/08/2001 5:25 AM
Subject: Fw: quoting binaries (MYSQL)
I misstyped something trying to make the me
Many thanks your helpful replies Gregory, Sikkandar, and Philip!
--
SeanC
Here are the quotes from the docs regarding PrintError
The `AutoCommit' and `PrintError' attributes
for each connection default to "on".
(See the AutoCommit and PrintError
entries elsewhere in this document
for more information.) However, it i
> I'm installing ensembl software from the EBI onto a unix server. It
> requires amongst other things a database, perl, the bioperl package,
the
> DBI and a driver for talking to the database.
> OK so i've got mysql installed as well as perl 5.6.0 and bioperl
0.6.2.
> The DBI is downloaded and in
On Tue, May 08, 2001 at 07:16:37AM -0600, Sterin, Ilya wrote:
> Thanks a lot, Neil. Finally a "make sense" answer. Thus, know I can see
> why the script was not failing within eval (due to PrintError being on). It
> is quoted in the docs and my fault for overlooking it. Definitelly when we
> a
I'm realy sorry about that.
I received the reply seying that my message could not be delevered ("Mailbox
is full" or something like that) and resent the message once again.
Sorry
- Original Message -
From: "Neil Lunn" <[EMAIL PROTECTED]>
To: "'LIBASOV IOANNIS'" <[EMAIL PROTECTED]>; <[
- Forwarded message from L RAMESH <[EMAIL PROTECTED]> -
Original-Received: from 204.68.23.39 by nwcst294
for [202.9.188.136] via web-mailer(34FM.0700.17C.01) on Tue
May 8 12:13:24 GMT 2001
PP-warning: Illegal Received field on preceding line
Date: 8
Thanks a lot, Neil. Finally a "make sense" answer. Thus, know I can see
why the script was not failing within eval (due to PrintError being on). It
is quoted in the docs and my fault for overlooking it. Definitelly when we
answer questions on this list we mostly tell people to turn their Raise
What do you think you are doing? I've recieved this same mail three times
already, do you really expect that this will prompt someone to help faster?
Talk about poking an aligator with a stick!
Perhaps if you told people what exactly is different about your "binary
field" output, (And waited pait
I misstyped something trying to make the message shorter.
New piece of code below is "copy and paste".
The variable $filecontent is printed into the file then, which I compared
with another file created by mysqldump.
About placeholders, it is good idea but it won't change the output.
(DBI vers
On 8 May 2001, at 11:45, Sean Carte wrote:
> Is it possible to fetch the names of all columns in a table?
First, prepare a statement that will select all columns from that table:
$sth = $dbh->prepare('select * from blurfle');
Next, you may have to execute the handle. (Whether this is neces
You can do a DESC command in SQL, although most interfaces also provide
a specific way of doing this.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 08 May 2001 10:45
> To: [EMAIL PROTECTED]
> Subject: Fetching Column Names
>
>
> Is it possible to fet
Is it possible to fetch the names of all columns in a table? How
about all tables in a database?
--
My brain hurts!
SeanC
Mediatek Training Institute
26 Crart Ave., Berea, Durban, South Africa
phone: +27 (0)31 202 1886 [EMAIL PROTECTED]
f
I misstyped something trying to make the message shorter.
New piece of code below is "copy and paste".
The variable $filecontent is printed into the file then, which I compared
with another file created by mysqldump.
About placeholders, it is good idea but it won't change the output.
(DBI v
Are you sure that it wont fetch anymore data than
65535?
I've just read 86Mb of LONG RAW using DBD 1.06
compiled with the OCI7 drivers.
If I try to use the OCI8 drivers and set LongReadLen
to anything greater than 12Mb I get a core dump.
Cheers,
Simon.
--- "Sterin, Ilya" <[EMAIL PROTECTED]>
I tried DBI 1.14 and DBI 1.13 with the same error when
trying to retrieve more than 12Mb of data.
What I'm confused about is why this works when I
compile DBD with the OCI 7 libraries? According to
Ilya, LongReadLen is 65535 max and wont read anymore
data. Yet I have just read 86Mb using the sa
Hi Jonathan & Mark
Thanks very much for your replies. I initially tried Marks suggestion and it worked
fine, I'll give Jonathans code a test too.
I couldn't find anything in the DBI or DBD::Informix documentation, hence my query to
the dbi-users group.
Jonathan; a very good point about the em
I misstyped something trying to make the message shorter.
New piece of code below is "copy and paste".
The variable $filecontent is printed into the file then, which I compared
with another file created by mysqldump.
(DBI version is 1.13)
(
PrintError => 0,
RaiseErro
56 matches
Mail list logo
