Can somebody please confirm/dis-confirm this bug. If
it is indeed a bug who to contact for fix?
Platforms Affected: Confirmed on FreeBSD, Linux and
WinNT/2K with Oracle (but I assume its a DBI problem,
hence does not matter which DBD)
Example: Select * From Employee Where Name = ?
If the ?
Hello, my name is Yuriy Lebedeyev.
I've tried to run my small script ora.pl but got an error like following:
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.0/i386-svr5/auto/DBD/Oracle/Oracle.so' for module
DBD::Oracle: dynamic linker : /usr/local/bin/perl :
On Tue, 2 Apr 2002 23:16:47 -0800 (PST), Amr Awadallah wrote:
Diagnosis: DBI removes trailing spaces from values
before passing them through hence the query becomes
Select * From Employee Where Name = 'Mario'
instead of the intended
Select * From Employee Where Name = 'Mario '
You're
yes, this works:
Select * From Employee Where Name = 'Mario '
but this does not work:
$sth-prepare('Select * From Employee Where Name =
?');
and then you $sth-execute('Mario ');
(no offense to Mario of course)
-- Amr
--- Bart Lateur [EMAIL PROTECTED] wrote:
On Tue, 2 Apr 2002 23:16:47
Does it work when using single quotes around the placeholder?
Instead of
$sth-prepare('Select * From Employee Where Name = ?');
try
$sth-prepare(Select * From Employee Where Name = '?');
Cheers
+rl
Amr Awadallah wrote:
yes, this works:
Select * From Employee Where Name = 'Mario '
- Original Message -
From: Amr Awadallah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 4:16 PM
Subject: BUG: Perl DBI truncates Trailing Spaces from Placeholder Bind
Variables.
Can somebody please confirm/dis-confirm this bug. If
it is indeed a bug who to
OK I think this is to do with the default type that the column is being
bound to. I assume that name is a varchar column.
By default varchar's remove trailing spaces so insead of the implicit bind
what if you do...?
$sth-bind_param(1,'Mario ', {TYPE = SQL_CHAR});
$sth-execute;
This should
On 2002-04-03 02:06:15 -0800, Amr Awadallah wrote:
yes, this works:
Select * From Employee Where Name = 'Mario '
but this does not work:
$sth-prepare('Select * From Employee Where Name =
?');
This is a known behaviour of DBD::Oracle. There are several low-level
Oracle types which perl
I'm having a problem with selecting rows from a query which joins 6 tables.
I'm sure its a buffer-related problem but I cannot figure out how to
overcome this. The query returns about 60 rows with no problems, then fails
with the Oracle truncation error ORA-24345.
Here's the trace output from
On Wed, Apr 03, 2002 at 12:54:50PM +0200, T. van Dyk wrote:
I'm having a problem with selecting rows from a query which joins 6 tables.
I'm sure its a buffer-related problem but I cannot figure out how to
overcome this. The query returns about 60 rows with no problems, then fails
with the
Forgot to mention one thing, if I turn the logging off
by ontape -N pdqtest, then I have much much less memory
leaks, probably 3 megs after 50K of records updates.
I don't know I mentioned this or not, I need the logging on
because I need to do cascading delete on my db.
thanks.
yan
Bind it as CHAR.
Ilya
-Original Message-
From: Amr Awadallah
To: Bart Lateur; [EMAIL PROTECTED]
Sent: 4/3/02 3:06 AM
Subject: Re: BUG: Perl DBI truncates Trailing Spaces from Placeholder Bind
Variables.
yes, this works:
Select * From Employee Where Name = 'Mario '
but this does not
Hi! I am running ActiveState Perl 5.6.1 and using DBI 1.21 and
DBD-Mysql 1.2200.
I have a small problem with forks and database connections I run
a simple script that connects to a mysql database , after that it
disconnects and after that is trying to fork! The forked process
Hello Bogdan Badiu, you asked about database connects and forks.
Well, I tried both your scripts out on a Linux machine and got no errors
at all. I was also able to get the fork to work on a Windows 2000 machine,
but I don't have the DBI installed on that box to try the combination. Is
it
I'm trying out exec+placeholders with DBD::Sybase 0.94. I made the following
change to t/exec.t:
--- DBD-Sybase-0.94/t/exec.t~ Tue Jul 3 11:52:21 2001
+++ DBD-Sybase-0.94/t/exec.t Wed Apr 3 12:23:54 2002
@@ -59,13 +59,16 @@
}
} while($sth-{syb_more_results});
-$dbh-do(use tempdb);
You must have Oracle client libs installed on your PC, then recompile
DBD::Oracle. Make sure Oracle lib dir is also in your LD_LIBRARY_PATH.
Ilya
-Original Message-
From: Yuriy Lebedyev
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 4/2/02 11:46 PM
Subject: bugs
Hello, my name is
Hi,
I am not sure if I am sending this email to the correct group. If not
excuse me for my intrusion and if possible send me in the right direction.
We are thinking of moving from Sybase to Oracle (for various reasons) and
we would like to make use of the PERL/Sybperl code that we have. I
On Wed, Apr 03, 2002 at 06:11:33PM +0200, T. van Dyk wrote:
- prepare for DBD::Oracle::db (DBI::db=HASH(0x401e4e6c)~0x401c34f8 'select
area_node.core_description,lab_user.log,
lab_logon_session,
lab_user_role,
From: Andhavarapu, Srinivas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 09:34
Subject: Need information about oraperl
I am not sure if I am sending this email to the correct group. If not
excuse me for my intrusion and if possible send me in the right direction.
Ah, I've just remembered the UTF8 patch kindly sent by Stefan Eissing!
I've appended his email and attached the attachments.
Please let me, and Stefan, know how it goes for you.
Tim.
--
Tim,
attached is the current diff against 1.03 of my utf8 port.
With Perl 5.6.0 patchlevel 6090, all
Wow, that's some silly code:-) Yes, you can do this and in some instances
running through mysql command might be faster, but the portability, design,
expandability of this sucks. You can use placeholders, long column queries,
etc... Did this guy write this years and years ago or something, or
Hello all,
I am a consultant brought in to manage and restructure some Perl scripts that
were written some time ago. The programmer at that time was using the
following code to do a query from within a CGI page.
${query} = SELECT ccyymmddhh FROM inventory ORDER BY ccyymmddhh ; ;
At 04:28 PM 4/3/02 -0500, Kevin Old wrote:
Hello all,
I am a consultant brought in to manage and restructure some Perl scripts that
were written some time ago. The programmer at that time was using the
following code to do a query from within a CGI page.
${query} = SELECT ccyymmddhh FROM
if this is a single query in a web page, at least he avoids the hassle of
trying to install DBI and DBD.. :)
we all know how many hundreds of messages we see from people who can't get
their DBD drivers to make properly.
what kind of overhead does DBI and DBD add to your script in a plain cgi
Useless use of a variable in void context at ...DBD/mysqlPP.pm line
11.
in cleanup) Driver has not implemented DESTROY for
DBI::db=HASH(0x1d32eb4) at ...
These problems were corrected. Since there was a problem
also in quote() of bind_param(), it corrected.
Probably, if it changes so
Thank you for a comment.
I trust the docs describe explicitly any and all differences between
DBD::mysql and DBD::mysqlPP.
I agree with the necessity for the information. It
arranges based on the information on perldoc DBD::mysql.
After this work finishes, it posts to CPAN.
__
I have installed the following SW on Solaris 2.6:
perl 5.6.1
DBI-1.21
DBD:Oracle-1.12
DBD:Sybase-0.94
freetds-0.53 (connecting to MS-SQL 7.0 with TDS_VER 7.0)
Because I'm new to DBI, I tried to write some programs (copies/modifications
of examples found
Hi,
I'm trying to connect to an Oracle database using ASO and Kerberos5. The
connection through SQL*Plus works properly but I couldn't find any
documentation/hints on how to connect through DBI/DBD.
Is there anybody who know how to connect?
Thanks for any hint
Felix
28 matches
Mail list logo