>From: "Bogdan Lukasiewicz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
>I decided to evaluate PDK 5.0 and changed my MS Windows instalation of
ActivePerl 5.6 to version 5.8. In my work I have to have an access to Oracle
8i database, so I looked for DBD-Oracle >driver, but for ActivePerl 5.8 I
>
> Select email from order_info where name = 'Tim O'Reilly'
> DBD::CSV::db prepare failed: Mismatched single quote before: 'Reilly'
> Cannot prepare Select email from order_info where name = 'Tim O'Reilly':
> Mismatched single quote before: 'Reilly'
Did you try: where name = $dbh->quote("Tim O'
- Original Message -
From: xyl
To: [EMAIL PROTECTED]
Sent: Saturday, April 13, 2002 10:32 AM
Subject: question about DBI
>dear sir,
>i wrote a simple db.pl do some jobs with database. it works through "$perl
>db.pl". compiling it with perlcc, execute "$./db". the error is:
>Undefined s
DBD::Oracle
>Oracle's sqlplus determines what to use by whether or not TWO_TASK is set,
but the new-style >DBI->connect seems to want to force network connections
no matter what, regardless of >whether or not TWO_TASK is set, regardless of
whether the database is local or remote.
I dont have that
these errors:
>The error_log of the apache web server
>Printf() on closed filehandle JOE at insert.pl line 59.
>Printf() on closed filehandle JOE at insert.pl line 61.
>Printf() on closed filehandle JOE at insert.pl line 62.
>Printf() on closed filehandle JOE at insert.pl line 63.
>Printf() on c
> I have problem installing the DBI::Interbase in WIndows 2000. I have
downloaded the DBD-InterBase-0.28.4 and compiled with >nmake 1.5 but have
not happenned. Please see the attachment file and give me a consultation.
Thank you very much.
> A new DBI user.
> Nguyen Tran Quoc Vinh
- Original Message -
From: " Laurie Gennari" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 1:10 AM
Subject: occasional "doing rollback" error
> I've been staring at this for a while and am getting nowhere. Hope the
list can help...
>
> One of the guys is getti
- Original Message -
From: "Ido Trivizki" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 04, 2002 3:52 AM
Subject: as_string
>I would like to suggest an as_string function that would work like:
>$sth=$dbh->prepare('SELECT foo FROM bar WHERE baz=?');
>$sth->as_string(
- Original Message -
From: "Zhao, Charles" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 12, 2002 9:04 PM
Subject: Missing Expression Error ORA-00936
Hello all,
This may be a simple/old question for many of you, but I am new on dbi and
oracle, and somehow I just c
maybe $dbh->quote() will help you.
Maarten.
- Original Message -
From: "Morrison Davis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 29, 2002 5:33 AM
Subject: embedded single quotes
> Is there something with DBI that will help you deal with single quotes
> in the
> #__DATA___;
> # data looks like this, in flat file called dat.prn
> #Nov122, aq-xxx , ML, 33
> #Nov122, aq-xxx , ML, 33
> #Nov12 , aq-xxx , DK, 22
If this is literally what your data looks like, including the space between
can and the comma,
the $can will have a length of 7. (6 chars and a wh
You have to install the oracle client software first.
Then read the DBD::Oracle doc's. Then install DBD::Oracle.
Greetings,
Maarten
- Original Message -
From: "Spiros Alexiou" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 19, 2002 12:23 PM
Subject: Oracle Access
>
- Original Message -
From: "Leonardo Barbosa e Oliveira" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 14, 2002 6:58 PM
Subject: Anyone could send me oracle.mk?
>
> Dears Sirs,
>
> Please, I am trying to install DBD::oracle
> and in the compilation time it gives
- Original Message -
From: "Ronald J Kimball" <[EMAIL PROTECTED]>
To: "M.W. Koskamp" <[EMAIL PROTECTED]>
Cc: "Ronnie Anderson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 11, 2002 11:50 PM
Subject: Re: dbi and n
- Original Message -
From: "Ronnie Anderson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 11, 2002 8:36 PM
Subject: dbi and nulls
> my $hosthandler = $dbh->prepare(q{
> SELECT id
> FROM host
> WHERE tid = ?
> AND (domain = ? OR (? IS NULL AND domain IS NULL))
- Original Message -
From: "Sterin, Ilya" <[EMAIL PROTECTED]>
To: "'M.W. Koskamp '" <[EMAIL PROTECTED]>; "''Marius Keraitis ' '"
<[EMAIL PROTECTED]>; "''DBI Perl ' '" <[EMAIL PRO
- Original Message -
From: "Sterin, Ilya" <[EMAIL PROTECTED]>
To: "'Marius Keraitis '" <[EMAIL PROTECTED]>; "'DBI Perl '"
<[EMAIL PROTECTED]>
Sent: Friday, January 11, 2002 4:07 PM
Subject: RE: SELECT
> You would count as you itereate through the result set using a counter
var.
> You ca
- Original Message -
From: "nafiseh saberi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 10, 2002 11:25 AM
Subject: fetch
hi dear team.
I am not in your team...but I have one question :)
I am working with perl and postgres for writting
data base...
I want to fet
- Original Message -
From: "Mitch Helle-Morrissey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 04, 2002 6:18 PM
Subject: RE: mapping NULL values
> > Your problem is not a database problem, but a presentation problem.
> > So to keep things clean you should solve it
- Original Message -
From: "Mitch Helle-Morrissey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 04, 2002 5:22 PM
Subject: RE: mapping NULL values
> That is a good way to hide the warnings. Another reason that I'd like to
be
> able to specify what NULL comes out as
- Original Message -
From: "Sterin, Ilya" <[EMAIL PROTECTED]>
> Well, if someone can point me in the direction of where I can get an
Oracle
> client for windows 2000, that does not require a 400+ mb download and
> includes SQL NET, and OCI libs and the rest of stuff required to compile,
- Original Message -
From: "Becka Louden" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 15, 2001 10:00 PM
Subject: inserting into CLOB field
[...]
> my $result_ins = $insert_cr ->execute() || print "Insert into CRR table
> failed!!\n";
try this:
bind_param(1, $
[snip]> if ($row1 not "") {
> print "row not empty";
> } else {
> print "row is empty";
[snip]
> if ($row1 ne "") {
> print "row not empty";
> } else {
> print "row is empty";
> }
>
The if statements differ.
In the first if statement you have : ($row1 not "")
in the second you have : ($
- Original Message -
From: "Byron Wise" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 12, 2001 5:44 AM
Subject: Trouble connecting to Oracle!
> I need help!! I'm running Personal Oracle8i and
> ActiveState's perl on the same win98 machine. All I'm
> trying to
- Original Message -
From: "Karina Nahagama" <[EMAIL PROTECTED]>
To: "Sterin, Ilya" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "Duncan, Mike" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 9:35 AM
Subject: DBD::Oracle
> My name is Karina Nagahama,
> I want to
- Original Message -
From: Sterin, Ilya <[EMAIL PROTECTED]>
To: M.W. Koskamp <[EMAIL PROTECTED]>; ''Dr.Bernd Elpel ' '
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, July 21, 2001 6:36 AM
Subject: RE: Cannot install DBD::mysql
>
- Original Message -
From: Sterin, Ilya <[EMAIL PROTECTED]>
To: 'M.W. Koskamp ' <[EMAIL PROTECTED]>; ''Dr.Bernd Elpel ' '
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 11:43 PM
Subject: RE: Canno
- Original Message -
From: Sterin, Ilya <[EMAIL PROTECTED]>
To: 'M.W. Koskamp ' <[EMAIL PROTECTED]>; 'Dr.Bernd Elpel '
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 11:09 PM
Subject: RE: Cannot install DBD::mysql
> A
Hey, the quotation marks disappeared. Lets try again
- Original Message -
From: M.W. Koskamp <[EMAIL PROTECTED]>
To: Dr.Bernd Elpel <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 11:10 PM
Subject: Re: Cannot install DBD::mysql
>
>
- Original Message -
From: Dr.Bernd Elpel <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 3:22 PM
Subject: Cannot install DBD::mysql
On Win2k I did install perl (V. 5.6.0), DBI(1.18). So far ok.
But trying to install DBD::mysql (Msql-Mysql-modules-1.2216) let me
- Original Message -
From: Chabowski <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 17, 2001 5:37 PM
Subject: using DBI with Mason for first time
> Hi.
>
> I'm testing mason for the first time on our servers, and although mason
> itself is working, I can't seem to get i
- Original Message -
From: anshuman das <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 8:04 AM
Subject: Further progress::Can't locate objrect method "connect" via package
"DBI"
> As you told I am sending the log files of installation pr
>
> SYBASE::
> select 1 where exists
> ( select * from some_table where some_column = 'some_value')
>
> Anyway, it's obviously not as portable as any of the other methods, but
I'm
> just trying to brainstorm the possibilities of the best methods for an
> existence lookup.
Most portable is:
selec
Oops i forgot that you have debian.
So discard the remarks about Windows and Visual Studio..
- Original Message -
From: Victor <[EMAIL PROTECTED]>
To: Sterin, Ilya <[EMAIL PROTECTED]>
Cc: dbi-users <[EMAIL PROTECTED]>
Sent: Sunday, July 08, 2001 2:25 PM
Subject: Re: Oracle, perl & DBI under debian
(...)>
> Knowing that at office I have Oracle 8 servers under win NT, a
> databas
- Original Message -
From: Steve Howard <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, July 08, 2001 4:47 AM
Subject: RE: Checking for the existence of a certain row.
> OK, one more yes-no. I tried this for performance and as expected, it is
> faster than
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 23, 2001 9:09 AM
Subject: DBI using HTTP
> Hi gurus,
>
> I have this scrip as follow :
[...] print $sth->fetchrow();
>
> When i execute this from a server with a user "oracle", it works fine. But
- Original Message -
From: Richard Chen <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 17, 2001 9:26 PM
Subject: handling where condition for char(nnn) data types
[...]
$sth=$dbh->prepare('SELECT * FROM usr WHERE grp = ?) or die $!;
Small tip: it's no use to use
- Original Message -
From: Katja Sattler (EDS) <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 05, 2001 9:16 PM
Subject: Problem with DBD-Oracle-1.06
>
> > Hello !
> >
> > We are having a problem with the installation of DBD-Oracle-1.06 module.
> >
(...)> > <>
> >
> > D
- Original Message -
From: Mohammad Shoja <[EMAIL PROTECTED]>
To: dbi-users mailing list <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 4:14 PM
Subject: I need structure help!!!
> Hi folks,
> I am using dbi with mysql to develope a data access interface for my
> application,
> and also
- Original Message -
From: Dhananjay Javalkar <[EMAIL PROTECTED]>
To: Perl <[EMAIL PROTECTED]>
Sent: Saturday, May 19, 2001 1:14 PM
Subject: EXEC SQL
Hi ,
I am calling a function in C , which in turn calls an EXEC SQL block ,
Thru this I am calling an database function , which update
- Original Message -
From: Theja Rajakumar <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 10:34 PM
Subject: DBD error
> I've been getting this error while connecting to an Oracle database
> thro' DBI. and don't know what's happening.
> Can anybody help?
>
> ORA-
- Original Message -
From: VIDYASAGAR R NALLU <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 15, 2001 9:22 PM
Subject: Problem connecting to Oracle database
> Hi All,
>
> I'm trying to connect to Oracle database with DBD::Oracle but ended up
> with the following error me
- Original Message -
From: Williams Andy - anwill <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 15, 2001 4:50 PM
Subject: DBD::Oracle Intallation on Linux
> Hi,
>
> I'm trying to install DBD::Oracle (v 1.06) on RedHat 6.0.
> When I run make it complains of missing .h fi
- Original Message -
From: Jorge L. Allen <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 11:34 PM
Subject: Using perl to connec to ACCESS
>
> It is first time connecting to Microsoft Access, and I cannot even make a
> simple connection.
>
> The database is runni
- Original Message -
From: Sterin, Ilya <[EMAIL PROTECTED]>
To: 'M.W. Koskamp ' <[EMAIL PROTECTED]>; '''Nicolas JOURDEN ' ' '
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 8:00 PM
Subject: RE: A str
- Original Message -
From: Sterin, Ilya <[EMAIL PROTECTED]>
To: 'M.W. Koskamp ' <[EMAIL PROTECTED]>; ''Nicolas JOURDEN ' '
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 7:21 PM
Subject: RE: A strange error ?
- Original Message -
From: Sterin, Ilya <[EMAIL PROTECTED]>
To: 'M.W. Koskamp ' <[EMAIL PROTECTED]>; 'Nicolas JOURDEN '
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 7:03 PM
Subject: RE: A strange error ?
>
>
>
- Original Message -
From: Nicolas JOURDEN <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 6:10 PM
Subject: A strange error ?
> Hi,
>
>
> I've got a problem from my system and i can't understand whats' happen
> now it's verry strange and i'm verry tire so :
>
>
>
Search for Time-modules on CPAN.
- Original Message -
From: Dexter Coelho <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 12, 2001 9:52 PM
Subject: Simple question Perlsters-converting to unix time
> Perlsters,
>
> I remember seeing a a function timelocal that took a d
- Original Message -
From: Foskett Roger <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 10, 2001 12:38 PM
Subject: DBD::Oracle Makefile.PL problem
>
> Hi - not sure who to direct this at
>
> I've just had a build problem where 'nzt.h' and 'ociextp.h' were missing
> duri
- Original Message -
From: Mickey Mestel <[EMAIL PROTECTED]>
To: Dbi-Users@Perl. Org <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 9:58 PM
Subject: DBD:Oracle memory leak
> Oracle 8.1.7
>
> and the problem is back. my application runs forever as a daemon, and
> connects and disconn
- 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
- 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
Let's try some shorter code first so it is easier to find the error:
#!c:/perl/bin/perl
use CGI qw(:standard);
use DBI;
$ query= new CGI();
@tryarr=(3456,3457,3489,2723);
my $dbh= DBI->connect('DBI:ODBC:SCART','team','team') or
die " Sorry could not connect". DBI.errstr;
print $query->header(
>
> The problem: I've written a web site thinking that DBI and DBD were
> standard. Now I find they are not and the ISP will not load them for
> everyone to use :(. This is my first venture into PERL so I don't know
> what I'm doing.
>
> I need to load the DBD, DBI and CSV drivers into the web
- Original Message -
From: SELVARAJAN,DANESH K (Non-HP-PaloAlto,ex1)
<[EMAIL PROTECTED]>
To: 'Tim Bunce' <[EMAIL PROTECTED]>; Ken Speich <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, May 05, 2001 12:26 AM
Subject: RE: Prepare/Finish question
Hmm, I dont think you need to e
Ok, dropping in the middle of a conversation, but here are some tips.
> Here's some code, please note that sql statements have been truncated.
>
># use an array [ref] to hold all the statement handles and queries
> $sth = [];
> $sql = [];
Why use an array ref when storing only scalar
- Original Message -
From: Baranitharan Santhanagopalan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 26, 2001 8:32 AM
Subject: problems in inserting clob data using DBI Perl
>
> hello,
> im using DBI::VERSION 1.6 and DBD::ORACLE::VERSION 0.59 on perl
5.0005_05 un
- Original Message -
From: Andy Brick <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 24, 2001 12:13 PM
Subject: Re: Oracle Character Set problem
> Setting NLS_LANG to WE8ISO8859P1 or WE8MSWIN1252 stops me establishing a
> connection - DBI reports a login failure.
>
> S
- Original Message -
From: Steve Leibel <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 3:54 PM
Subject: $DBI::err values?
> How do I get a list of the error codes returned via $DBI::err for
> Mysql? I can't find anything in the Mysql docs, and strangely enough
>
> There is one issue left:
>
> When I try to use $sth->errstr, for example, from within my classes, I
> get a reference error.
>
> or croak "DB Error: $this->errstr\n";
>
> $sth->execute()
> or croak "DB Error: $sth->errstr\n";
> DB Error: MyDB::DB::st=HASH(0x82e78a0)->err
- Original Message -
From: Paul D. Smith <[EMAIL PROTECTED]>
To: M.W. Koskamp <[EMAIL PROTECTED]>
Cc: dbi-users <[EMAIL PROTECTED]>
Sent: Saturday, April 21, 2001 12:04 AM
Subject: Re: ISA inheritance vs. DBI?
> This is annoying; that's twice today I'v
- Original Message -
From: Paul D. Smith <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 20, 2001 5:56 PM
Subject: Re: ISA inheritance vs. DBI?
> %% "M.W. Koskamp" <[EMAIL PROTECTED]> writes:
>
> mwk> sub connect{
> mwk>
What folders did you make to put the files in?
They might also need to be in the root of your website, depends on what the
current directory is for scripts.
- Original Message -
From: Ian Hobson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 20, 2001 2:06 PM
Subject: H
- Original Message -
From: James Maes <[EMAIL PROTECTED]>
To: Paul D. Smith <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 11:48 PM
Subject: Re: ISA inheritance vs. DBI?
>
>
> connect
> {
>my($that) = shift;
>my $class = ref($that) || $that;
>my $
> > -Original Message-
> > From: Thirumalai, Radhika
> > Sent: Thursday, April 19, 2001 4:25 PM
> > To: '[EMAIL PROTECTED]'
> > Subject: DBIx::XML_RDB
> >
> > I'm trying to export data from a database to an XML file using
> > DBIx::XML_RDB module.
> > When I execute the code below, i get
- Original Message -
From: Xiaoxia Dong <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 17, 2001 10:47 PM
Subject: update multi row when i meant update single row
> Dear all:
>
> I tried to update a single row for the database, however, the query here
> update multipl
>
> ***
> full script...
> **
> #!d:/perl/bin/perl.exe -w
> print "Content-type: text/html\r\n\r\n";
> use CGI;
> use DBI;
> use DBD::Oracle;
>
> print " test1 ";
> print " test2 ";
>
> %attr = (
> PrintError => 0,
> RaiseError => 1
> );
>
> print " test3 ";
> $dbh = DBI->connect
> my $success = $sth->execute($sk);
> > my ($user, $session) = $sth->fetchrow_array || &error('SQL',
$sth->errstr);
>
>
> > == end snip ==
> >
> > In that way only the scalar $user was set and contained the value of
> > "session" from the databas
- Original Message -
From: Tim Bunce <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 5:27 PM
Subject: (Fwd) BUG in Module DBI?
> - Forwarded message from Jens Ott <[EMAIL PROTECTED]> -
>
> X-Authentication-Warning: hamilton.bonn-e
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 7:52 AM
Subject: Oracle-DBI-Win2k-Apache
> Have a test which executes & fine on command line but
> same script stops @ connect line when run as cgi
> via browser.
72 matches
Mail list logo
