Date sent: Mon, 14 May 2001 11:42:49 +0300 (EEST)
From: Nick Chirca [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject:RE: basic stuff
Nick, I cannot answer the complete question (especially that STDIN
stuff, but
When I am
hello all,
i'm looking for a DBD CSV basic example with two tables involved in a join.
Is this possible and if so can you provide a basic example..
many thanks
Pete
Hello All,
I need to connect to a Oracle DB that resides in another server.
When the script runs from within the server it connects to the DB, but if I
try to connect runnig the script from my machine I keep getting the
following error:
( DBD:login failed, check ORACLE_HOME/bin is on your
That's because the ORACLE_HOME on you machine is not set. Also make sure
you have the SID defined in tnsnames.ora.
Ilya Sterin
-Original Message-
From: Julio Santiago
To: [EMAIL PROTECTED]
Sent: 05/14/2001 9:37 AM
Subject: DB Connection
Hello All,
I need to connect to a Oracle DB
We've noticed this here ... You can fix this temporarily by typing or
setting
'set ORACLE_HOME=path' or in the system environment.
-Original Message-
From: Julio Santiago [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 10:38 AM
To: [EMAIL PROTECTED]
Subject: DB Connection
Ilya, Jones
The server is on another network, when do I tell the script the address of
the server.
I have the Oracle_Home PATH in the profile file of the user I am connecting
with. Also I use: $ENV{ORACLE_HOME} = /oracle8/bin;
Do I have to define a DNS on my local machine?
From: Julio
Hi,
currently I've problems using DBD::Proxy with AutoCommit set to off.
$dbh-commit is ignored completely, but $dbh-rollback works.
This little script reproduces the behaviour:
--snip--
#!/usr/local/bin/perl
use strict;
use DBI;
use Data::Dumper;
main: {
my $source;
$source
Not sure what you mean exactly, but you can very easily do this
programmatically having all the data in your fetch() and you can loop inside
a loop as many times as you want.
If you mean that when something is returned by a query, you want to loop
through the rows, you easily accomplish this with
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 :
$sql = (SELECT idaffilie, idmonaie FROM user WHERE (session = .
$dbh-quote($sys{'session'}). ) AND (time '. ( time() - (60 * 60 * 12) ). ')
LIMIT 1);
print $sql.
DBD::Sybase implements multiple result sets with a driver-specific
attribute (syb_more_results). Maybe DB2 has the same thing?
Michael
Sterin, Ilya writes:
Not sure what you mean exactly, but you can very easily do this
programmatically having all the data in your fetch() and you can loop
The address of the remote server should be associated with your server name.
This will be stored in the tnsnames.ora file in your Oracle directory with
the IP address, port information, and database name.
-Original Message-
From: Julio Santiago [mailto:[EMAIL PROTECTED]]
Sent:
The server is on another network, when do I tell the script the address of
the server.
Easiest is to set up an entry in the tnsnames.ora file.
Looks something like this
realdb =
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=202.XXX.XXX.XXX)(PORT=1521))
Hi,
I have an oracle column with an autoincrement. I was wondering how I can
retrieve the last incremented id so that I can use it as a forign key in
another update. There is a special function for this in Mysql... does oracle
have something similar?
Kind regards,
Nico.
- 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 :
$sql =
Peter Gibbons wrote:
hello all,
i'm looking for a DBD CSV basic example with two tables involved in a join.
Is this possible and if so can you provide a basic example..
many thanks
Pete
DBD::CSV doesn't support SQL join statements, but it's possible to fake
them by combining two
- 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: M.W. Koskamp
To: Nicolas
-Original Message-
From: M.W. Koskamp
To: Sterin, Ilya; 'Nicolas JOURDEN '; [EMAIL PROTECTED]
Sent: 05/14/2001 11:22 AM
Subject: Re: A strange error ?
- Original Message -
From: Sterin, Ilya [EMAIL PROTECTED]
To: 'M.W. Koskamp ' [EMAIL PROTECTED]; 'Nicolas JOURDEN '
[EMAIL
Hi Keith, the DBI spec doesn't address stored procs that return multiple
result sets. Some DBDs have added driver specific methods to support this
unfortunately DBD::DB2 does not yet have this support. I will add it in
the next version.
Regards,
Robert
Keith E. Junker [EMAIL
- 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: M.W. Koskamp
To: Sterin,
You need to have at least SQL*Net installed in your client machine. The
ORACLE_HOME it resides in on the local machine is what should be in the
environment variable.
The name you use to connect to the database should be in your local
TNSNames.ora file. Your local DBA can help you set it up.
--
If your DBD supports placeholders, you should use them.
If it does not, you should use $dbh-quote() on strings to make sure they
are properly quoted and escaped.
Just putting quotes (' or ) in the statement doesn't properly take care of
data containing those quotes.
--
Mac :})
** I normally
It's also available in DBD::ODBC (for ODBC drivers that support it)
using the driver-specific attribute odbc_more_results. It may not be
in the docs for DBD::ODBC yet, though. If you're connecting to DB2 on
a Win32 box, this may work if DBD::DB2 doesn't support it (assuming DB2
itself supports
Hi,
How can i Get my mail by web,I have pop and smtp servers working .And can get mail
by clients (outlook+netscape) but can't access my mail by browser.Any body have perl
scripts OR guide me on that.
thanks in advace
atif munir
SatNet
execute() again.
Ilya Sterin
-Original Message-
From: Jonas Askås
To: dbi-users
Sent: 05/14/2001 2:40 PM
Subject: fetchrow_hashref
Hi,
Sorry to bother you with an (maybe) easy question, but I don't now how
to
do...
I want to to this:
$SQL = SELECT * FROM members;
my $sth =
Instead of fetching again, setup a hash of hashes and populate it on the
first fetch... then it's right there for you the second time
around... depending on the amount of data and how many times you need to
use the same data set, it could save you more time than reexecuting and
refetching.
- 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 strange error ?
It might be becasue $sys{'session'} is a number. You can
Jonas Askås wrote:
I want to to this:
$SQL = SELECT * FROM members;
my $sth = $dbh-prepare($SQL);
$sth-execute;
my $record_hash;
while ($record_hash = $sth-fetchrow_hashref){
print $record_hash-{first_name} $record_hash-{last_name}\n;
}
Then I want to search the $sth again, and
I guess that should be the next recommendation, print to the STDOUT and then
check if that query runs in sqlplus. Something might be happening to one of
the values where it is not interpolating into your sql string as expected,
might be just an overlooked error somewhere.
Ilya Sterin
Good evening,
I have been struggeling with oracle selects all day am getting some strange
results.
I can't seem to find out what is wrong with the following script:
#!/usr/bin/perl -w
use strict;
use DBI;
# Connect to the database
my $dbh = DBI-connect( 'dbi:Oracle:mercury.systime',
I am new at using DBI. I would like to have a form that order data can be entered in,
and when submitted the user will be given a reference number from the database. The
reference number is set-up as a sequence in the PostgreSQL database. How can I pull
this field after the data is
At 11:54 PM +0200 5/14/01, Nico van Leeuwen wrote:
Good evening,
I have been struggeling with oracle selects all day am getting some strange
results.
I can't seem to find out what is wrong with the following script:
#!/usr/bin/perl -w
use strict;
use DBI;
# Connect to the database
my $dbh =
On 14 May 2001, at 15:00, JACOB PETRIE wrote:
I am new at using DBI. I would like to have a form that order data
can be entered in, and when submitted the user will be given a
reference number from the database. The reference number is set-up as
a sequence in the PostgreSQL database. How
Well you did't say what the error was. Try this and at least you should get
an error that tells you something about why connect is failing.
use DBI; my $dsn = 'DBI:mysql:my_database:localhost';
my $db_user_name = 'admin';
my $db_password = 'secret';
my $dbh = DBI-connect($dsn, $db_user_name,
-Original Message-
From: Richard Castrios [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 3:14 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: Problems installing DBI on HP-UX 11.0 w/Perl 5.6.1
Hello,
I am getting the following error message when trying
I'm trying to make DBI 1.15 on a new Sun Blade running Solaris 8.
which cc returns/usr/ucb/cc
but when I run make I get
cc -c -xO3 -xdepend -DVERSION=\1.15\ -DXS_VERSION=\1.15\ -KPIC -I/usc
/usr/ucb/cc: language optional software package not installed
*** Error code 1
make: Fatal error:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, May 14, 2001 at 01:14:24PM -0400, Richard Castrios wrote:
Hello,
I am getting the following error message when trying to run the Makefile.PL
when trying to install DBI 1.15 onto an HP-UX 11.0 systems.
$opt/perl5/bin/perl Makefile.PL
Hello,
I am getting the following error message when trying to run the Makefile.PL
when trying to install DBI 1.15 onto an HP-UX 11.0 systems.
$opt/perl5/bin/perl Makefile.PL
Can't locate ExtUtils/MakeMaker.pm in @INC (@INC contains: lib
/opt/perl5/lib/5.6.1/PA-RISC1.1 /opt/perl5/lib/5.6.1
Record update in the PAUSE modules database:
modid: [DBD::Multiplex]
statd: [a]
stats: [m] was [?]
statl: [p] was [?]
stati: [O] was [?]
statp: [?]
description: [Spreading database load across servers] was [Spreading database load
acrross servers]
Record update in the PAUSE modules database:
modid: [Tie::Quick]
statd: [i]
stats: [?]
statl: [?]
stati: [?]
statp: [?]
description: [Simple way to create ties]
userid: [P5P] was [TIMB]
chapterid: [ 6]
mlstatus: [list]
Data entered by Tim
Record update in the PAUSE modules database:
modid: [Opcode]
statd: [S]
stats: [u]
statl: [p]
stati: [f]
statp: [?]
description: [Disable named opcodes when compiling code]
userid: [P5P] was [TIMB]
chapterid: [ 2]
mlstatus: [list]
Data
40 matches
Mail list logo