Stephen R. Wilcoxon wrote:
Is it possible to get the driver specific prefix programmatically with a
database handle (or statement handle)? For example if I do:
$dbh = DBI->connect('dbi:Sybase:...');
$sth = $dbh->execute('select 1');
Is there any way to get 'syb' or 'syb_' from the $dbh or $sth
On Wed, 2002-12-04 at 16:13, Zhao, Charles wrote:
> Sybase sql servers is what I am using. So far every reply has been very
> helpful.
There's nothing magic about executing stored procedures with
DBD::Sybase. You can run them like any other SQL statement.
Michael
> -Original Message-
>
Sybase sql servers is what I am using. So far every reply has been very
helpful.
Thanks.
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 4:03 PM
To: [EMAIL PROTECTED]; Zhao, Charles
Subject: Re: Perl DBI and Stored Procedures
On W
On Wed, 4 Dec 2002 15:27:02 -0800 "Zhao, Charles" <[EMAIL PROTECTED]> wrote:
> I need to call stored procedures directly from Perl -- don't want to use
> any shell script in between. Can anybody please give me any tips how to
> do it?
RTFM: http://xmlproj.com/fom-serve/cache/49.html
For any mor
I need to call stored procedures directly from Perl -- don't want to use
any shell script in between. Can anybody please give me any tips how to
do it?
Thanks.
>
> Hello everybody.
>
> I call SQLCancel function to cancel my query and got an error:
> DBD: no statement executing err=-1.
> It looks like statement is not defined in
> DBIc_ACTIVE(imp_sth). I run it on osf1 unix 4, DBI 1.31,
> DBD::ODBC 0.45_18. I use SDK iODBC driver manager version 3.
I'
okay, i installed both the DBI and dbd-mysql ppds from ilya's PPM
repository, but now all i get is:
_
Can't load 'C:/Perl/site/lib/auto/DBD/mysql/mysql.dll' for module
DBD::mysql: load_file:The specified module could not be found at
C:/Perl/lib/DynaLoader.pm line 206.
_
which i don't qu
Is it possible to get the driver specific prefix programmatically with a
database handle (or statement handle)? For example if I do:
$dbh = DBI->connect('dbi:Sybase:...');
$sth = $dbh->execute('select 1');
Is there any way to get 'syb' or 'syb_' from the $dbh or $sth (since that
is the driver
This may not be what you're looking for, but this looks like a good place to
use either an array of arrays.
Array of Arrays:
my @lol = ();
push(@lol,[Dell,Computer,3.2]); #add an anonymous array to the array
etc...
foreach(@lol){
print "Manuf. => $_->[0], Category => $_->[1], Value => $_
Hello everybody.
I call SQLCancel function to cancel my query and got an error:
DBD: no statement executing err=-1.
It looks like statement is not defined in DBIc_ACTIVE(imp_sth).
I run it on osf1 unix 4, DBI 1.31, DBD::ODBC 0.45_18.
I use SDK iODBC driver manager version 3.
The trace is followin
> I do not see where you actually build an array of values for @col. You
> build an array for @col which is full of undef values but has an index for
> every returned row.
>
> @{$col[$i]} = @row;
> isn't that an annonomyous array with an index of the value of the
> @col index
> of $i which is un
On Wed, Dec 04, 2002 at 12:24:15PM -0600, Stephen Clouse wrote:
>
> On Wed, Dec 04, 2002 at 11:21:53AM +, Tim Bunce wrote:
> > On Tue, Dec 03, 2002 at 04:07:36PM -0500, John Milardovic wrote:
> > > >From a thread last month
> > > (http:[EMAIL PROTECTED]/msg14522.html) it was
> > > indicated th
> No, since you don't ever set $type_n or $mfg_n before you use them.
Actually, I cut that part out, b/c it involves some long hashes. Here is the
full script, start to finish.
<>
$conn = DBI->connect ("dbi:Pg:dbname=$dbname", "$dbuser", "$dbpass");
## Populate array with list
On Wed, 4 Dec 2002 12:58:44 -0600 Daniel Bakken <[EMAIL PROTECTED]> wrote:
> I've got an "if" that checks to make sure
> variables are initialized.
> Wouldn't this statement below keep unitialized
> stuff out of the
> concatenation?
>
> if ($col[$thing][0] && $col[$thing][1]) {
> $mfg = @{$col
On Wed, Dec 04, 2002 at 12:44:08PM -0600, Daniel Bakken wrote:
> foreach $thing (@col) {
> if ($col[$thing][0] && $col[$thing][1]) {
You're using the elements of an array as indexes into the same array. That
is almost certainly not what you meant to do, especially since the elements
of the arr
> I suspect this error:
>
> > Use of uninitialized value in concatenation (.)
> > at ./cvgroup.pl line 67.
> > Use of uninitialized value in concatenation (.)
> > at ./cvgroup.pl line 67.
>
> refers to this line:
>
> > $partno = $mfg_n . $type_n . $size_n;
I've got an "if" that checks to make
I suspect this error:
On Wed, 4 Dec 2002 12:44:08 -0600 Daniel Bakken <[EMAIL PROTECTED]> wrote:
> Use of uninitialized value in concatenation (.)
> at ./cvgroup.pl line 67.
> Use of uninitialized value in concatenation (.)
> at ./cvgroup.pl line 67.
refers to this line:
> $partno = $mfg_n
I'm trying to use fetchall_array to store the results of a SELECT in a
2-dimensional array. It does the first while statement, but then does some
crazy things at the foreach loop. It sits there for a few minutes, then
starts endlessly looping, printing out the following error messages over and
over
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Dec 04, 2002 at 11:21:53AM +, Tim Bunce wrote:
> On Tue, Dec 03, 2002 at 04:07:36PM -0500, John Milardovic wrote:
> > >From a thread last month
> > (http:[EMAIL PROTECTED]/msg14522.html) it was
> > indicated that DBD-Oracle 1.13 would suppo
On Wednesday, December 4, 2002, at 08:05 AM, Stephan Harren wrote:
I need to connect from a w2k-machine to a far-away linux-server
running postgres. Now I can't compile the DBD-PG-1.20 module. Any
ideas? I tried to install the Win32-Libraries by nmake /f win32.mak,
and the module also find t
> use DBI;
> my $msdbh = DBI->connect("dbi:ODBC:EasyArchiv", "user",
> "pass", { RaiseError => 1, PrintError => 1, AutoCommit => 1 }
> ) or die $DBI::errstr; $mssth = $msdbh->prepare("USE REFDB")
> ; $mssth->execute; print "$DBI::errstr\n";
>
> my $db2dbh = DBI->connect("dbi:ODBC:DB2J21", "use
>
> Expect a few development/beta releases as there's a big
> backlog of changes to work through.
Tim -- do you have any Makefile.PL patches for Win32? I just moved my
machine and I think I ordered things wrong or something's not right
about the way the script is working for me on Win32. I was
Hmm...
According to this http://www.mysql.com/doc/en/Fulltext_Search.html it is
in 3.2.23.
Might want to take a look again. I just have not tried it myself yet.
Iman Mayes
-Original Message-
From: Oriol Portell - UV [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 6:44 AM
T
Hi All,
I need to connect from a w2k-machine to a far-away linux-server running
postgres. Now I can't compile the DBD-PG-1.20 module. Any ideas? I tried
to install the Win32-Libraries by nmake /f win32.mak, and the module
also find that libs and includes, but it always stops compiling.
Best r
Ok, code wise, nothing is failing. Your first problem is there is no need to do (or
die $DBI::errstr) since you set RaiseError on. Also, you should disable PrintError,
you don't need it printed twice. PrintError is like warning, if both RaiseError and
PrintError are turned on, then you get th
No, you don't, that's something else, send us the trace output.
Ilya
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 10:12 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: perl.exe crashes with 2 connects
On Wed, 4 Dec 2002 16:33:34 +0100 [EMAIL PROTECTED] wrote:
> ok, here wo go. What I already found again is, if I take out the 'print
> "$DBI::errstr\n";' statements the error disappears again... Maybe I only
> may
> access $DBI::errstr if there really is an error?
You are printing $DBI::errstr e
> No, you don't, that's something else, send us the trace output.
> Ilya
ok, here wo go. What I already found again is, if I take out the 'print
"$DBI::errstr\n";' statements the error disappears again... Maybe I only may
access $DBI::errstr if there really is an error?
Lars
trace.log
Descrip
> Use trace...
> DBI->trace(2, "trace.log");
Tried already, though I couldn't read much from the information I got there.
But I found out something else, when I do some "SELECT" statement with the
second handle also, the error disappears. Seems you have to *use* the DBI
handle ;)
Lars
Use trace...
DBI->trace(2, "trace.log");
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 8:01 AM
To: [EMAIL PROTECTED]
Subject: perl.exe crashes with 2 connects
Hi,
I have a problem with the following code:
-
Hi,
I have a problem with the following code:
use DBI;
my $msdbh = DBI->connect("dbi:ODBC:EasyArchiv", "user", "pass", { RaiseError
=> 1, PrintError => 1, AutoCommit => 1 } ) or die $DBI::errstr;
$mssth = $msdbh->prepare("USE REFDB") ;
$mssth->execute;
To make DBI 1.30 and DBD 1.12 work for Oracle 9.2.0 on Solaris 2.8 and 2.6, you have
to make the following changes:
in $ORACLE_HOME/lib [solaris 2.6/2.8, 32/64 bit Oracle]
1. cp -p libclntsh.so.9.0 libclntsh.so.8.0
2. cp -p libwtc9.so libwtc8.so
Good luck,
Lin
Tim Bunce <[EMAIL PROTECTED
Iman,
I read this article yesterday in the morning. :-) The new full text
search function of MySQL 4beta is exaclty what I'm looking for. There is
only a problem... I don't think my university is going to upgrade to a
beta version of MySQL, so I need a perl "search algorithm" instead.
Thanks a
On Thu, Jan 02, 2003 at 06:03:25PM -0600, Moritz von Schweinitz wrote:
> hi there,
>
> somehow i can't get $sth->{ParamValues} working using DBD::mysql (i
> guess it should support that feature, or?).
>
> anyhow, the docs say:
> -
> ParamValues (hash ref, read-only)
> Ret
On Tue, Dec 03, 2002 at 04:07:36PM -0500, John Milardovic wrote:
> >From a thread last month
> (http:[EMAIL PROTECTED]/msg14522.html) it was
> indicated that DBD-Oracle 1.13 would support array inserts.
That was mostly wishful thinking.
> Can anyone
> (Tim?) confirm this? If so is there a projec
On Wed, Dec 04, 2002 at 08:20:52AM +1100, Steve Baldwin wrote:
> I'm sure this has been asked many times before, but Tim's reply here
> prompted me to ask again. Is there any way to access the DB version (as
> per your example of get_info(18) below) from DBI. For example as an
> attribute of the
On Tue, Dec 03, 2002 at 06:56:37PM -0800, Josh Wilmes wrote:
>
> After figuring that libthread was somehow to blame, we did a little
> fiddling around and found that DBD::Oracle is linking against -lthread,
> but the oracle libraries are _not_.
>
> We tried removing this library from the linking
On Tue, Dec 03, 2002 at 05:16:27PM -0800, Josh Wilmes wrote:
> Tim-
>
> Your suggestion did seem to do the trick. However, this is going to be
> pretty painful for us to implement, as new new build of perl uses a
> different architecture-specific directory (sun4-solaris-thread-multi vs.
> sun
After figuring that libthread was somehow to blame, we did a little
fiddling around and found that DBD::Oracle is linking against -lthread,
but the oracle libraries are _not_.
We tried removing this library from the linking in the Makefile, and it
appears to have done the trick!
After doing "pe
Tim-
Your suggestion did seem to do the trick. However, this is going to be
pretty painful for us to implement, as new new build of perl uses a
different architecture-specific directory (sun4-solaris-thread-multi vs.
sun4-solaris).
Basically we'd have to recompile all of our installed modul
40 matches
Mail list logo