On Wednesday, April 25, 2001, at 07:02 PM, Neil Lunn wrote:
>> both return a single row indicating success or failure. The last
>> two return a row for each record in the table. You'd probably be
>> less than thrilled if you have a few million records.
>
> No these means do not return any rows.
Why would (select * from foo) take up lost of resources? Won't it just
place the cursor at the first row and only return when rows are fetched?
Ilya Sterin
-Original Message-
From: Mike Schienle [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 9:43 PM
To: '[EMAIL PROTECTED]'
S
> both return a single row indicating success or failure. The last
> two return a row for each record in the table. You'd probably be
> less than thrilled if you have a few million records.
No these means do not return any rows. They return sucess or faliure with
initiating
a fetch. In fact no
On Wednesday, April 25, 2001, at 06:09 PM, Neil Lunn wrote:
>> -Original Message-
>> From: Thomas von Elling Skifter Eibner [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, April 25, 2001 7:27 AM
>> To: Mark Riehl
>>>
>>> The New Riders MySQL book has the following statements:
>>> SELECT C
My sincere apologies for posting here, but I've tried the Perl news groups
without success, and am desperate to get this working.
I have (after experiencing the usual pain), got DBI-1.14 and DBD-Oracle-1.06
working quite OK. I now want to install the MQSeries module. I've done it
on a sun machi
Hi, I'm working with: Solaris 7, latest DBI latest DBD::DB2 module and
DB2 v 6.1 and the Apache modified by IBM for the Websphere platform
after the usual pain compiling the db2 module and made it work,
everything went fine until the moment I tried to run scripts from the
web, I've read that in o
> -Original Message-
> From: Thomas von Elling Skifter Eibner [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 25, 2001 7:27 AM
> To: Mark Riehl
> >
> > The New Riders MySQL book has the following statements:
> > SELECT COUNT(*) FROM table_name
> > SELECT * FROM table_name WHERE 1=0
>
> -Original Message-
> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 26, 2001 6:18 AM
> To: 'Steve Starer '; '[EMAIL PROTECTED] '
> Subject: RE: Install question
> for it to work, but I don't know if OLE modules were ever
> ported to other
> platforms? I wouldn't
Finally got the DBD::Oracle 1.06 to work on HP-UX 11 system using gcc.
However, I had to go back a version for both Perl and DBI from the latest
stable releases to 5.6.0 and 1.14 respectively.
Tried Perl 5.6.1 w/ DBI 1.15, but could only get Perl to test succesfully as
multithreaded,
despite
I just checked there is for v5.6
Ilya Sterin
-Original Message-
From: XPerl
To: [EMAIL PROTECTED]
Sent: 04/25/2001 2:05 PM
Subject: Re: :Twig
There is no XML::Twig binary package on activestate.. Buy may be I can't
see.?
- Original Message -
From: "Sterin, Ilya" <[EMAIL PROTECT
Do you have Oracle client installed? If not you need to install and point
you library path there.
Ilya Sterin
-Original Message-
From: Rozengurtel, Daniel
To: '[EMAIL PROTECTED]'
Sent: 04/25/2001 1:31 PM
Subject: DBD
Hello everybody
I am installing the DBD::Oracle onto SunSolaris.
Wh
Steve, is the script failing when you are using ADO or DBD::Sybase. You
said that DBD::Sybase worked? Did it generate a warning or how did you make
it call ADO, unless you tried to connect with it. Also I have never tried
ADO on anything other than wintel platforms, so not sure about the bug(s)
> Are you using ADO?
No I'm not, and I don't intend to at this time . I think it got installed
when I ran perl against the DBD bundle.
> connect to Sybase you need to install DBD::Sybase and use
DBI->connect("dbi:sybase:") as your connect string.
I have the DBI working with the DBD for Syba
There is no XML::Twig binary package on activestate.. Buy may be I can't
see.?
- Original Message -
From: "Sterin, Ilya" <[EMAIL PROTECTED]>
To: "'Thirumalai, Radhika '" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, April 25, 2001 10:29 PM
Subject: RE: :Twig
This is not a DB
Hello everybody
I am installing the DBD::Oracle onto SunSolaris.
While installing I get this messages:
Evaluating `cat $(LIBHOME)sysliblist`
expanded `cat /db01/app/oracle/product/8.1.6/lib/sysliblist`
returned '-lnsl -lsocket -lgen -ldl -lsched'
Died at Make
Hi!
We found the problem; it was an un-escaped "@" in the password.
Argh!!! (carefully wiping all egg off of my face)
Thanks for your help!
-- David Beroff <[EMAIL PROTECTED]> Founder/CEO, note.com LLC
P.O. Box 234, Jenkintown, PA 19046-0234 (USA) http://note.com
Voice: +1 (215) 576-6800
This is not a DBI question. Please refer to appropriate group next time.
There is a wonderful Perl/XML mailing list on activestate.
You problem is not with XML::Twig but rather not having your PPM
configured/used properly. I am not sure if XML::Twig even has a binary
package on activestate, you
I'm trying to install XML::Twig and I'm on Winnt 4.0. Can someone tell me
how I can get around this error? Thanks.
Radhika.
C:\Perl>ppm
PPM interactive shell (2.1.2) - type 'help
Totally missed that first one. I guess I'll have to wrap it in a block
and set $^W = 0. I'll give the {syb_do_proc_status} =1 a try.
Thank you
>
> You have two entries in @row that are undef (i.e. - they are NULL in
> the result set).
>
> > /tmp/xxx.tmp::EXTtranldr::Apr 25 2001 12:26PM1
Curt Russell Crandall writes:
> I'm rewriting a piece of C code that uses the OpenClient libraries to set
> a row in a process table under certain circumstances. The chunk of Perl
> code that handles this is:
>
> package init_process;
>
> ...
>
> my $cmd = "exec sales2..sa_initprocess
I'm rewriting a piece of C code that uses the OpenClient libraries to set
a row in a process table under certain circumstances. The chunk of Perl
code that handles this is:
package init_process;
...
my $cmd = "exec sales2..sa_initprocess ", $dbh->quote($item_src) . ",
" . $proc_id;
my $sth = $
Are you using ADO? You are in a Solaris environment and the required
modules are not installed? If you want to connect to Sybase you need to
isntall DBD::Sybase and use DBI->connect("dbi:sybase:") as your connect
string.
http://cpan.valueclick.com/modules/by-category/07_Database_Interfaces/
> What's the error message?
The program name is probe-drivers.pl.
(roswell::/export/home/sstarer/src/perl)> ./probe-drivers.pl
Driver: ADO
install_driver(ADO) failed: Can't locate Win32/OLE/Variant.pm in @INC (@INC
contains: /opt/lib/perl5/5.6.0/sun4-solaris /opt/lib/perl5/5.6.0
/opt/lib/perl5 /u
What's the error message?
-Original Message-
From: Steve Starer
To: [EMAIL PROTECTED]
Sent: 04/25/2001 9:55 AM
Subject: Install question
Hope this is the right place to post. I sent mail to get the FAQ and am
awaiting a reply. In the meantime...
I'm in a Sybase/Solaris environment. New t
>From doc/postgres/sql-createsequence.htm:
"After a sequence is created, you may use the function nextval(seqname) to
get a new number from the sequence. The function
currval('seqname') may be used to determine the number returned by the last
call to nextval(seqname) for the specified sequence in
Hello all,
I'm trying to do the following insert statement and can't seem to get it to
work:
INSERT INTO domains (dname, user, pass) VALUES('currval('cust_seq')', bob,
something);
I am getting the error that says it that cust_seq.currval is not defined. I
do have cust_seq defined as a Seque
On Wed, Apr 25, 2001 at 05:19:14PM +0200, Sean Carte wrote:
> I'm trying (unsuccessfully) to get DBI:Pg to insert NULL values into
> a table. The following works in psql (and dbish):
>
> 'UPDATE null_test SET dwarf_1=NULL WHERE dwarf_2='Grumpy';'
>
> It also works in a $dbh->do() statement:
>
On Wed, Apr 25, 2001 at 05:19:14PM +0200, Sean Carte wrote:
> $cursor->execute(NULL, 'Grumpy') || die $dbh->errstr;
Try: $cursor->execute(undef, 'Grumpy') || die $dbh->errstr;
BTW: Is there a Difference between $dbh->errstr and $DBI::errstr ?
I always used the last and it works, too.
bye,
-chri
On Wed, Apr 25, 2001 at 10:43:16AM -0500, K Old wrote:
> Thanks for your reply. Just for clairfication in the eval{} do I need to do
> a sth->prepare($statement) then an sth->execute() for each statement in the
> eval?
Put everything in your eval{} that needs to be "evaluated" and eventually
ro
On Wed, Apr 25, 2001 at 05:19:14PM +0200, Sean Carte wrote:
> I'm trying (unsuccessfully) to get DBI:Pg to insert NULL values into
> a table. The following works in psql (and dbish):
>
> 'UPDATE null_test SET dwarf_1=NULL WHERE dwarf_2='Grumpy';'
>
> It also works in a $dbh->do() statement:
>
Hello Kevin
my name is Daniel and I am looking for help with the issue of installing the
DBD::Oracle onto SunSolaris.
While installing I get this messages:
Evaluating `cat $(LIBHOME)sysliblist`
expanded `cat /db01/app/oracle/product/8.1.6/lib/sysliblist`
returned '-lns
On Wed, Apr 25, 2001 at 05:38:47PM +0200, Christian Hammers wrote:
> On Wed, Apr 25, 2001 at 04:34:26PM +0100, Tommy Wareing wrote:
> > Oracle have mentioned in the past that they might differentiate
> > between NULL and an empty string, but it's going to break so much
> > code, that I think we're
Simon,
Thanks for your reply. Just for clairfication in the eval{} do I need to do
a sth->prepare($statement) then an sth->execute() for each statement in the
eval?
Can you give me an example of two statements?
Thanks,
Kevin
>From: Simon Oliver <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>S
On Wed, Apr 25, 2001 at 04:34:26PM +0100, Tommy Wareing wrote:
> Oracle have mentioned in the past that they might differentiate
> between NULL and an empty string, but it's going to break so much
> code, that I think we're safe with this...
I would be horrified if any database would treat undef a
Hope this is the right place to post. I sent mail to get the FAQ and am
awaiting a reply. In the meantime...
I'm in a Sybase/Solaris environment. New to Solaris, and new to Perl.
I just installed DBI. I need it to hit a Sybase database. I grabbed the DBD
bundle first, and it installed it thinking
At 5:27 pm +0200 25/4/01, Christian Hammers wrote:
>BTW: Is there a Difference between $dbh->errstr and $DBI::errstr ?
>I always used the last and it works, too.
$DBI::errstr refers to the last handle used within DBI, whereas
$dbh->errstr is associated with the current error flagged against the
I'm trying (unsuccessfully) to get DBI:Pg to insert NULL values into
a table. The following works in psql (and dbish):
'UPDATE null_test SET dwarf_1=NULL WHERE dwarf_2='Grumpy';'
It also works in a $dbh->do() statement:
But when I attempt the same with placeholders:
$cursor = $dbh->prepare( q
Hi there,
I've tried the various suggestions that people have made and so far no good
(thanks a lot for the help though). Seting NLS_LANG in $ENV makes no
difference whatsoever.
One thing I've noticed is that character 0x9C ( the Windows 1252 oe
ligature ) is mapped to a pound sterling character
Hello!
I'm hoping you can help me. I am getting the error,
"Access denied for user ... (Using password: NO)"
from a call to DBI->connect, despite the fact that a password is,
in fact, being passed as its third parameter.
My concern is not a matter of the *wrong* password being sent; it's
Set AutoCommit to 0 to enable transaction, something like:
From the DBI man pages:
$dbh->{AutoCommit} = 0; # enable transactions, if possible
$dbh->{RaiseError} = 1;
eval {
foo(...)# do lots of work here
bar(...)# including inserts
baz(...)# a
40 matches
Mail list logo