> "Steve" == Steve Howard <[EMAIL PROTECTED]> writes:
Steve> $row = $select->bind_columns(undef, \$column1, \$column2..
This is weird, but it works:
$rc = $sth->bind_columns(\@column{qw(one two three four five)});
Now $column{one} is the first column, and $column{two} is the second
col
On Wed, Mar 07, 2001 at 09:49:45AM -0700, Sterin, Ilya wrote:
> Not sure if that will help your case, but you can open the file yourself and
> then assign the file handle to STDERR, that way you can check for the file
> open yourself.
>
> if (open(FILE, "file_name"))
> {
> *STDERR = *FILE;
> DBI-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Mar 07, 2001 at 09:16:10PM -0600, Steve Howard wrote:
> My problem comes with finding a way to build reusable code for a subroutine
> to deal with tables that will not go straight across. The obstacle is in
> this statement:
>
> $row = $selec
Sorry, let me clarify, the INSERT...SELECT statement in this e-mail works
just fine. The $columnlist is built properly, and that is not a problem -
Maybe I confused the issue when I included it. I was just trying to expound
on what I was doing and maybe show to what extent I am trying to make the
Does anyone have any ideas on how to make this work:
I write a lot of scripts to do migrations. I try to make as much of my code
reusable as possible. Straight table copies are no problem after I query the
system tables to get the table, and column names, and build something like:
INSERT INTO $i
Rolf,
If need that much control over error messages, I'd leave
RaiseError => 0 and handle status checking within the
application.
Also, a method I use to temporary change RaiseError is
{
local ($sth->RaiseError) = 0;
... my s
Dan,
Do you have a test case that demos what you're trying to do and
where it errors? That would help if you could send it to me.
Also, try DBD::ADO (the newer version), see if the error occurs.
http://tlowery.hypermart.net/software_down_loads.html
Tom
On Wed, M
> Dan,
> I ran into this on a web back-end I was programming some time
> back. I wish I had better news - nobody seemed to have an answer
> that worked when it came to ODBC (not just PERL's ODBC interface
> - ODBC in general). I didn't try ADO. I understand it will work
> with DB Library connec
Hi Robert,
Many thanks.
I'll to do that.
Regards,
Tomo
- Original Message -
From: <[EMAIL PROTECTED]>
To: TomoFujimoto <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 12:58 AM
Subject: Re: DB2 server Connection from WEB server
> Hi Tomo. Read the DBD::DB
Do you know of any issues with DBI, ADO (OLE DB) or DBD::ODBC doing updates
to a MS-SQL 7.0 database that has some text "blob" columns? Are there any
patches?
I've never had any trouble with inserts to MS-SQL 7.0, except for occasional
trunction errors, so I decided to use it for other things. An
On Wed, Mar 07, 2001 at 05:57:29PM +0100, Yacine Merghoub wrote:
> Hi,
> I can't install DBI-1.14 on Debian GNU/Linux
> When I try to build I have this error message :
> /usr/bin/ld: cannot open crti.o: No such file or directory
> Please, could you give me any help !
> Thanks in advance :
> As rec
On Tue, Mar 06, 2001 at 08:38:31PM -0800, Colin Meyer wrote:
> DBI'ers:
>
> Is it possible to programmatically check on the success of a call to
> DBI->trace() or $h->trace()?
>
> For example, I'd like to know when I have called
> DBI->trace(1, '/file/that/I/cant/write/to.log').
>
> Experime
Can you put it into an environmental variable and have the script
reference that. This is hiding not encryption.
On Wed, 7 Mar 2001, Simon Dang wrote:
> Date: Wed, 7 Mar 2001 10:50:28 -0500
> From: Simon Dang <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Hiding / encrypting db login
Hi,
I can't install DBI-1.14 on Debian GNU/Linux
When I try to build I have this error message :
/usr/bin/ld: cannot open crti.o: No such file or directory
Please, could you give me any help !
Thanks in advance :
As recommended in README file I include log of a complete build with other
informatio
Your can set up tnsname is tnsnames.ora file, see docs and then use that.
Edit the line to show the correct connect information. This is the same as
using DSN in ODBC environment.
Ilya Sterin
-Original Message-
From: John Kolvereid
To: [EMAIL PROTECTED]
Sent: 03/06/2001 10:24 PM
Subject
Not sure if that will help your case, but you can open the file yourself and
then assign the file handle to STDERR, that way you can check for the file
open yourself.
if (open(FILE, "file_name"))
{
*STDERR = *FILE;
DBI->trace(2);
}
Ilya Sterin
-Original Message-
From: Colin Meyer
To: [E
After installing the DBI package did you also install the DBD::Oracle
package? You should if not. Make sure that if you will or already
installed DBD::Oracle that you install(ed) under the same perl installation
in you case 'nsperl' since the machine might have more than one perl
installation.
On Wed, Mar 07, 2001 at 10:50:28AM -0500, Simon Dang wrote:
> Simple Question:
>
> I have 2 sun machines - one is a web server and the other is for oracle.
> I have set up cgi scripts using DBI and setup DBI::ProxyServer on the oracle
> machine.
>
> What is the best way to hide/encrypt the db lo
What error did the DBI give you ($DBI::errstr that you are outputting to
STDOUT)? Also use DBI->trace(2, "filename") and then look in the "filename"
file for the trace of the process. Send that file in if you can't see the
problem.
Ilya Sterin
-Original Message-
From: Mitch Clarvit
To:
My apologies to everyone for my lack of expertise - this forum has certainly taught me
a lot about Perl. I have a new assignment which involves connecting to an Oracle
8.1.5 database which resides on a Novell Netware 5.1 server on a seperate volume
called "Oracle" then the "SYS" volume for all
Simple Question:
I have 2 sun machines - one is a web server and the other is for oracle.
I have set up cgi scripts using DBI and setup DBI::ProxyServer on the oracle
machine.
What is the best way to hide/encrypt the db login and password on the plain
text cgi scripts on the web server?
Thanks
Michael,
I ran into this problem a couple of weeks ago and found the solution
from my query to the dbi-users list.
See below for the details.
Hope this helps,
Mike
- Forwarded message from "Stewart, Michael"
<[EMAIL PROTECTED]> -
From: "Stewart, Michael" <[EMAIL PROTECTED]>
To: "'[EM
- Forwarded message from "Stewart, Michael" <[EMAIL PROTECTED]> -
From: "Stewart, Michael" <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: DBD with Oracle 8i
Date: Tue, 6 Mar 2001 08:22:26 -0800
Hi Tim
I am able to use DBI/DBD Oracle just fine with the
First of all
Ilya, Jonathan thanks for the hint on the C Compiler.
I have DBI 1.14 & DBD Oracle 1.06 installed on a Solaris.
When I try to execute my perl scripts I get the followin error:
$ nsperl miprueba.pl
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC
contains: /usr
24 matches
Mail list logo
