I am new to this list so forgive me if this has been discussed;
I am trying to get Oracle DBI running on Solaris 2.7. My environment
is:
perl 5.6.0
DBI-1.14
DBD-1.06
I compiled perl and the modules with the /opt/SUNWspro/bin/cc compiler
and strictly default options (it did not complain).
This
On Fri, 23 Feb 2001 01:48:07 -, "David Jacobowitz"
<[EMAIL PROTECTED]> wrote:
David,
Wouldn't this work:
while ($ref = $sth->fetchrow_hashref) {
foreach $key (keys %{$ref}) {
print $key-- $ref->{$key}, ;
}
>>Spend few hours trying to figureout a way to print my fiel
Hi All,
Spend few hours trying to figureout a way to print my field name with the
returned field value without any success. Looked in the websites but no
clue. Below is my code can anyone modify the code so it will print
field_name_in_mysql_table and field_values that is in mysql? I have 5
Hi.
- Original Message -
From: "Juan Terrazas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 7:16 AM
Subject: Can't install DBI
> Hi All,
>
> I got a new machine so I've been trying to install DBI v 1.13 after
> installing Active Perl v5.6.0 on Windows 20
Woops, ignore the last reply. Should of though about it before answering.
Ilya Sterin
-Original Message-
From: Robert Grant
To: [EMAIL PROTECTED]
Sent: 02/22/2001 3:27 PM
Subject: Getting 'csv' data from a stream?
Hi everybody
Can DBD::CSV read its data from an IO stream rather than a
Not sure but *STDIN = *FILE
would do it.
Ilya Sterin
-Original Message-
From: Robert Grant
To: [EMAIL PROTECTED]
Sent: 02/22/2001 3:27 PM
Subject: Getting 'csv' data from a stream?
Hi everybody
Can DBD::CSV read its data from an IO stream rather than always reading
it from a flat file?
Dear Tom
Thanks for your reply.
I didn't phrase my question very well: I am using DBD:ADO without any
serious problems (having switched my code from ODBC).
I was hoping to get advice on where to look for information on the ADO
specfic methods mentioned in the O'Reilly 'Programming the Perl DBI'
Hi everybody
Can DBD::CSV read its data from an IO stream rather than always reading
it from a flat file?
Thanks
Bob Grant
Robert Grant wrote:
>
> Is it possible to have DBD:CSV ignore comment lines and blank lines
> within the 'csv' file?
>
> For example,
> --
> #Comments
> #Comments
> Field1,Field2
> data1,data2
Well DBD::CSV (or DBD::AnyData) won't ignore the comments, but you can
use those DBDs
Hi All,
I got a new machine so I've been trying to install DBI v 1.13 after
installing Active Perl v5.6.0 on Windows 2000. I get the following :
.
..
...
DBI.c
DBIXS.h(403) : warning C4005: 'DBIS' : macro redefinition
DBIXS.h(13) : see previous definition of 'DBIS'
DBI.xs(196) : warning C
> From: Hodgson Darin <[EMAIL PROTECTED]>
> Date: Thu, 22 Feb 2001 10:56:25 -0800
> Subject: "Solaris patch" message
>
> I was hoping to get a little help/advice with a strange error message I am receiving
>while
> running a perl script containing DBI calls. The error message is: "You must ins
Hi everybody,
Is it possible to have DBD:CSV ignore comment lines and blank lines
within the 'csv' file?
For example,
--
#Comments
#Comments
Field1,Field2
data1,data2
data1,data2
--
Thanks for the help,
Bob Grant
I missed the link:
"A great many references for the Perl DBI can be found on the Hermetica Web
Server. "
on the DBI sign up page
http://www.fugue.com/dbi/
I don't think that is very clear way to point new users to the archives.
> -Original Message-
> From: Tim Harsch [mailto:[EMAIL PROTE
it is with the DBD::Oracle distribution that you downloaded.
I also didn't know how to find the archives since the list has undergone
some changes. So I started at www.perl.org and came accross the mail list
sign up page. There was no link there and some web errors so I reported
them to the adm
I also forgot to mention that I'm attempting this install on HP/UX 11.0.
Thanks
Jim
Sorry all, here's the output of my make test.
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
-I/opt/perl55/lib/5.00503/PA-RISC2.0-thread -I/opt/perl55/lib/5.00503 -e 'use
Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/base../usr/lib/dld.sl:
James,
Please post the output of your make session before trying to fix some
problems with it by editing the source. It's true some system
configurations cause problems with the installs, but you should figure it
what the problem is first. I think someone here would be able to help if
yo
Sorry, another correction to my message
The dsn was dsn=dbi:Oracle:db7 not db7.
James,
I just installed DBD::Oracle today on Solaris 7 with perl 5.6.0 and DBI-1.14
Perhaps, the make test is failing because you haven't added the following to your
.cshrc file:
setenv ORACLE_USERID usr/pwd
I also encountered a problem when using an older version of gcc that doesn't support
th
Sorry, ignore port number differences in my prevois message;
they were the same. I've just tried a number of configurations.
Hey all, I had this problem once before and someone gave me the right answer. I
have built, tested and installed perl5.005_03. I have built, tested and
installed DBI-1.14. I have built dbd-oracle-1.03 successfully, but it fails the
make test. If I try to make install, it lets me, but my perl d
Hello:
I have a simple select query the works fine using DBD::Oracle
No bind_columns or params ...
$dbh = DBI->connect("dbi:Oracle:db7", "aname", "apasswd") or die;
my $sql = "SELECT STUFF, OTHERSTUFF from STUFF_TABLE";
my $sth = $dbh->prepare( $sql );
$sth->execute();
etc ...
However when I tr
Did you compile your DBD::Oracle with OCI 8 if not you need to recompile or
use blob_read or readblob technique. See reame.longs in the DBD::Oracle
package.
Ilya Sterin
-Original Message-
From: Manish Grewal
To: [EMAIL PROTECTED]
Sent: 02/22/2001 9:36 AM
Subject: Reading from LONG RAW
- Forwarded message from Sergio <[EMAIL PROTECTED]> -
From: Sergio <[EMAIL PROTECTED]>
To: "Tim.Bunce" <[EMAIL PROTECTED]>
Subject: what is dbi
Date: Thu, 22 Feb 2001 11:53:00 +0100
X-SLUIDL: 5AA16D41-03F111D5-99CD0050-BAC80786
Hello I was reading the forum of select for update.. and I s
I´ve already intalled the DBI and DBD for Oracle.
When I use the command " USE DBI " in my script occurs an error
The system doesn´t find the dynamic link to PerlCRT.dll in the path
Error:Can´t load C:/Perl/site/lib/auto/DBI/DBI.dll for module DBI: load_file.
This error occurs at line 200 in c:/
See README.java
search these archives for "Solaris patch"
> -Original Message-
> From: Hodgson Darin [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 22, 2001 10:56 AM
> To: '[EMAIL PROTECTED]'
> Subject: "Solaris patch" message
>
>
> I was hoping to get a little help/advice with
I was hoping to get a little help/advice with a strange error message I am receiving
while running a perl script containing DBI calls. The error message is: "You must
install a Solaris patch to run this version of the Java runtime. Please see the README
and release notes for more information."
Thanks. Using a view works great and I learned a few new things this
morning!
-Jim
Simon Oliver wrote:
> Use the convert or format function of your underlying database.
>
> For example, in Access create a view like so:
>
> SELECT pdfs.id, Format(pdfs.date,"dd-mm-") AS formatted FROM pdfs;
>
> "Michelle" == Michelle Gerfort <[EMAIL PROTECTED]> writes:
Michelle> I'm having a problem when using fetchrow_array().
When I worry about NULLs in column, I find that using plain old
"fetch" lets me construct a much simpler outer loop. If I need to
grab individual elements later, or build
Any info on blob_read in dbi(if its there) would be welcome too
>Date: Thu, 22 Feb 2001 08:36:45 -0800
>To: [EMAIL PROTECTED]
>From: Manish Grewal <[EMAIL PROTECTED]>
>Subject: Reading from LONG RAW
>
>Hi,
>I'm getting the following DBI error from a select query
>the query is : select f1, f2 from
Hi,
I'm getting the following DBI error from a select query
the query is : select f1, f2 from t1 where f0=$id;
f1 is type varchar(2) and f2 is type LONGRAW
Error is:
Could not prepare sql statement.
Error No 01406: fetched column value was truncated
(DBD: ofetch error on field 2 (of 2), ora_type
Jim Clark writes:
> Is it possible to recieve back a customized date format
> instead of the stock 'dd/mm/'? I'm using Win2K and
> ADO/MDAC 2.6 and would like $pdate to have 'dd mmm yy'
> instead. I know that I can use Date::Manip but am looking
> for a cleaner approach.
You should be a
All jedi trainees bow the the Jedi master Simon.
Just abit off humour guys.
- Original Message -
From: "Michelle Gerfort" <[EMAIL PROTECTED]>
To: "Simon Oliver" <[EMAIL PROTECTED]>; "DBI-users"
<[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 3:55 PM
Subject: Re: Handeling undef data
This was exactly the solution to my problem
Thank you Simon! ;)
/Michelle
Simon Oliver wrote:
> hmm my mailer (crappy Netscape 6) seemed to screw up there - try this:
>
> if (defined $row[$i]) {
>if ($row[$i] ne "") {
> print $row[$i] . "\t";
>} else {
> print "Empty string i
I don't know. But doesn't eval then evaluate the whole @row?
It seems to me that @row could look like this:
(value1, value2, undef, value3, value4, undef) or something like that.
I then want to print:
value1value2undefined value in row value3value4 undefined
value in row
But in
hmm my mailer (crappy Netscape 6) seemed to screw up there - try this:
if (defined $row[$i]) {
if ($row[$i] ne "") {
print $row[$i] . "\t";
} else {
print "Empty string in row\t";
}
} else {
print "NULL value in row\t";
}
// or was it me, P is next to { on the keyboard! /
I'm thinking
if (!defined($row[$i]))
or what do the experts say.
- Original Message -
From: "Simon Oliver" <[EMAIL PROTECTED]>
To: "Michelle Gerfort" <[EMAIL PROTECTED]>
Cc: "DBI-users" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 3:40 PM
Subject: Re: Handeling undef data.
That would trap an error in the retrieval of the entire row. Not what
was asked for!
--
Simon
[EMAIL PROTECTED] wrote:
> Never tried it, but would wrapping the "fetchrow_array" in
> an 'eval' work?
>
> eval{ @row = $sth->fetchrow_array );
> if($EVAL_ERROR){ # Do whatever }
>
>
> -Or
> if ($row[$i] ne ""){
This tests for an empty string not an undefined value.
Try something like:
if (defined $row[$i]) {
if ($row[$i] ne "") {
print $row[$i] . "\t";
} else {
print "Empty string in row\t";
}
} else P
print "NULL value in row\t";
}
--
Never tried it, but would wrapping the "fetchrow_array" in
an 'eval' work?
eval{ @row = $sth->fetchrow_array );
if($EVAL_ERROR){ # Do whatever }
-Original Message-
From: Michelle Gerfort [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 7:13 AM
To: DBI-users
Subject: Handelin
i there!
I'm having a problem when using fetchrow_array().
The area of the code where the problem is, you find below.
while (@row = $sth->fetchrow_array() ) {
$len = @row;
for ($i = 0; $i < $len; $i++) {
if ($row[$i] ne ""){
print $row[$i] . "\t";
}
else{
print "undefined value in
Hi there!
I'm having a problem when using fetchrow_array().
The area of the code where the problem is, you find below.
while (@row = $sth->fetchrow_array() ) {
$len = @row;
for ($i = 0; $i < $len; $i++) {
if ($row[$i] ne ""){
print $row[$i] . "\t";
}
else{
print "undefined value i
"C. Duncan Hudson" wrote:
> Has anyone been able to sucessfully make DBI and DBD::MySQL work under OSX -
> Darwin? I'm not having any luck at all. I'm running Perl v5.6.0 built for
> darwin. And I'm trying to install the MySQL modules version 1.2215, with
> DBI version 1.14.0. My mysql datab
Use the convert or format function of your underlying database.
For example, in Access create a view like so:
SELECT pdfs.id, Format(pdfs.date,"dd-mm-") AS formatted FROM pdfs;
Then select this from your perlscript
Jim Clark wrote:
> Is it possible to recieve back a customized date form
For the record...the $sth->finish statement does NOT release the cursor
associated with the statement. A cursor is created by the "prepare" method
and is not released until the statement handle it creates goes out of scope
or is explicitly undefined. "Finish" releases the current "select list" o
oops, it was working because I reverted to an earlier version which
disconnects from the database after every 40 queries, not because of any
change between prepare and prepare_cached. So I guess I still have the
same problem.
-Eli
Eli wrote:
>
> We are doing something quite similar to your code
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Feb 21, 2001 at 11:16:01AM -0600, 'Elaine -HFB- Ashton' wrote:
> I wanted to share this since this spineless weinerhead mailed his invective
> privately as a side-swipe to someone who was merely trying to be helpful.
How kind of him. Perhap
Pascal,
Hereunder is an article I wrote some time ago, and which explains what you need, as
far as I can see.
Brgds,
Mark
PURPOSE
---
The purpose of this article is to show how Basic Authentication against
the database can be implemented in the Oracle HTTPD server.
SCOPE & APPLICATION
Hi,
I am working with Apache and I'd like to authentificate users accessing passworded
directories with a rdbms (I use both mysql and postgresql) rather than using text
files (htpasswd). So I downloaded Apache DBI module but now what is required? What
driver for mysql and for postgresql (DBD..
On 2001-02-21 08:30:46 -0500, Charnley, Chip (C.) wrote:
> That makes three of us. I have never been so disgusted with a list in my
> life. IMNSHO, the management of this list, since it was moved, SUCKS!
I am severly tempted to express my opinion of people who don't read
neither announcement mail
> From: Greg Trangmoe <[EMAIL PROTECTED]>
> Date: Wed, 21 Feb 2001 13:06:03 -0700
> Subject: DBI make error on missing header files..
>
> make - returned with 'could not find file' errors as shown in output below: I
>appreciate any
> help you can provide.
>
> cc -c -Dbool=char -DHAS_BOOL -I/
Is it possible to recieve back a customized date format
instead of the stock 'dd/mm/'? I'm using Win2K and
ADO/MDAC 2.6 and would like $pdate to have 'dd mmm yy'
instead. I know that I can use Date::Manip but am looking
for a cleaner approach.
Thanks.
-Jim
$sth = $dbh->prepare("
SELECT
>
> Selecting and inserting rows work fine, however when inserting records
with
> DBIx::Recordset -> Insert I get the following error:
> [1843]ERR: 32: Line 60: Warning in Perl code: DBD::Oracle::db do failed:
> ORA-00971: missing SET keyword (DBD ERROR: OCIStmtExecute) at
> usr/lib/perl5/site_per
My config:
Linux, Redhat 7.0
Oracle 8.1.6.0
Apache 1.3.17
Perl-5.6.0
mod_perl-1.25
HTML::Embperl 1.3.1
DBI-1.1.14
DBD-Oracle-1.06
ApacheDBI-0.88
DBIx-Recordset-0.23
Selecting and inserting rows work fine, however when inserting records with
DBIx::Recordset -> Insert
Please note that the "ALTER SESSION SET CURRENT_SCHEMA = ..." only changes
the way names are
resolved. That is: it changes the schema that will be searched by default.
It does not change in any way your privileges.
Mark
From: "Tony Foiani" <[EMAIL PROTECTED]>
To: "Tim Bunce" <[EMAIL PROTECTED]>
55 matches
Mail list logo
