Sorry it's too late.
DBD::Excel is a class for DBI drivers that act on Excel File
on any platform.
0.05 Fri Jul 13 19:30 2001 (Changes from 0.04)
- Fix Excel.pm : column name handling
- Add Excel.pm : xl_ignore option
set casesensitive or not about table name and columns.
Date sent: Sun, 15 Jul 2001 19:52:15 -0400
Subject:DBI and HTML Display
From: Kevin Diffily [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Kevin
Can anyone offer a simple example of retrieving information with DBI and
displaying it
Error message I get is:
Can't get DBI::db=HASH(0x9e11650)-{Name}: unrecognised attribute at
/usr/local/lib/site_perl/DBIx/Recordset.pm line 178.
[..]
178: $self-{'*DataSource'} = $data_source-{'Name'} ;
try to change this line to
$self-{'*DataSource'} = eval { $data_source-{'Name'}
What version of DBD::Oracle are you using?
DBD Oracle V 1.07
Are you using dbiproxy?
I don't think so.
Please show your connect string -
obviously you can XXX out the
User Name and Password, and even
the database name if you want.
Here you are
On Sun, Jul 15, 2001 at 09:15:02PM +0100, Tim Bunce wrote:
On Sat, Jul 14, 2001 at 05:00:11PM -0700, Alex Algard wrote:
It was a mistake. I've deleted it now. Use...
$ary_ref = $sth-fetchall_arrayref( {} );
That's actually what I'm doing now. My concern is that using
Hi all,
I am trying to load data into tables using LOAD statement,
and I am getting a syntax error from this:
$db_handle-do(load from file insert into mytable)
I spent an hour investigating this, until I found out
that LOAD and UNLOAD statements can only
be used from Informix DBAccess, this
-Original Message-
From: Sokolowski, Gwen (G.)
Sent: Monday, July 16, 2001 10:06 AM
To: Sterin, Ilya (I.)
Subject: RE: Disposal PRojects -
What version of DBD::Oracle are you using?
DBD Oracle V 1.07
Are you using dbiproxy?
I don't think so.
Hi,
I found the solution - and it had nothing to do with the dbi.
I have forgotten to initialize one array, a stupid beginners mistake,
but thanks a lot to all your additional comments which also helped me
lot.
Thomas
If you are loading a large file to Informix and want to avoid the
overhead of doing many inserts, you can call dbaccess from a system call
and pipe commands to it (see below). Otherwise, you need to loop and
insert each row individually.
While I love DBI, doing inserts just isn't as fast as
See subject.
I was forced to rebuild things when patches we applied to our HPUX
development
server. Which required me to debug my own instructions. Once I re-found
the
recipe, I rebuilt and tested with the latest modules... In fact, once one
has
built perl per the instructions... The latest
- Forwarded message from Avi Vainshtein [EMAIL PROTECTED] -
Reply-To: Avi Vainshtein [EMAIL PROTECTED]
From: Avi Vainshtein [EMAIL PROTECTED]
To: Tim.Bunce [EMAIL PROTECTED]
Subject: Looking for know problems/bugs in oraperl
Date: Mon, 16 Jul 2001 16:08:58 +0200
Organization: Telrad
- Forwarded message from Vinod Patel [EMAIL PROTECTED] -
From: Vinod Patel [EMAIL PROTECTED]
To: 'Tim Bunce' [EMAIL PROTECTED]
Subject: How to write records from table to csv file?
Date: Mon, 16 Jul 2001 09:32:50 -0400
Return-Receipt-To: Vinod Patel [EMAIL PROTECTED]
Hi,
I am trying to
This is a non DBI related question, but rather a question of how to write
out comma delimeted info. See perldoc -f join, then find out why you only
have one row, which is probably due to there being only one row to fetch for
the query you are running.
Ilya
-Original Message-
From: Tim
On Mon, Jul 16, 2001 at 09:46:38AM -0400, Ronald J Kimball wrote:
On Sun, Jul 15, 2001 at 09:15:02PM +0100, Tim Bunce wrote:
On Sat, Jul 14, 2001 at 05:00:11PM -0700, Alex Algard wrote:
It was a mistake. I've deleted it now. Use...
$ary_ref = $sth-fetchall_arrayref( {} );
Great work!
Many thanks Lincoln, to you and all who have contributed.
I've bounced a copy to perl5-porters so there might be some feedback
from there.
On Mon, Jul 16, 2001 at 11:31:52AM -0400, [EMAIL PROTECTED] wrote:
built perl per the instructions... The latest DBI and DBD-Oracle works with
I know in Oracle I do something like this:
my $sth = $self-dbh-prepare(qq{ update users set
valid=0,end_date=sysdate
where id='$self-{id}' returning
$end_date
What are you trying to do. Placeholder binding? Are you asking if you can
run such a query? I don't see anything specific to Oracle here, unless
DBD::Pg does not support named placeholder, then you will have to use ?
instead of :1
Ilya
-Original Message-
From: Barry Hoggard
To:
On Mon, Jul 16, 2001 at 11:05:10AM -0600, Sterin, Ilya wrote:
What are you trying to do. Placeholder binding? Are you asking if you can
run such a query? I don't see anything specific to Oracle here, unless
DBD::Pg does not support named placeholder, then you will have to use ?
instead of
I don't believe that is possible. You can only get the number of rows
updated from the do() or execute(). You will have to run a separate select
query after update to get that info.
Ilya
-Original Message-
From: Barry Hoggard
To: Sterin, Ilya
Cc: '[EMAIL PROTECTED] '
Sent: 07/16/2001
On Mon, 16 Jul 2001, Mahdi A. Sbeih wrote:
I am trying to load data into tables using LOAD statement,
and I am getting a syntax error from this:
$db_handle-do(load from file insert into mytable)
I spent an hour investigating this, until I found out
that LOAD and UNLOAD statements can only
be
Greg,
Try changing your comparisons, for example: ($za01 == QS) to ($za01 eq 'QS')
or a pattern match, like ($za01 =~ m/QS/). This is more of a PERL issue than DBI
related to
it's use of strings.
Andy
-Original Message-
From: Greg Wardawy [mailto:[EMAIL PROTECTED]]
Sent:
The next release has:
=item CFetchHashKeyName (string, inherited) INEW
This attribute is used to specify which attribute name the
fetchrow_hashref() method should use to get the field names for the
hash keys. For historical reasons it defaults to 'CNAME' but it
is recommended to set it to
Hi,
I want to get data from HTML form and save it into
MSAccess.
On my server, I will have MSAccess table with the same
field name as HTML form fields.
I had developed form using HTML and Javascript. So now
anyone can use it online, but on submit I get all the
details in my E-mail. I want
It seems that you are not using proper module name in your use statement.
I suspect you have something like:
use dbi;
while it should be DBI;
Regards,
Anton Kokarski
-Original Message-
From: Pallavi Patil [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 2:46 PM
To: [EMAIL
You really ought to a placeholder for $self-{id} instead of pasting the
value into the SQL.
I don't think the $end_date in your SQL is doing what you expect.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Give a hobbit a fish and he eats fish for a day.
Give
The only problem I see is that you are closing the output file as soon as
you have fetched and written the first line.
You really need to include 'use strict;' near the top of your program and
'-w' on the '#!' line. They would help spot problems like that sooner.
Including $! in the file open
One definite problem with Oraperl is that it is obsolete. DBD::Oracle
includes an Oraperl emulation layer so old programs can keep working, but
any new development should use DBI methods instead of Oraperl subroutines.
There should have been more to the message. IIRC, ORA-1 is a duplicate
[EMAIL PROTECTED] writes:
$dbh-{csv_tables}-{htp}-{file} = '.htpasswd';
tnx jeff. it's working. now i can open .htpasswd using DBD::CSV
I've spent a week spinning my wheels trying to make simple tasks work
using DBD, DBI, Proxy, ProxyServer, ODBC.
I have an Access97 database that will be used internally for a HelpDesk
and it is finished except for a few reports. The second stage of the
project is to make the data accessible
29 matches
Mail list logo
