Re: Q: SQL constructs for 'match all' v 'match any'

2003-06-13 Thread Ron Savage
On Sat, 14 Jun 2003 15:22:31 +1000, Ron Savage wrote: See below for my first attempt. >Hi Folks > >Let's say I have search form with fields like these, for >Organizational Entities: >o Name >o Code >o Cost center >o Fund > >My customer wants a search option with 2 choices: >o Match all >o Match a

Re: Archives

2003-06-13 Thread Fred T Sanders
yes I meant CSV not CVS, long night. Thanks, Fred On June 14, 2003 1:33 am, Jeff Zucker wrote: > Fred T Sanders wrote: > >Hi All > > > >Before I ask stupid questions about problems I'm having getting DBI to > > work with CVS files, I was wondering if there were an archive of past > > posts I co

Re: Archives

2003-06-13 Thread Jeff Zucker
Fred T Sanders wrote: Hi All Before I ask stupid questions about problems I'm having getting DBI to work with CVS files, I was wondering if there were an archive of past posts I could browse through first. The place to start is almost always http://dbi.perl.org It has links to the mailing

Archives

2003-06-13 Thread Fred T Sanders
Hi All Before I ask stupid questions about problems I'm having getting DBI to work with CVS files, I was wondering if there were an archive of past posts I could browse through first. TIA, Fred

Q: SQL constructs for 'match all' v 'match any'

2003-06-13 Thread Ron Savage
Hi Folks Let's say I have search form with fields like these, for Organizational Entities: o Name o Code o Cost center o Fund My customer wants a search option with 2 choices: o Match all o Match any meaning that if the Entity's name and fund are entered, then 'match all' will operate like AND o

Perl:DBI:Oracle

2003-06-13 Thread Biswajeet Padhy
Hi, I am a perl developer going to install Perl DBI in solaris which require make utility. But I don't have a C compiler on my UNIX Box. Is there any pre compiled version of Perl:DBI and DBD:Oracleis available so that I can directly install on my BOX. Biswajeet

Re: Help with new DBI::ProxyServer error messages

2003-06-13 Thread John Cougar
Hi Tim Thanks for getting back to me! On Fri, 13 Jun 2003, Tim Bunce wrote: > Upgrade the server DBI version. > > Tim. > > On Thu, Jun 12, 2003 at 12:02:29PM +1000, John Cougar wrote: > > Heya folks > > > > I've recently upgraded the DBI and DBD packages on a development server, > > and I'm n

Re: Problem with DBD-Oracle 1.14 and Cygwin

2003-06-13 Thread Kevin White
dbdimp.c: In function `ora_db_login6': dbdimp.c:291: warning: cast to pointer from integer of different size dbdimp.c: In function `pp_exec_rset': dbdimp.c:1193: internal error: Segmentation fault (Which is why I was looking at the gcc versions.) Any ideas? Sure looks like a compiler bug. Tim.

Re: Query formatting problem

2003-06-13 Thread Ian Harisay
Hi, Here is a code snippet that will accomplish your desired task. This is not meant to be generic. It does have some limitations. It will satisfy the problem presented. How you integrate it with you code will be up to you. Regards, Ian #!/usr/bin/perl use strict; use DBI; my @login = (

DBD for Teradata?

2003-06-13 Thread Adriano Rodrigues Ferreira
The only DBD driver for Teradata available out there is DBD::Teradata? I am having trouble to work with DBD::Teradata 1.13 (the version available in CPAN) and the commercial version is too expensive. There are no other options? Regards, Adriano. -- Using M2, Opera's revolutionary e-mail client:

RE: DBD::Oracle - wrong ELF class: ELFCLASS64

2003-06-13 Thread Richard Felkins
Ken, The compiler is the latest version from Sun as Forte or I guess it is SunOne now. I had tried to build a 5.8 64 bit Perl a few months back and ran into serious make problems and abandoned that idea. I have checked and have the sparcv9 version of ld in the path. This Oracle is patched to 9

Re: No error string and unitialized value in concatenation

2003-06-13 Thread Tim Bunce
On Fri, Jun 13, 2003 at 11:43:36AM +0100, Martin J. Evans wrote: > Hi, > > Just noticed this problem when my database was down: > > #!/usr/bin/perl -w > use DBI; > my $dbh = DBI->connect("dbi:ODBC:testviagamb", >"Fred", >"Bloggs"); > > Use of unini

error in installing DBI

2003-06-13 Thread china
Hai, While installing dbi on Linux/SuSE machine I got an error. I entered as a root on the machine. When I executed the command perl Makefile.PL it gave the following error Unable to open the file MakeMaker.tmp : permission denied at /usr/lib/perl5/5.6.1/ExtUtils/makeMaker.pm at line number 759.

No error string and unitialized value in concatenation

2003-06-13 Thread Martin J. Evans
Hi, Just noticed this problem when my database was down: #!/usr/bin/perl -w use DBI; my $dbh = DBI->connect("dbi:ODBC:testviagamb", "Fred", "Bloggs"); Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/site_perl/5.6.1/i686-l

Re: ActiveState Awards

2003-06-13 Thread Tim Bunce
I've no problem with people voting early. I would have a *big* problem with people voting often! Please don't, and please don't encourage others to. Tim. p.s. I think the order is reverse alphabetical. Somebody has to be last. FYI, I've voted for Jarkko Hietaniemi. On Thu, Jun 12, 2003 at 11:3

Re: Query formatting problem

2003-06-13 Thread Tim Bunce
On Thu, Jun 12, 2003 at 11:55:05AM -0500, Steven Lembark wrote: > Using the placeholders makes my life simpler since the > name and value are taken from the same variable but > DBI handles the stringy/numeric issues for itself. The > problem starts when admin's have to check why something > failed

Re: Help with new DBI::ProxyServer error messages

2003-06-13 Thread Tim Bunce
Upgrade the server DBI version. Tim. On Thu, Jun 12, 2003 at 12:02:29PM +1000, John Cougar wrote: > Heya folks > > I've recently upgraded the DBI and DBD packages on a development server, > and I'm now getting some new error messages that are raising some concern. > I found references to recent