Re: Perl DBI Documentation Proposal: Using NULLs in Placeholders

2004-12-16 Thread Michael A Chase tech
Suggested changes {before : after}. On 12/16/2004 09:33 AM, CAMPBELL, BRIAN D (BRIAN) said: Undefined values, or C, are used to indicate NULL values. You can insert {: or} update columns with a NULL value as you would a non-NULL value. These examples insert and update the column C with a NULL valu

RE: cross-posted FAQ question [was: Win98 - DBD-Oracle install issue]

2004-12-16 Thread John Berry
Hi Jeff, Many thanks for your instant response. I did try the 5.8.0 as well with following command: C:\Perl\DBD-Oracle-1.16>ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.0/DBD-Oracle.ppd Same error persists. thanks shyam --- Jeff Urlwin <[EMAIL PROTECTED]> wrote: > I suggest upgrading

Re: Re: Re: DBD::Pg vs Pg

2004-12-16 Thread Rudy Lippan
On Tue, 14 Dec 2004, Tim Bunce wrote: > On Tue, Dec 14, 2004 at 02:54:39PM +0900, [EMAIL PROTECTED] wrote: > > Hi. > > > > >> >http://search.cpan.org/~mergl/pgsql_perl5-1.9.0/ > > >> Well,newer Pg.pm will be found here: > > >> > > >> http://gborg.postgresql.org/project/pgperl/projdisplay.php >

RE: Newbie request

2004-12-16 Thread Reidy, Ron
See below ... - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Follett, Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 3:30 PM To: [EMAIL PROTECTED] Subject: Newbie request I am a total perl newbie and was wondering if someone cou

RE: Win98 - DBD-Oracle install issue

2004-12-16 Thread Andy Hassall
> The ORACLE_HOME environment variable value (C:/ORAWIN95) is > not valid. As well as the other advice you have received, the above rings warning bells. Which version of Oracle are you running? The above looks suspiciously like a version that would run on Windows 95 - which would make it a

Newbie request

2004-12-16 Thread Follett, Robert
I am a total perl newbie and was wondering if someone could take a look at my code to determine if I am doing this the most efficient way. It works as it should, but I am sure an expert out there may have some constructive comments to help me make it better. For a little background: I am pullin

RE: cross-posted FAQ question [was: Win98 - DBD-Oracle install issue]

2004-12-16 Thread Jeff Urlwin
> > > Hi Jeff, > > Many thanks for your instant response. > > I did try the 5.8.0 as well with following command: > C:\Perl\DBD-Oracle-1.16>ppm install > ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.0/DBD-Oracle.ppd > > Same error persists. > thanks > shyam Can you try upgrading your AS to bui

RFC: New interface for Text::CSV_XS

2004-12-16 Thread Jeff Zucker
While not strictly DBI, this request for comments may be of interest to many on this list, so, with Tim's permission, I am posting here. I propose to add a new interface to Text::CSV_XS and would value comments and suggestions. This interface will be *in addition to* the existing interface so s

Perl DBI Documentation Proposal: Using NULLs in Placeholders

2004-12-16 Thread CAMPBELL, BRIAN D (BRIAN)
Fellow DBI Users, Tim Bunce has asked me to help revise the NULLs subsection in the "Placeholders and Bind Values" section in the DBI documention for DBI 1.47. Attached is the proposed text to be included, along with an associated perl script. You are invited to review them. Please send comm

Re: Perl DBI Documentation Proposal: Using NULLs in Placeholders

2004-12-16 Thread Jeff Zucker
CAMPBELL, BRIAN D (BRIAN) wrote: $sth = $dbh->prepare("CREATE TABLE $tablename (key int, mycol char(8))"); You might want to change the name of the first column since KEY is a SQL keyword and some databases will reject it. That might also apply to the NAME column in your examples. -- Jeff

RE: Please Help !!! Unable to install DBD-Oracle ( I am using perl 5.6 on solaris 8)

2004-12-16 Thread Reidy, Ron
You will need (I think) to build Perl from scratch. Check which C compiler was used to build Perl. If it is not the C compiler you have on your system, you will need to build it yourself. After that you will need to build DBI and DBD::Oracle yourself. - Ron Reidy Lead DBA Arr

RE: Please Help !!! Unable to install DBD-Oracle ( I am using perl 5.6 on solaris 8)

2004-12-16 Thread Jeff Urlwin
> > > Thanks Jeff!!! > > Yes you were right ...I installed DBI from Active State's > site earlier. > > Can you kindly let me know a place where I can get DBD-Oracle > for solaris 8 and perl 5.6 using PPM??? Please help me in this regard. As I indicated in my prior message, you will have to b

RE: cross-posted FAQ question [was: Win98 - DBD-Oracle install issue]

2004-12-16 Thread Jeff Urlwin
I suggest upgrading to the latest activestate. I see you are installing from 5.8.3, when you only have 5.8.0 (from the perl -v you sent). Were the instructions not clear enough to match? Jeff -Original Message- From: John Berry [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16,

RE: cross-posted FAQ question [was: Win98 - DBD-Oracle install issue]

2004-12-16 Thread John Berry
Hi Jeff, Gone through the suggested link: http://www.mail-archive.com/dbi-users@perl.org/msg23109.html Tried: = C:\Perl\DBD-Oracle-1.16>ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DBD-Oracle.ppd Getting an error: Can't call method "name" without a package or obj

Re: search fails if number at end of string

2004-12-16 Thread Hardy Merrill
By "no records are returned" do you mean you are trying to SELECT from an access database? Copy/paste in an example of something that's not working for you, along with what versions of these you are using: Perl DBI DBD::ODBC(?) - which DBD module are you using to access "Access"? >>> Per

Re: Is foreign_key_info() generic?

2004-12-16 Thread Tim Bunce
On Thu, Dec 16, 2004 at 01:01:46AM +0100, Bart Lateur wrote: > On Wed, 15 Dec 2004 12:46:16 +, Tim Bunce wrote: > > >> It's one of those things why people say Mysql isn't a proper database. > > > >This isn't the place to start that particular flame-fest, so I'd > >appreciate it if no one does.

RE: Please Help !!! Unable to install DBD-Oracle ( I am using perl 5.6 on solaris 8)

2004-12-16 Thread vivekananda.marellali
Thanks Jeff!!! Yes you were right ...I installed DBI from Active State's site earlier. Can you kindly let me know a place where I can get DBD-Oracle for solaris 8 and perl 5.6 using PPM??? Please help me in this regard. Thanks again!! Best Regards, Vivekananda M BP Operate - BeyondBP Phone: 00