Le Vendredi 14 Juin 2002 00:27, vous avez écrit :
On Thu, Jun 13, 2002 at 07:46:43PM +0200, Guillaume Rousse wrote:
According to this thread
http:[EMAIL PROTECTED]/msg10537.html, charset
encoding is not a DBI issue, unless proven there is something wrong :-)
It used to not be a DBI issue
On Fri, Jun 14, 2002 at 11:29:57AM +0200, Guillaume Rousse wrote:
Le Vendredi 14 Juin 2002 00:27, vous avez écrit :
On Thu, Jun 13, 2002 at 07:46:43PM +0200, Guillaume Rousse wrote:
According to this thread
http:[EMAIL PROTECTED]/msg10537.html, charset
encoding is not a DBI issue,
On 2002-06-13 13:48:58 -0700, Philip Daggett wrote:
Is there a way for a Redhat Linux box to connect to an Oracle Server
without having to install Oracle Client? Is there some other DBD module
which will do this? Installing Oracle Client is starting to become a big
pain in the butt.
My
Is that because there was a known bug in earlier versions? If so, is it
correct that it was not fixed until 1.27?
On Thu, 13 Jun 2002, Tim Bunce wrote:
On Thu, Jun 13, 2002 at 11:37:36AM -0400, Kelly Robbins wrote:
I have a database monitoring script which runs 'indefinitely' to monitor
It *may* be related to a bug that was fixed in 1.25.
Or it may not. Try it.
Tim.
On Fri, Jun 14, 2002 at 08:25:23AM -0400, Kelly Robbins wrote:
Is that because there was a known bug in earlier versions? If so, is it
correct that it was not fixed until 1.27?
On Thu, 13 Jun 2002, Tim
David,
Patches welcome. I'm not sure what happened to your earlier patches, but
I'm more on top of things lately and a fresh patch against .41 would be
welcome.
Thanks,
jeff
-Original Message-
From: David L. Good [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 9:42 PM
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.28.tar.gz
size: 251663 bytes
md5: 0c323bdc712fe379ec92d826514615e3
=head2 Changes in DBI 1.28,14th June 2002
Added $sth-{ParamValues} to return a hash of the most recent
values bound to placeholders via bind_param() or execute().
The uploaded file
DBI-1.28.tar.gz
has entered CPAN as
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.28.tar.gz
size: 251663 bytes
md5: 0c323bdc712fe379ec92d826514615e3
No action is required on your part
Request entered by: TIMB (Tim Bunce)
Request entered on: Fri, 14 Jun 2002 13:12:34 GMT
I try to install DBI with MySql. I want to use it.
Installing DBI 1.26 make some problams see below for a complete log of a
complete build.
I´m a beginner and working on this thing since one week. Reading a lot of
Readme´s, FAQ and so on.
There is no idear to go on and no understanding of the
On Fri, 14 Jun 2002 15:02:54 +0100, Tim Bunce wrote:
This release marks the end of the current run of DBI enhancements
(not least because I'm away on holiday next week :)
What, no further updates later today?;-)
--
Bart.
Seems to be an error with selectall_hashref method. Anyone know what the
problem is?
Here are the errors:
[Fri Jun 14 11:00:00 2002] confirm_warning_1.0.7c.pl: DBI selectall_hashref:
invalid number of parameters: handle + 1
[Fri Jun 14 11:00:00 2002] confirm_warning_1.0.7c.pl: Usage:
Have you tried running it from the command line, not as a CGI script?
This may be an example, but you really don't need a stored procedure here.
$sth = $dbh-prepare('insert into some table values(?,?)');
$sth-execute($data1, $data2).
...but your procedure may do alot more than you sent here.
Yes, I did test it first with a simple insert statement. The reason I am
using a procedure is speed. I can pin the procedure in memory and save time
on multiple inserts.
-Original Message-
From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 09:19 AM
To:
Do not use DBI-1.26. Notice was sent that it is being removed from CPAN. The
latest is 1.28.
--Thunder
-Original Message-
From: Briscoe B. Brown [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 8:02 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL
I had the same problem. Follow the suggestions in the DBI README.hpux
(DBD-Oracle-1.12)
regarding perl configuration. My config.sh is attached.
Stefan
-Original Message-
From: Briscoe B. Brown [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 8:02 AM
To: [EMAIL PROTECTED]
Cc:
On Fri, Jun 14, 2002 at 09:25:33AM -0600, Powell, Bruce wrote:
Yes, I did test it first with a simple insert statement. The reason I am
using a procedure is speed. I can pin the procedure in memory and save time
on multiple inserts.
What makes you think it would be faster than doing
On Fri, Jun 14, 2002 at 04:59:54PM +0200, Bart Lateur wrote:
On Fri, 14 Jun 2002 15:02:54 +0100, Tim Bunce wrote:
This release marks the end of the current run of DBI enhancements
(not least because I'm away on holiday next week :)
What, no further updates later today?
I bet you've upgraded from a version 1.20.
The interface to selectall_hashref changed in version 1.20.
Read the Changes file (or perldoc DBI::Changes).
Tim.
On Fri, Jun 14, 2002 at 11:14:23AM -0400, Randall Perry wrote:
Seems to be an error with selectall_hashref method. Anyone know what
Whoops, marked wrong line as #124, here's corrected version
Seems to be an error with selectall_hashref method. Anyone know what the
problem is?
Here are the errors:
[Fri Jun 14 11:00:00 2002] confirm_warning_1.0.7c.pl: DBI selectall_hashref:
invalid number of parameters: handle + 1
First, I am sorry for this discussion getting so far off topic. The use of
a pinned procedure is a database issue, not a perl dbi issue. That
said.
That is exactly what we are doing here is a benchmarking. The reason for
this is how Oracle handles calls. If I can pin a procedure in
I created your procedure, and used the code below and was able to
insert both values. So the code is fine(which you already know),
I don't do any CGI programming, so I can't offer much help.
On 14-Jun-2002 Powell, Bruce wrote:
First, I am sorry for this discussion getting so far off topic.
Hi
I want to insert records from an array iteration. not sure of the best way
to enter the date and time. i read the docs, but thought i would check to
see if someone has experience with this and could give some ideas. code..
--
my $sth = $dbh-prepare( INSERT INTO stats VALUES (?,?,?,?,?) )
can i simply do :
foreach (stats){
chomp;
($host, $user $cpu_pct, $mem_pct = split( /,/ );
$sth-execute( sysdate(), $host, $user $cpu_pct, $mem_pct );
}
or do i have to do another query like
select SysDate from DUAL;
thanks Michael !!
what are my options for
Some date inserts I have experience with regarding Oracle and mssql (if this
helps).
Mark
--Oracle
insert into order_details (OrderID, ProductID, UnitPrice, Quantity,
Discount, OrderDate, ProductName)
VALUES (5,1,1,1,1,TO_DATE ('4/01/1953', 'MM/DD/'),'name') ;
--mssql
insert into order
yes, any ideas help. just looking for the best way. thank you !!
-Original Message-
From: Mark Charshaf [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 1:08 PM
To: Kipp, James
Cc: Dbi-Users
Subject: RE: best way to insert date/time into oracle table
Some date inserts I
Are you using this for just a timestamp for record insertion? If so, SYSDATE is your
best bet. You can use SYSDATE like so:
prepare(insert into table1 (field1, field2, timestamp) values(?, ?, SYSDATE));
execute(Harry, Potter);
Your execute statement can then be looped through with different
i am using it for a timestamp record insertion :-)
the date/time is one of the fields in the table where i will be inserting
the records.
the table stats has the fields: sdate(date), host, user %cpu, %mem
i will give this a try:
my $sth = $dbh-prepare( INSERT INTO stats VALUES (?,?,?,?,?) )
Don't put SYSDATE in the execute. Put it in the prepared statement:
my $sth = $dbh-prepare( INSERT INTO stats VALUES (SYSDATE,?,?,?,?) )
or die Cannot prepare SQL statements from $DBI::errstr\n;
foreach (@stats){
chomp;
($host, $user $cpu_pct, $mem_pct = split( /,/ );
THANKS! I just found that out the hardway :)
Thanks all for your help. SYSDATE is the best way to go for my situation
-Original Message-
From: Jeff Seger [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 2:35 PM
To: Kipp, James
Cc: [EMAIL PROTECTED]
Subject: RE: best way to
Why not just put it as a constraint on the table to supply a default value
of SYSDATE for the column? Then you don't have to deal with it from the
program side at all.
On Jun 14, Kipp, James scribed:
THANKS! I just found that out the hardway :)
Thanks all for your help. SYSDATE is the best
the pinned procedure would not be faster than the lone
insert statement using bind variables and multiple
executes. on the sql end they both do the same thing.
static sql or dynamic sql with bind variables in the
pl/sql block is hashed and reused as well.
what possibly makes you think having
True. I agree it is better, but one thing I ran into recently here is
that another coder looked at some of my code where a table had a default
for inserts and a trigger for updates for maintaining the date and she
didn't understand why I could get away with not supplying a value for
that column.
- Forwarded message from Marcello Mezzanotti [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
X-Authentication-Warning: mezzanet.intranet.vbnet.com.br: mezzanet set sender to
[EMAIL PROTECTED] using -f
Subject: DBD-Oracle 1.12 and Oracle 9.2i
From: Marcello Mezzanotti [EMAIL
Ok, here's text from DBI::Changes re: 1.20 change:
To get previous selectall_hashref() behaviour (an array of hash refs)
change $ary_ref = $dbh-selectall_hashref( $statement, undef,
@bind);
to $ary_ref = $dbh-selectall_arrayref($statement, {
Columns={} }, @bind);
When I
34 matches
Mail list logo