Re: dbi-users subscription ???

2001-02-05 Thread Michael A. Chase
- Original Message - From: "Michael D. Schleif" <[EMAIL PROTECTED]> To: "DBI List Service" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 8:13 PM Subject: dbi-users subscription ??? > http://www.fugue.com/dbi/ tries to [un]subscribe from/to this list via > isc.org -- which, of cour

dbi-users subscription ???

2001-02-05 Thread Michael D. Schleif
http://www.fugue.com/dbi/ tries to [un]subscribe from/to this list via isc.org -- which, of course, no longer handles this List ;> I need to *change* my Email address; which, probably, requires un-subscribing one address and subscribing another. Can you point me to the right place? -- Best R

Re: How to get the Date + some days

2001-02-05 Thread Kiran Kumar M
Actually it will also checks in /usr/lib/perl5/site_perl/ I found it there... Eventhough with UnixDate function it is giving the same error.. Anyhow thanks for your mail.. I already got the solution in otherway. With different module... Thanks, Kiran On Mon, 5 Feb 2001, Anna Fong wrote: >

Re: How to get the Date + some days

2001-02-05 Thread Anna Fong
It appears that Date::Manip is not in your Perl's search path. Solve this by 1) use "/usr/local/lib/perl5/site_perl/Date/Manip.pm"; (substitue with actual path) or 2) use lib '/usr/local/lib/perl5/site_perl/'; use Date::Manip; At 04:14 AM 02/06/2001 +0530, Kiran Kumar M wrote: > >Yes,

Re: trouble with installation DBD-PG

2001-02-05 Thread Ron Clark
Richard Poole wrote: > > On Sun, Feb 04, 2001 at 02:37:32PM -0700, [EMAIL PROTECTED] wrote: > > I'm hoping you can point me in the right direction, I'm trying to install version >0.93 or 0.95 of DBD:Pg. I'm getting the following error with either one: > > > In file included from Pg.xs:13: > >

Re: How to get the Date + some days

2001-02-05 Thread Matt Sergeant
On Mon, 5 Feb 2001, Hardy Merrill wrote: > Matt, I was hoping that Time::Object and Time::Seconds were part > of the Perl distribution, but I couldn't find it in Perl 5.005_03 > nor 5.6. I did find it on CPAN - do you know if these will become > part of the standard distribution at some point?

RE: How to get the Date + some days

2001-02-05 Thread Kiran Kumar M
I am running on Unix clone.. LInux On Tue, 6 Feb 2001, Steven Baldwin wrote: > Silly question, but are you trying to run on a non-Unix system ? > > -Original Message- > From: Kiran Kumar M [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 6 February 2001 9:45 AM > To: Anna Fong > Cc: [EMAIL

Re: How to get the Date + some days

2001-02-05 Thread Matt Sergeant
On Tue, 6 Feb 2001, Kiran Kumar M wrote: > > Thanks, for your mail.. But for this which module should load.. It is > giving the error.. > > Can't locate Time/Object.pm in @INC (@INC > contains: /usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0 > /usr/lib/perl5/site_perl/5.6.0/i386-linux /usr

RE: How to get the Date + some days

2001-02-05 Thread Steven Baldwin
Silly question, but are you trying to run on a non-Unix system ? -Original Message- From: Kiran Kumar M [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 6 February 2001 9:45 AM To: Anna Fong Cc: [EMAIL PROTECTED] Subject: Re: How to get the Date + some days Yes, I installed it.. but it is the

Undetected error - Binding and Stored Procedures

2001-02-05 Thread Oscar DeMartino
I am running Oracle 8.1.5 and am using many stored procedures. We use returned cursors, and individual values. The problem is, when a stored procedure is executed and the specified bound variable has not be declared large enough to hold the returned value subsequent bound variables do not get se

Re: How to get the Date + some days

2001-02-05 Thread Kiran Kumar M
Thanks, I downloaded Time::Object from CPAN, now its working.. Thanks, Kiran On Mon, 5 Feb 2001, Hardy Merrill wrote: > Matt, I was hoping that Time::Object and Time::Seconds were part > of the Perl distribution, but I couldn't find it in Perl 5.005_03 > nor 5.6. I did find it on CPAN - do y

Re: How to get the Date + some days

2001-02-05 Thread Kiran Kumar M
Yes, I installed it.. but it is the same... Undefined subroutine &main::UnixDate called at test5 line 3. Thanks, Kiran On Mon, 5 Feb 2001, Anna Fong wrote: > use Date::Manip; > > > At 04:04 AM 02/06/2001 +0530, Kiran Kumar M wrote: > > > >Where are the functions UnixDate, DateCalc. > > >

Re: How to get the Date + some days

2001-02-05 Thread Hardy Merrill
Matt, I was hoping that Time::Object and Time::Seconds were part of the Perl distribution, but I couldn't find it in Perl 5.005_03 nor 5.6. I did find it on CPAN - do you know if these will become part of the standard distribution at some point? Hardy Merrill Matt Sergeant [[EMAIL PROTECTED]] w

Re: How to get the Date + some days

2001-02-05 Thread Anna Fong
use Date::Manip; At 04:04 AM 02/06/2001 +0530, Kiran Kumar M wrote: > >Where are the functions UnixDate, DateCalc. > >Thanks, >Kiran > >On Mon, 5 Feb 2001, Anna Fong wrote: > >> Try this: >> >> >> $old_date = &UnixDate("today", "%E of %b %Y"); >> $new_date = &DateCalc("$old_date","+10

Re: How to get the Date + some days

2001-02-05 Thread Kiran Kumar M
Where are the functions UnixDate, DateCalc. Thanks, Kiran On Mon, 5 Feb 2001, Anna Fong wrote: > Try this: > > > $old_date = &UnixDate("today", "%E of %b %Y"); > $new_date = &DateCalc("$old_date","+10days"); > $new_date = &UnixDate("$new_date", "%E of %b %Y"); > > > HTH, > Anna >

Re: How to get the Date + some days

2001-02-05 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, Feb 06, 2001 at 03:43:48AM +0530, Kiran Kumar M wrote: > How can I get the Date + some days (for example 6th of Feb 2001 + 10 > should give 16th of Feb 2001...). How can I achieve this. I installed > Date::calc perl module... And `perldoc Dat

Re: How to get the Date + some days

2001-02-05 Thread Kiran Kumar M
Thanks, for your mail.. But for this which module should load.. It is giving the error.. Can't locate Time/Object.pm in @INC (@INC contains: /usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0 /usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl .) a

Re: How to get the Date + some days

2001-02-05 Thread Anna Fong
Try this: $old_date = &UnixDate("today", "%E of %b %Y"); $new_date = &DateCalc("$old_date","+10days"); $new_date = &UnixDate("$new_date", "%E of %b %Y"); HTH, Anna At 03:43 AM 02/06/2001 +0530, Kiran Kumar M wrote: > > >Hi, > >How can I get the Date + some days (for example 6th of F

Re: How to get the Date + some days

2001-02-05 Thread Matt Sergeant
On Tue, 6 Feb 2001, Kiran Kumar M wrote: > > > Hi, > > How can I get the Date + some days (for example 6th of Feb 2001 + 10 > should give 16th of Feb 2001...). How can I achieve this. I installed > Date::calc perl module... use Time::Object; use Time::Seconds; my $today = localtime; my $today

How to get the Date + some days

2001-02-05 Thread Kiran Kumar M
Hi, How can I get the Date + some days (for example 6th of Feb 2001 + 10 should give 16th of Feb 2001...). How can I achieve this. I installed Date::calc perl module... Thanks, Kiran

bind param problem

2001-02-05 Thread Rajesh Yenumulapally
Hi I wrote a script which using bind param function of the DBI and it works perfectly fine on one server but not on the other one. My first server has the perl 5.003/DBI 0.79 and my second server has perl 5.6.0/DBI 1.13.I noticed that the bind param function stopped taking empty strings as one o

(Fwd) bind param problem

2001-02-05 Thread Tim Bunce
- Forwarded message from Rajesh Yenumulapally <[EMAIL PROTECTED]> - Date: Mon, 5 Feb 2001 11:11:13 -0800 (PST) From: Rajesh Yenumulapally <[EMAIL PROTECTED]> Subject: bind param problem To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] sorry the regular mailing list is not work

Re: Creating a maxlength parameter in DBI

2001-02-05 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, Feb 05, 2001 at 04:12:57PM -0500, Jeff Suszczynski wrote: > My question, then, is this: Is there a way to only open the BLOB information > for records with BLOBs containing less than a certain number of characters > (i.e. 2000 characters)? T

Creating a maxlength parameter in DBI

2001-02-05 Thread Jeff Suszczynski
I am currently using Perl 5.00503, DBI 1.14 and DBD::Oracle 1.06 on an Oracle 8 database. I have encountered a problem in trying to open BLOBs beyond a certain length. It seems that while my script works well for records smaller than that certain length (I believe it to be 2000 characters), i

InterScan NT Alert

2001-02-05 Thread postmaster
Receiver, InterScan has detected virus(es) in the e-mail attachment. Date: Tue, 06 Feb 2001 06:36:00 +1100 (AUS Eastern Daylight Time) Method: Mail From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> File: hpux, osvers=10.20, archname=9000/777-hpux uname='hp-

Re: trouble with installation DBD-PG

2001-02-05 Thread Richard Poole
On Sun, Feb 04, 2001 at 02:37:32PM -0700, [EMAIL PROTECTED] wrote: > I'm hoping you can point me in the right direction, I'm trying to install version >0.93 or 0.95 of DBD:Pg. I'm getting the following error with either one: > In file included from Pg.xs:13: > Pg.h:13: libpq-fe.h: No such file

RE: :Oracle Installation Problems on HP-UX 10.20

2001-02-05 Thread Metzler, Larry
Have you tried using static linktype on the Makefile.PL? I had to under HPUX (from the README) make realclean perl Makefile.PL LINKTYPE=static make make perl (you'll need to use and install _this_ new perl binary) make test make -f Makefile.aperl inst_perl MAP_TARGET=perl (i

Re: How to set up environment variables dynamically

2001-02-05 Thread susan_g_white
To get around this problem, I created a file with the environment variables set as I need them for the perl scripts. I then "require" this file at the beginning of the script i.e. require("/u01/app/oracle/oracle_env.pl"); I use this same script for all my perl programs, resetting dynamic variab

How to set up environment variables dynamically

2001-02-05 Thread Chen, Ze
Hi, My Perl CGI script work from the command line, but, doesn't work under the httpd. I know it is caused by environment variables/setting ( such as ORACLE_HOME etc.). I tried to use BEGIN at the beginning of the script to set up these environment variables; and tried to use "use lib..." to prep

DBD::Oracle Installation Problems on HP-UX 10.20

2001-02-05 Thread Hans-J. Krause
Hi, I have a problem in installing DBD::Oracle 1.0.6 on our Server (HP-UX 10.20 with Perl 5.6.0, DBI 1.14 and CGI.pm 2.74). I am trying to connect to an Oracle 8.0.5 (ORACLE_HOME and _SID is set in environment). Any CGI-Script fails with: "Software error: install_driver(Oracle) failed: Can't loca

Re: DBD::Chart ?

2001-02-05 Thread Dean Arnold
I had struggled with how to extend the Chart and/or GD::Graph modules to better "mate" with the DBI apps I'm targeting. It needed to be able to handle output directly from DBI bound parameters (ala bind_col()), needed a comprehensible specification language (ala SQL) instead of a mishmash of hashe

RE: MySQL Limit Clause/MS-SQL 7 Equivalent

2001-02-05 Thread Mitchell, Louise M
I believe the 'set rowcount' will finitely limit the query... ie, you'll only get back that many rows... you won't be able to 'continue'... if that's what you want, that will work... L -Original Message- From: Michael Peppler [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 2:

Re: DBD::Oracle - Bind value of space wrongly interpreted as NULL

2001-02-05 Thread James E Jurach Jr.
Tim Bunce wrote on 08/11/2000 10:22:14: > I need a volunteer to write a test script (like the other t/*.t files) > that will... create a table with NULL and NOT NULL variants of CHAR and > VARCHAR columns, and then do a series of inserts and selects with and > without trailing spaces etc with ora_

Re: Oracle & DBI

2001-02-05 Thread Ronald J Kimball
On Mon, Feb 05, 2001 at 08:48:24AM -0500, Seger, Jeffrey wrote: > I believe you may have to escape that '*' (\*) or use single quotes. * has no special meaning inside double quotes, so escaping it with a backslash is not necessary. Ronald

RE: ppm error - DBI installation

2001-02-05 Thread Bowman, Brent A
I had this problem when I was trying to install a PPM while on a private intranet. It turns out that these PPM files are simply pointers written in an XML type language that tells the ppd thingy where to find the source. Just go into the PPM file with an ASCII text editor. From there, you can se

RE: Oracle & DBI

2001-02-05 Thread Seger, Jeffrey
I believe you may have to escape that '*' (\*) or use single quotes. If that doesn't work, try selecting specific column names. -Original Message- From: Michael Officer [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 8:30 PM To: [EMAIL PROTECTED] Subject: Oracle & DBI I've

Re: ppm error - DBI installation

2001-02-05 Thread Michael A. Chase
Read the PPM documentation. It includes methods for installing from the local disk and from behind a firewall. Either of those could be causing your problem. Installing the latest ActiveState Perl distribution may help too. -- Mac :}) ** I normally forward private database questions to the DBI

Re: dbi installation

2001-02-05 Thread Michael A. Chase
ActiveState Perl is distributed for free. That also allows you to install DBI and DBD-Oracle using PPM. If you are using something other than ActiveState Perl, it looks to me that you can't afford to not upgrade to it. -- Mac :}) ** I normally forward private database questions to the DBI mail l

Re: DBD::Chart ?

2001-02-05 Thread Tim Bunce
I agree. Tim. On Mon, Feb 05, 2001 at 03:36:28PM +0800, Reinke Bonte wrote: > I'm not an experienced programmer, but your suggestion does not make much > sense to me. Wouldn't your effort be better spent on improving the existing > chart method? In that way non-dbi-users can use your method with

ppm error - DBI installation

2001-02-05 Thread Meng Yoke
Hi, I encountered error during PPM for DBI installation. When I perform "search DBI", I can get a list of modules for DBI. But when I executed "install DBI" I get "Could not locate a PPM binary of 'DBI' for this platform" error (see the end of this mail). Any help? regards, yoke PPM> searc