Re(2): RE: .htpasswd and DBD::CSV

[EMAIL PROTECTED] writes: Yeah well, to open an .htpasswd you just use split.. open (HT, "<.htpasswd") or die; while (chomp ($line = )) { @flds = split (/:/, $line); # do your DBI stuff } this is easy!! what's the problem? i thought it's like DBD::CSV where i can connect to a CSV file and us

Re: getting return messages from non-selects in Informix

Thanks for including Informix in the subject! I've seen answers from Ilya Sterin and Doug Wilson too, but I think I'm adding useful new information, albeit somewhat belatedly. Curt Russell Crandall wrote: > I have a FCGI script that lets you enter an sql statement in a textbox and > on submit t

RE: RE: .htpasswd and DBD::CSV

Text::CSV_XS as Orlando mentiones is easy to use and is pretty fast and easy to use. Can read file, , and strings. Ilya > -Original Message- > From: Perl DBI [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 12, 2001 1:32 AM > To: [EMAIL PROTECTED] > Subject: Re: RE: .htpasswd and DBD

Re: RE: .htpasswd and DBD::CSV

[EMAIL PROTECTED] writes: >On Thu, 12 Jul 2001, Perl DBI wrote: >.. >> yes. i already tried it. > >in my experience DBD::CSV can be iffy. I just use Text::CSV_XS (where you >can better control delimiters and stuff) and DBD::RAM. =) which one can open a .htpasswd? and easy to use?

Re: [Re: [Re: (Fwd) Just direct me where to go]] - Distributing DBD::Informix (and Perl and DBI)

"Michael A. Chase" wrote: > I am not a lawyer and don't even play one on TV. You'll have to ask your > corporate counsel to look at the license options that come with Perl. As > far as I know there is no one out looking eagerly for violators, so as long > as you make a good faith effort to comp

Re: DBI is not catching the [Informix] error

"Mahdi A. Sbeih" wrote: > I am trying to access an Informix database, that I have only connect > permissions, > and I am trying to 'eval' the code below, but for some reason that I can't > identify, > no error occurred in the first 2 select statements, the error occurred at > third > SQL statemen

Re: DBI is not catching the [Informix] error

"Mahdi A. Sbeih" wrote: > Hi all, > > I am trying to access an Informix database, that I have only connect > permissions, > and I am trying to 'eval' the code below, but for some reason that I can't > identify, > no error occurred in the first 2 select statements, the error occurred at > third >

RE: .htpasswd and DBD::CSV

On Thu, 12 Jul 2001, Perl DBI wrote: .. > yes. i already tried it. in my experience DBD::CSV can be iffy. I just use Text::CSV_XS (where you can better control delimiters and stuff) and DBD::RAM. =) -- Orlando Andico <[EMAIL PROTECTED]> Mosaic Communications, Inc. -BEGIN GEEK CODE BLOCK

RE: Access MSSQL from Unix using DBI

Well, what have you tried?? You can either install third party ODBC software and use DBD::ODBC or use DBD::Proxy and DBI::ProxyServer. Ilya > -Original Message- > From: Venkataramana Mokkapati [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 12, 2001 12:41 AM > To: [EMAIL PROTECTED] >

Access MSSQL from Unix using DBI

I guess, it should be possible. But I have NOT been able to accomplish this. Any clue/help will be greatly appreciated. Thanks, MVRamana _ Get your FREE download of MSN Explorer at http://explorer.msn.com

RE: .htpasswd and DBD::CSV

yes. i already tried it. [EMAIL PROTECTED] writes: >I could be wrong but have you tried "\.prog" instead. > >adrian > >-Original Message- >From: Perl DBI [mailto:[EMAIL PROTECTED]] >Sent: Thursday, 12 July 2001 16:09 >To: [EMAIL PROTECTED] >Subject: .htpasswd and DBD::CSV > > >how can i

Re: upgrade to newer version of Informix Client SDK

"Mahdi A. Sbeih" wrote: > Hi, Please include Informix in the subject line when you are asking about -- I was sorely tempted to delete 200+ messages not marked with Informix, but didn't, so I spotted your question. You are lucky. > I have a working environment of DBI, we want to upgrade to >

.htpasswd and DBD::CSV

how can i connect to .htpasswd using DBD::CSV? particularly those file with period (.) at the beginning. this is the error im getting. DBD::CSV::db prepare failed: Parse error near .prog where progname='Prepaid Domains' at /usr/lib/perl5/site_pe rl/5.005/DBD/File.pm line 164. Can't call method

RE: Inserting a concatenated string as a SET

I would first advise reading a book on SQL. Since I have never seen an "insert into table set ..." syntax in standard SQL, so I can imagine this is wrong too. Then you should read the docs on placeholders, since they can only hold values to be bounded and not 90 percent of the query. After doin

Inserting a concatenated string as a SET

Hi, I'm trying to insert a long concatenated string from a hash of hashes into an sql db. I have not had much luck? Whats the best manner to do this? sub mysend { #send the data to the db my($DMConcat); my($ToConcat); $dbh = DBI->connect("DBI:mysql:en_us:xena", "", ""); $q

Re: Perl and Postgres

On Wed, 11 Jul 2001, Wim De Hul wrote: > > I'm trying to install DBI 1.18 on a Sparc Solaris 8 server but I still > get the following error: > /usr/perl5/5.00503/ExtUtils/xsubpp -typemap > /usr/perl5/5.00503/ExtUtils/typemap Perl.xs >xstmp.c && mv xstmp.c Perl.c > cc -c -xO3 -xdepend-DV

Perl and Postgres

Hello, I'm trying to install DBI 1.18 on a Sparc Solaris 8 server but I still get the following error: bash-2.03# perl Makefile.PL *** Note: The optional PlRPC-modules (RPC::PlServer etc) are not installed. If you want to use the DBD::Proxy driver and DBI::ProxyServer modules, then you

Re: Oracle BLOB problem

Why not do something like this? my $sql =bind_param(1, $blob1, { ora_type => ORA_BLOB, ora_field=>'blob1'}); $sth->bind_param(2, $blob2, { ora_type => ORA_BLOB, ora_field=>'blob2'}); $sth->execute() or confess $DBI::errstr; Works for me ... -j --

Re: Single value

"Rozengurtel, Daniel" <[EMAIL PROTECTED]> wrote: > Hello people. > Does anybody know how to retrieve a single value from a DB? I did exactly this today, thus: ($val) = $sth_check->fetchrow_array; John A

RE: Single value

>Hello people. >Does anybody know how to retrieve a single value from a DB? >EX: select ID from my_table where my_key='12345'; >I have used a :selectrow_array() but its not a good idea to instantiate >an >array for retrieving only one value. Why not? There is ofcourse fetchrow_arrayref, fetchro

Single value

Hello people. Does anybody know how to retrieve a single value from a DB? EX: select ID from my_table where my_key='12345'; I have used a :selectrow_array() but its not a good idea to instantiate an array for retrieving only one value. Thanx Dan Daniel Rozengurtel Analyst II -Data Mining/WHSE

FW: Need some help with DBI/ODBC

Forwarded from dbi-dev, since it belongs here. -Original Message- From: Sterin, Ilya To: 'Patricio M. Rueda '; '[EMAIL PROTECTED] ' Sent: 07/11/2001 11:24 AM Subject: RE: Need some help with DBI/ODBC Also this should not go to dbi-dev, which is only for DBI **development**, next time ple

Re: Unable to install Perl DBD module (DPR#5540)

You were already talking to ActiveState for this problem and they gave you what looks like a reasonable answer; at least as a starting point. Why are you asking here now? They are the experts on PPM since it's their program. -- Mac :}) ** I normally forward private questions to the appropriate m

RE: switching to a different database from a DSN

Some databases allow you to share tables form others, so you could try that, I think that it is called a Database Link. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 11 July 2001 14:18 > To: [EMAIL PROTECTED] > Subject: switching to a different databas

Re: how to revert to old version

Your problem is far more likely to be caused by too old a version of DBI or DBD::Oracle than too new a version. DBI 0.92 was replaced more that two years ago and no one here would be able to give you reliable advice on such an old version. There have also been many bug fixes and improvements mad

RE: problem with DBD::Oracle and varchar

the value is definitely being truncated. But on another note, needing a quick fix, I grabbed 1.07 and compiled/installed it. that seems to have fixed it. I guess it was a 1.03 issue? still have 1.03 on another box to tinker with. Either way, thank you. -Original Message- From: Scott T

RE: problem with DBD::Oracle and varchar

Curious Question, Are you sure the value is not 50 characters long. It is a varchar and will not return a 100 if the length is less. On 11-Jul-01 Bill Goerlich wrote: > I'm selecting from a table which has a varchar(100) ... but am only > receiving the first 50 characters. > In the s

RE: problem with DBD::Oracle and varchar

trace() it. Ilya -Original Message- From: Bill Goerlich To: '[EMAIL PROTECTED]' Sent: 7/11/01 7:59 AM Subject: problem with DBD::Oracle and varchar I'm selecting from a table which has a varchar(100) ... but am only receiving the first 50 characters. In the same table/select I am also g

problem with DBD::Oracle and varchar

I'm selecting from a table which has a varchar(100) ... but am only receiving the first 50 characters. In the same table/select I am also grabbing a field which is defined as a long, and not having any problems. ( I set $dbh->{'LongReadLen'} = 3; for the long field, which did the trick there)

Re: DBD Oracle from remote machine

Hi, Install the oracle client on machine B and compile/install the DBD-Oracle module. You don't need to have a database or all the software on Machine B but you do need the client software to talk to Oracle. If you search the list archive, you can find out a list of files you need to ha

RE: DBD Oracle from remote machine

As far as I know, you will need to install Oracle client on machine B in order to compile DBD::Oracle on B. Regards, Mahdi. -Original Message- From: Shashi Shina [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 3:41 PM To: [EMAIL PROTECTED] Subject: DBD Oracle from remote machi

Re: Oracle BLOB problem

On Wed, Jul 11, 2001 at 01:49:35PM +0200, Christian Gruber wrote: > Here the problem: I can't perform an insert statement that has more > than one BLOB. I use bind_param(, {ora_type=>ORA_BLOB}) to bind > the parameters, which works fine for one single BLOB. But when the > insert statement con

switching to a different database from a DSN

Hi all, I am using DBI::ODBC on windows platform to access Informix database. I defend database x when I created the DSN. Is there a way to switch to a database different from the one defined when creating the DSN. In other words use the same DSN to access all the database on the same database

RE: Oracle BLOB problem

Guess it wasn't the limitation. I believe I read about it somewhere, but then I might be mistaken. Ilya > -Original Message- > From: Christian Gruber [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 11, 2001 8:21 AM > To: Sterin, Ilya > Subject: RE: Oracle BLOB problem > > > Sterin, I

RE: Oracle BLOB problem

Correct me if I am wrong, but I don't believe you can. I believe that's an Oracle (not DBD::Oracle) limitation. You will probably have to do an insert and an update. Ilya > -Original Message- > From: Christian Gruber [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 11, 2001 7:50 AM >

Oracle BLOB problem

Hello! I'm using DBI 1.18, DBD::Oracle 1.07 and Perl 5.005_05. My Software is running on Linux and I am working with Oracle 8.1.7. Here the problem: I can't perform an insert statement that has more than one BLOB. I use bind_param(, {ora_type=>ORA_BLOB}) to bind the parameters, which works f

Fw: Unable to install Perl DBD module (DPR#5540)

Hi Tim Bunce, I am getting the following errors: I have also tried using PPM facility and it still does not work. I get the error: Cannot locate ppd file. I was told by Shantel Shave that a patch could be written to fix for the problem I have below. Can you advice appropriately? Thanks and R

how to revert to old version

Hi, Hope you can provide me some answers. 1) where can I get older version for DBI & DBD Oracle, like my existing from /usr/local/lib/perl5/site_perl/DBI/DBD.pm $Revision: 1.8 $ $Date: 1998/02/04 17:35:24 $ from /usr/local/lib/perl5/site_perl/DBI.pm

Re: Problems Installing DBD

On Tue, Jul 10, 2001 at 09:25:57PM -0400, Pereira, Adrian non Unisys wrote: > Hi > > I have difficulty installing DBD for Oracle on a solaris 2.5 system. I have > read as much doco and archives and cant find the cause of it can anyone > help? It's a bug in the oci7 code in that release of DBD::

Ann: New QaDRAM Release! B342

QaDRAM 1.0 FIELD TEST 1 BUILD 342 Hello: I proud to announce the next release of QaDRAM! You can download it from http://www.qadram.com in the Downloads section. In a few days I will publish some samples I have made on the usage of each object. Feel free to send me any question you have. The main