;timeout=240, opns,
flights)
or die (Cannot connect: DBI::errstr);
Looks like you are trying to connect to database fights -
shouldn't that be flights?
HTH.
Hardy Merrill
On 11/4/2005 at 3:03 PM, [EMAIL PROTECTED] wrote:
I am using SYBASE ASE 12_2, Perl5.8.5, DBI-1.48 and I just loaded
DBD
document you
need to write out the Content-type line and then a blank
line and then you can start your html tag, like this
Content-type: text/html
html
head
titleThis is the Title of My Document/title
/head
body
your content goes here
/body
/html
HTH.
Hardy Merrill
On 12/8/2006 at 1:33 AM
to_char if you want to pull a DATE column out of
the database into a string (scalar) variable.
HTH.
Hardy Merrill
Robert Hicks [EMAIL PROTECTED] 10/17/2006 8:32 PM
Garrett, Philip (MAN-Corporate) wrote:
Robert Hicks wrote:
Any gotchas there? I am opening an Access db via ODBC and binding
.
Hope this helps.
Hardy Merrill
Rashid, Mohammad M, NTWOP [EMAIL PROTECTED] 5/12/2006 3:34 PM
Hi:
Any help in this matter would be greatly appreciated.
We have a HP cluster that has per, perl DBI, and oracle.
Machine A runs fine.
When we fail over to Machine B, on some applications we get
the facts
here but it's at least worth a look at the DBI docs - look up trace.
HTH.
Hardy Merrill
Martin J. Evans [EMAIL PROTECTED] 4/13/2006 10:08:12 AM
- Forwarded message from Tomas Karlsson [EMAIL PROTECTED] -
I would like to suggest a new feature/function in DBI. It would really
Sorry for the OT response but I couldn't let this go.
Anna K's fame has faded?? She still has a few fans :)
Ron, if you have any influence at the Australian Open, next year
try to get them to sign a tv contract with ABC, NBC, or CBS - instead
of ESPN2 which I don't get. Thanks.
Hardy Merrill
I'm not being wise here, but did you do
use DBI;
at the top of your script?
Hardy Merrill
Christian Stalp [EMAIL PROTECTED] 1/23/2006 11:57 AM
I tried this:
my $dbh = DBI-connect(dbi:Pg:database=test2;host=127.0.01;port=5432,
postgres) or die $DBI:errstr;
test2 is the name
.
Are there some web hosting companies that offer Perl and Postgres?
TIA.
Hardy Merrill
The DBD::Oracle perl module documentation has this
http://search.cpan.org/dist/DBD-Oracle/Oracle.pm#PL/SQL_Examples
HTH.
Hardy Merrill
logesh kumar [EMAIL PROTECTED] 11/9/2005 6:36 AM
Hi all,
Can anybody tell me how to execute a PL/SQL package from Perl through
a small
to get
the value of the sequence nextval, but with this approach you don't need
to use the dbi last_insert_id.
Hardy Merrill
Gaul, Ken [EMAIL PROTECTED] 10/6/2005 9:00 AM
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: 06 October 2005 11:30
To: List - DBI users
Subject
PostgreSQL's authentication can be rather tricky
to get working right.
Hardy Merrill
Mason Loring Bliss [EMAIL PROTECTED] 9/12/2005 12:40:35 PM
On Mon, Sep 12, 2005 at 12:14:07PM -0400, Mason Loring Bliss wrote:
I can connect to the database using $dsn directly, and I can connect
using
psql
Use placeholders - all your quoting issues will go away.
Read about them by doing
perldoc DBI
at a command prompt and searching for Placeholders.
HTH.
Hardy Merrill
Ron Stephan [EMAIL PROTECTED] 3/31/2005 1:52 PM
Help --
I am lost trying figure out what occurs to me a really simple
Just in case it's not clear to you, the placeholders are the question
marks in the VALUES part of the sql ;-)
Ronald J Kimball [EMAIL PROTECTED] 3/31/2005 2:36 PM
Ron Stephan [mailto:[EMAIL PROTECTED] wrote:
Placeholders?
Like how?
Here's a quick example:
my $sth =
Message-
From: Hardy Merrill [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 31, 2005 2:11 PM
To: [EMAIL PROTECTED]; dbi-users@perl.org
Subject: Re: string help!
Use placeholders - all your quoting issues will go away.
Read about them by doing
perldoc DBI
at a command prompt and searching
in the format:
hh.mm.ss.zz.
HTH.
Hardy Merrill
[EMAIL PROTECTED] 03/23/05 11:21 PM
I am having a problem using the Perl DBD::DB2 module to enter a
'TimeStamp'
value into a DB2 table. I have been able to write a perl script which
can
enter an 'integer' or 'varchar' value into a DB2 table
, and
Perl Cookbook - all O'Reilly books.
HTH.
Hardy Merrill
Greg Armer [EMAIL PROTECTED] 03/15/05 5:28 AM
On Mon, 2005-03-14 at 20:55 -0800, venkatesh shapur wrote:
I want know about the deatails of the how to use DBI connectivity in
perl language with MySQL
database.And for the datails
. If
that doesn't work, the client will give you some kind of SQL error, so
you
know your problem is with the SQL.
I'm wondering if the UPDATE is actually happening. See if you can
find
a way to test that UPDATE not using Perl / DBI / DBD::ODBC.
HTH.
Hardy Merrill
Moreno, Javier [EMAIL PROTECTED] 03/10
be executed twice.
Hardy Merrill
Moreno, Javier [EMAIL PROTECTED] 03/11/05 12:11 PM
Ok. So I moved away from the UPDATE and now I am running a stored
procedure. When I look at the trace, the stored procedure runs exactly
as expected, however, it then runs a second time and screws things up.
You can
with criteria $criteria);
} else {
my $rc = $sth-execute ($::lang_code) or
Error(Unable to execute statement,
$sql);
}
HTH.
Hardy Merrill
Moreno, Javier [EMAIL PROTECTED] 03/10/05 10:10 AM
Hi all,
I have a script that writes a single record
and search for trace. Start using a low
number like 1, and if you don't get enough detail, try 2,
etc.
But 1 should be good to start with.
HTH.
Hardy Merrill
Moreno, Javier [EMAIL PROTECTED] 03/10/05 12:29 PM
Actually it is now getting worse. It has AutoCommit set to 0 so I am
doing
years since I've used it so
I'm not going to attempt to explain it as it is quite involved.
If you're interested, google for DBI Proxy and I'm sure you'll
find everything you need.
HTH.
Hardy Merrill
Gokul P. Nair [EMAIL PROTECTED] 03/04/05 12:48 PM
Thanks very much for ur response, i have one
with that site?
HTH.
Hardy Merrill
Reidy, Ron [EMAIL PROTECTED] 02/24/05 8:55 AM
Wrap your calls in an eval block.
$dbh = DBI-connect(...);
eval {
$sth = $sbh-prepare(select * from mytable);
$sth-execute;
...
};
if ($@) { # an error occured
print $@;
# other actions
}
--
Ron Reidy
Lead
and error handling in the excellent DBI
perldocs by doing
perldoc DBI
at a command prompt.
HTH.
Hardy Merrill
Reidy, Ron [EMAIL PROTECTED] 02/11/05 9:14 AM
There are so many ways to do this. Below is a PL/SQL way:
#
# not tested
#
my $sth = $dbi-prepare(qq{
BEGIN
FOR d
I'm no database expert (I'm probably way off here), but doesn't that
need to be more like this:
INSERT INTO district2
SELECT employee_id, ...
FROM district1
And, that still doesn't address the issue of duplicate employee id's.
I think to address that problem you'd have to define a
here ###
}
HTH.
Hardy Merrill
Mark Martin [EMAIL PROTECTED] 01/28/05 7:58 AM
Hi,
I'm running a test to see whether certain criteria in a SELECT
statement
return record or not. If I get a no rows selected from SQL then I
want to
perform a specific action . But I don't how perform the test
message
- post the code that you tried
- post the error that you got
If you do these things then people will be happy to help you. But we
have to know that you've at least read the documentation and tried what
the documentation suggests.
HTH.
Hardy Merrill
Michael A Chase tech
Hi Nina,
A couple of things:
1. Where in the perldocs did you find the part about setting
AutoCommit
off would fix your problem? Was that in DBD::Ingres?
I haven't used DBI in a while, but I don't remember having a
problem
using a database connection with one statement handle
.
If cancel returns true, then it has successfully invoked the
database
engine's own cancel function. If it returns false, then cancel
failed.
If it returns undef, then the database engine does not have
cancel
implemented.
HTH.
Hardy Merrill
Reidy, Ron [EMAIL PROTECTED] 01/20/05 12:08 PM
what I
remember doing. I think that must be spelled out either in the DBI
perldocs or the DBD::Oracle perldocs - to use a BEGIN block to set
environment variables that is ;-)
Hardy Merrill
Charles Lawrence [EMAIL PROTECTED] 01/18/05 2:54 PM
Gentlemen:
I have struggled with this problem
titled Oracle
Environment Variables and Connection Examples Using DBD::Oracle.
Hardy
Hardy Merrill [EMAIL PROTECTED] 01/19/05 7:46 AM
Hi Charles,
Try setting your environment variables in a BEGIN block, like this:
#!/usr/bin/perl -w
use strict;
BEGIN {
$ENV{'NLS_LANG} = 'american';
$ENV
of the hash
itself
this way each argument is a scalar and there are no hashes or arrays in
the argument list to get flattened out.
This is now probably as clear as mud ;-)
Hardy Merrill
a list of database
names.
Sorry I can't be more help - I'm not using DBI nor MySQL regularly :-(
Not that I don't want to...
Hardy Merrill
Ron Wingfield [EMAIL PROTECTED] 12/29/04 01:07PM
Hello everyone,
I'm having difficulty solving this code problem. I can load a popup
list of states from
Ron, my comments below as HM Sorry for the ridiculous (lack of)
quoting - old version of Groupwise at work :-(
Hardy Merrill
Ron Wingfield [EMAIL PROTECTED] 12/27/04 07:41PM
Hello everyone,
I do appreciate all of your suggestions. Actually, now I do have a
good handle on the problems. I
.
In general, you usually want use and a proper Perl module.
==
From that it sounds to me like 'require' might be what you want,
instead of 'use'.
HTH.
Hardy Merrill
Ron Wingfield [EMAIL PROTECTED] 12/23/04 12:40PM
I would like
My comments are below designated by [hm]...
Hardy Merrill
Reidy, Ron [EMAIL PROTECTED] 12/16/04 05:43PM
See below ...
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Follett, Robert [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 16, 2004 3:30
By no records are returned do you mean you are trying to SELECT from
an access database? Copy/paste in an example of something that's not
working for you, along with what versions of these you are using:
Perl
DBI
DBD::ODBC(?) - which DBD module are you using to access Access?
to put my joins towards the end of the WHERE when I have other
criteria that I'm looking for - just curious to know if I've been doing
it wrong.
Thanks.
Hardy Merrill
Ronald J Kimball [EMAIL PROTECTED] 12/10/04 03:08PM
kaustubh shinde [mailto:[EMAIL PROTECTED] wrote:
Hi,
I am using MySQL
can't get any more specific. If you don't have a book, go to the MySQL
website and read up authentication.
HTH.
Hardy Merrill
Michael David [EMAIL PROTECTED] 12/02/04 12:06AM
Hello,
I have a script that is connecting to two different databases , one is
local
and the other remote.
The local
that it takes a long time to print all the rows
selected.
Hardy Merrill
Schoenwaelder Oliver [EMAIL PROTECTED] 12/01/04
07:07AM
Hi,
I've got a problem with a simple fetch which just takes hours
(literaly) to
complete.
It's a simple select statement which, in the current case, returns
about 300
rows
Tim, can you elaborate a little? I've tried to find the referenced
documentation but can't. I don't quite understand how a CHAR datatype
can cause this problem.
Thanks.
Hardy Merrill
Tim Bunce [EMAIL PROTECTED] 11/24/04 07:35AM
On Tue, Nov 23, 2004 at 10:13:30PM +, Bart Kelsey wrote
Greg Sabino Mullane [EMAIL PROTECTED] 11/16/04 07:54AM
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Your logic that because it worked, MySQL's limit must be 65kb may
be asbogus
as the PostgreSQL 32kb logic, but I don't know MySQL well enough to
say.
Lighten up Greg. Ron did say I
So what did the problem turn out to be?
Robert [EMAIL PROTECTED] 10/20/04 11:23PM
Robert wrote:
My select looks like this:
SELECT surname, first_name, msf810.email_address,
msf810.employee_id
FROM msf810, msf020, MSF829
WHERE msf810.employee_id = msf020.employee_id
I know you said the problem column is an enum column, but can you copy
and paste in a describe of the table in question(acct_hist)? I've
never used an enum column so I'm not sure I'll be any help, but a
describe might help jog someones memory.
Hardy Merrill
NIPP, SCOTT V (SBCSI) [EMAIL
Just in case you didn't get the meaning behind Tim's comment, if you
upgrade your version of Oracle, you then always need to rebuild
DBD::Oracle. DBD::Oracle needs to be built _after_ installing any
version of Oracle.
Tim Bunce [EMAIL PROTECTED] 09/17/04 06:21AM
Rebuild DBD::Oracle.
Tim.
On
COUNT(*) FROM ... SQL statement with the same
... as your query and then fetch the row count from that.
---
If you are fetching all the rows anyone one by one, why not just count
them as you go?
HTH.
Hardy Merrill
Zhiliang Hu [EMAIL PROTECTED] 09/12/04 11:40AM
Case
to google and search for
perldoc DBD::Oracle and I'm sure you'll find it ;-)
Two variables you'll be interested in are LongReadLen and LongTruncOk.
HTH.
Hardy Merrill
Zhang, George [EMAIL PROTECTED] 09/02/04 08:22AM
Hello,
I am trying to insert/update some big text into a CLOB filed
has nothing to do with LOB locators, but this could be another
way to solve the same problem. Not sure what performance impact doing a SELECT on the
sequence nextval and then INSERT'ing, but this way you can at least PREPARE your
insert just once.
HTH.
Hardy Merrill
Jean-Pierre Utter
Original OP - how about some more info? Copy and paste in the errors
that you are getting.
Hardy Merrill
Jenda Krynicky [EMAIL PROTECTED] 08/25/04 01:47PM
From: Registry [EMAIL PROTECTED]
I hope I am addressing this question to a correct email.
I am trying to make multiple prepare
I could be mistaken since I haven't used Apache on Linux in a while, but
don't cgi prints to STDERR by default go to the Apache error log??
Hardy Merrill
Reidy, Ron [EMAIL PROTECTED] 08/23/04 12:13PM
So what exactly don't you understand?
Disclaimer: NOT TESTED!
$SIG{__DIE__} = sub {
print
, $server);
$target_sth-bind_param(3, $year);
$target_sth-bind_param(4, $week);
$target_sth-bind_param(5, $userid);
$target_sth-bind_param(6, $cpu);
$target_sth-bind_param(7, $io);
$target_sth-execute;
}
???
HTH.
Hardy Merrill
Not sure if this is what you're looking for, but do
perldoc DBI
at a command prompt and search for selectall_arrayref,
selectall_hashref, and
fetchall_arrayref.
Hardy Merrill
Xinyu Wen [EMAIL PROTECTED] 08/11/04 12:34PM
Hi,
I would like to know if there is a better way to fetch
variable.
---
HTH.
Hardy Merrill
[EMAIL PROTECTED] 08/11/04 02:56AM
Is there a way to dereference the SQL statement that is send to the
DBD?
I am loading a master table with 19+ fields and there seem to be a
problem
at the end of the SQL statement. I want to see what is the DBI
Did you recompile DBD::Oracle since Oracle 9.2 was installed?
Richard Freedman [EMAIL PROTECTED] 08/10/04 07:52PM
Our DBA has recently upgraded Oracle from 8.1.7 to 9.2. I tried
changing my ORACLE_HOME enviornment and it broke my DBI/DBD::Oracle.
If I run
$ENV{ORACLE_HOME} =
-prepare(insert into OPER_QUERY values (?,?,?,?,?)
)
$sth-execute($a,$b,$c,$d,...$x) or die;
HTH.
Hardy Merrill
Reidy, Ron [EMAIL PROTECTED] 08/13/04 01:13PM
From your original post ...
!! ERROR: 936 'ORA-00936: missing expression (DBD: error possibly
near * indicator at char 252
Ronald J Kimball [EMAIL PROTECTED] 08/13/04 01:59PM
Hardy Merrill [mailto:[EMAIL PROTECTED] wrote:
Just in case the op doesn't make the connection, he needs to test
his
variables for undef before the execute, and if one is undef, then
put
null() in it, something like
offer any insight there.
HTH.
Hardy Merrill
MCMULLIN, NANCY [EMAIL PROTECTED] 08/09/04 11:26AM
Generic question to the group...
It's been requested that we expand our Perl / Database / Web
development to do more advanced things, such as database maintenance,
reporting and monitoring (over the web
Sorry for the poor message quoting - groupwise.
MCMULLIN, NANCY [EMAIL PROTECTED] 08/09/04 11:57AM
From: Hardy Merrill [mailto:[EMAIL PROTECTED]
I think you'll find that Perl can do any and all of what you asked
about, but you're asking about pretty general topics. If you can be
more
Tim, is DBI v2 going to coincide with the release of the 2nd edition of
Programming the Perl DBI?
Hardy Merrill
[EMAIL PROTECTED] 08/02/04 10:31AM
I uploaded the slides for my Advanced DBI tutorial shortly before
OSCON
but forgot to announce them:
file: $CPAN/authors/id/T/TI/TIMB
in-depth there. The way I prefer is to use
q{} with placeholders - better performance and no quoting issues :-)
HTH.
Hardy Merrill
. This link might be some help:
http://www.perldoc.com/perl5.6.1/lib/DBI/FAQ.html#3.1-What's-the-difference-between-ODBC-and-DBI-
Hopefully this will give you some more info to go on.
Hardy Merrill
Janet Goldstein [EMAIL PROTECTED] 07/13/04 09:58PM
On Tue, 13 Jul 2004, Tim Johnson wrote
Janet, I think David was saying that you might(?) be able to use the
DBD::Sybase driver to connect to MS SQL Server ;-)
Hardy Merrill
Janet Goldstein [EMAIL PROTECTED] 07/13/04 11:14AM
David N Murray wrote:
google turns up http://search.cpan.org/search?module=DBD::ADO
ADO ODBC are your
?? If you could post some of the DBI code for
your inserts into SQL Server, that might help ;-)
Hardy Merrill
amonotod [EMAIL PROTECTED] 07/13/04 03:36PM
From: Tim Bunce [EMAIL PROTECTED]
Date: 2004/07/13 Tue PM 06:38:51 GMT
I have been writing a perl script that takes a row of 43 fields
said I thought I would elaborate a little ;-)
amonotod [EMAIL PROTECTED] 07/13/04 04:11PM
From: Hardy Merrill [EMAIL PROTECTED]
Date: 2004/07/13 Tue PM 07:42:25 GMT
Original poster: did you use either the quote method, or better
yet
did you use placeholders??
You know, to be more accurate
description might put you on the right track.
You'll get more help here if you actually try to help yourself first -
at least make an effort to find some information *before* you ask for
help.
Hardy Merrill
John [EMAIL PROTECTED] 07/07/04 09:52AM
I want to automate a mysql backup
Can this be done
.
On Wed, Jul 07, 2004 at 10:05:42AM -0400, Hardy Merrill wrote:
I quick search on google for automate mysql backup perl dbi
revealed this as one of the 1st 5 links:
http://www.csc.liv.ac.uk/~u2pj/SQL_Perl.htm
Check out RW MySQL Dump - looks to me like it might be just what
you're looking
(), \n;
is neither. It In fact, the warning indicates that Perl thinks you are
trying to do a comparison. Where is the 'prepare' - where is the
'execute'?? All that statement does is set $sql equal to a string - the
die is meaningless.
Hardy Merrill
Andy Hammer [EMAIL PROTECTED] 07/01/04 08
How about http://www.perl.com/download.csp
rachakonda muralikrishna [EMAIL PROTECTED] 06/30/04
12:45AM
Hi all,
I would like to know where I can get the perl version 5.004 for AIX.
I haven't found that on any of the prel sites.
Any help in this regard is highly appreciated.
Thanks,
Murali
IIRC (and that's a BIG if since I have never done this myself on HP-UX)
there is a separate DBD::Oracle README file for HP-UX.
Here is one link I found on google by searching for perl dbd::oracle
hp ux readme:
http://perl.active-venture.com/README.hpux.html
HTH.
Hardy Merrill
Reidy, Ron
you see the difference between yours and Jeff's DBI.ppd path???
Hardy Merrill
HSIA, GEORGE (SBCSI) [EMAIL PROTECTED] 06/23/04 04:43PM
I have ActiveState Perl 5.8.3.
I used the PPM to install the DBD-Oracle driver to my pc:
C:\ppm install ftp://ftp.esoftmatic.com/outgoing/5.8.3/DBI.ppd
But I
This link might help you get on the right track:
http://search.cpan.org/~timb/DBI/DBI.pm#bind_param
and look for a paragraph titled Data Types for Placeholders - that
shows you what stuff can be put in that 3rd bind_param argument.
HTH.
Hardy Merrill
[EMAIL PROTECTED] 06/03/04 12:13PM
facility makes the perldocs in a command prompt window not
nearly as useful, so I prefer to go to the perldocs website. Is there
something I could do on Windoze XP to make the perldocs searchable??
Thanks.
Hardy Merrill
Randal L. Schwartz [EMAIL PROTECTED] 06/03/04 03:50PM
Hardy == Hardy Merrill
State
documentation - is it there somewhere?
Thanks.
Hardy
Jeff Zucker [EMAIL PROTECTED] 06/04/04 09:56AM
Hardy Merrill wrote:
Hi Randal,
I'm a relative newbie on Windoze XP, but in order to view the
perldocs
there I have to bring up a command prompt window and type 'perldoc
DBI'
I don't know
to access installed module
documentation on Windoze XP - other than command prompt perldoc ABC??
Michael Ragsdale [EMAIL PROTECTED] 06/04/04 10:25AM
At 10:19 AM 6/4/2004, Hardy Merrill wrote:
Thanks Jeff - didn't know about that, but the Active State
documentation
pages are very nice!
One
Thanks Jeff. That explains why I don't see DBI show up in the Active
State documentation - I wasn't able to get PPM to through our firewall
and/or proxy, so I resorted to downloading the package and installing it
manually.
Jeff Zucker [EMAIL PROTECTED] 06/04/04 10:33AM
Hardy Merrill wrote
Anyone know where the perldocs website went? I just went to google and
nothing seems to come up. I can't find much on www.perl.org.
TIA.
Hardy Merrill
PROTECTED] 06/03/04 11:15AM
At 11:17 AM 6/3/2004, Hardy Merrill wrote:
Anyone know where the perldocs website went? I just went to google
and
nothing seems to come up. I can't find much on www.perl.org.
TIA.
Hardy Merrill
Do you mean http://perldoc.com/ ?
I'm not sure what your particular problem is, but I went to google and
searched for Can't connect to local MySQL server through socket and
found lots of info. Forgive me for questioning the obvious, but are you
sure MySQL is running?
Hardy Merrill
[EMAIL PROTECTED] 04/29/04 09:57AM
Hi,
i
I think Srikanth made a slight typo - see my comment below.
Srikanth Madani [EMAIL PROTECTED] 04/08/04 09:51AM
I have a general problem sourcing out variables in perl. I certainly
can
read the environment variables, but setting them persistently even
after
the script has finished is something
message, and then causes execution to continue with the
next statement after that eval block. I'm not sure what your specific
problem is, but this info. might give you some ideas. Post back if
you're still having problems.
Hardy Merrill
Mark Martin [EMAIL PROTECTED] 04/02/04 09:23AM
Hi,
Database
Paste in your database connect statement. Are you setting RaiseError,
PrintError, and AutoCommit? Which database are you using? Are you
doing any error checking of DBI statements? And as was just pointed out
by someone else, does the user you are connecting with have update
permissions in your
You normally need DBI *and* the appropriate DBD:: module for your
particular database - in this case probably DBD::DB2. I have no
experience connecting to MVS DB2 so I can't offer any more help here.
Hardy Merrill
Wagner, David --- Senior Programmer Analyst --- WGO
[EMAIL PROTECTED] 03/30/04
record??? Basically all it involved
was putting together a list of common error conditions and finding the
corresponding ODBC error codes.
Hardy Merrill
Michael Ragsdale [EMAIL PROTECTED] 03/31/04 04:09PM
hai everyone, i have write scripts perl on the top and if i input
data
12345678,Hendra
Wow, I was way off! - quote from Dumb and Dumber. Like I said,
Ronald is much more knowledgable than I :-)
Hardy
Ronald J Kimball [EMAIL PROTECTED] 03/24/04 04:50PM
The $sth-finish() isn't doing anything; there's an implicit
$sth-finish()
when $sth-fetchrow_hashref() gets to the end of the
I don't see anything wrong with your code - is the bunches of stuff
section too big to include? Also include the standard versions of OS,
Perl, DBI, which database you're using and which DBD (and version of
DBD).
Laurie Vien [EMAIL PROTECTED] 03/24/04 02:44PM
I am running a very simple Perl
.
Hardy Merrill
Laurie Vien [EMAIL PROTECTED] 03/24/04 02:44PM
I am running a very simple Perl script using DBI (skeleton of it
follows).
It does everything I expect it to, but the problem is it doesn't
finish
until I Ctrl-C, at which time I get the message Terminating on signal
SIGINT(2). What
I just found something else at
http://perlmonks.thepen.com/11007.html
that talks about using IO::Handle to redirect STDIN, STDOUT, or STDERR
to a file.
HTH.
Hardy Merrill
Laurie Vien [EMAIL PROTECTED] 03/24/04 02:44PM
I am running a very simple Perl script using DBI (skeleton
;
=
HTH.
Hardy Merrill
Laurie Vien [EMAIL PROTECTED] 03/24/04 03:18PM
There are only 3 records in the input table, and they've all been
processed
to the output file. :-)
-Original Message-
From: Ronald J Kimball [mailto:[EMAIL PROTECTED]
Sent: Wednesday
Notice too that in Jeff's example he used the q() construct which is
fine too when using placeholders since no variables need to be
interpolated.
Mark Galbraith [EMAIL PROTECTED] 03/11/04 06:00PM
Jeff Zucker mailto:[EMAIL PROTECTED] wrote:
Your quote marks were messing you up and the easiest
I'm only familiar with the build the SQL method, but if there's an
alternate method it would be described in the excellent DBI perldocs,
which you can access by doing
perldoc DBI
at a command prompt.
HTH.
Hardy Merrill
Chris Faust [EMAIL PROTECTED] 03/12/04 09:33AM
Good Morning,
Please
)
I did that command in sqlplus - table_b is an exact copy of table_a.
HTH.
Hardy Merrill
Mark Martin [EMAIL PROTECTED] 03/11/04 04:21AM
Hi,
bin using DBI for a while for data warehousing type stuff and up till
now I've had to change data on the fly as it moves from one database to
another
And once you've done what George suggests above, then you need to
install DBI and DBD::Oracle on the Red Hat Linux system. _Then_ you
should be able to connect from your RH Linux client to the Oracle server
on Windoze using Perl.
HTH.
Hardy
perldoc's that refer to
perl modules - the one you probably want to start with is perlmod, which
you can view by doing
perldoc perlmod
at a command prompt.
HTH.
Hardy Merrill
News Reader [EMAIL PROTECTED] 03/10/04 01:35PM
Hi there,
I figured this would be a pretty common problem, but I
I see in 'perldoc DBD::ODBC' that the user id and password _is_ required
when using DBD::ODBC to connect to an ODBC data source. I looked up a
few of my ODBC 'System' data sources, and although they do contain the
user id, they do _NOT_ contain the password. So I'll stick with my
previous
to resolve this? (Also, how do I find out what
version of
Perl I actually have installed?)
Thanks very much--
Laurie
-Original Message-
From: Hardy Merrill [mailto:[EMAIL PROTECTED]
Sent: Friday, March 05, 2004 9:12 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Accessing oracle
.
Install 'DBD-Oracle' version 1.15 in ActivePerl 5.6.1.633.
Successfully installed DBD-Oracle version 1.15 in ActivePerl
5.6.1.633.
Any more ideas?
Laurie
-Original Message-
From: Hardy Merrill [mailto:[EMAIL PROTECTED]
Sent: Monday, March 08, 2004 3:56
',
'my_password',
{ RaiseError = 1, PrintError = 1 }
) || die Can't connect: $dbi::errstr;
print Successful Connect: \$dbh=[$dbh]\n;
And it worked.
Hardy Merrill
Jeff Urlwin [EMAIL PROTECTED] 03/04/04 03:46PM
Jeff, I still don't
::Oracle) is 92% faster than
the ora_odbc_driver?? The last 2 columns have me confused too. Any
help is appreciated.
Thanks.
Hardy Merrill
Warning: I am _NOT_ a windows expert, but I am on a Windows XP machine
and I have gotten DBI to connect to an oracle database using DBD::ODBC.
Do you have an ODBC data source set up on your Win2000 box?
[EMAIL PROTECTED] 03/04/04 09:02AM
Hi all!
I'm sure this is a common question yet I've
',
'user_password',
{ RaiseError = 1, PrintError = 1 }
) || die Can't connect: $dbi::errstr;
HTH.
Hardy Merrill
[EMAIL PROTECTED] 03/04/04 09:15AM
Warning: I am _NOT_ a windows expert, but I am on a Windows XP
machine
and I have gotten DBI to connect to an oracle
-
From: Hardy Merrill [mailto:[EMAIL PROTECTED]
Sent: donderdag 4 maart 2004 15:25
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Accessing oracle from windows 2000
Brian Barto may be right, but I haven't yet tried to connect to an
Oracle db using DBD::Oracle. I'm going to try
1 - 100 of 310 matches
Mail list logo