Re: Make error on DBI-1.18 on HP-UX 11i

2002-12-11 Thread Jonathan Leffler
Graham Maloon wrote: When issuing the make, I get the errors below. DBI v1.18 is 14 versions out of date - v1.32 is current. Also read: http://www.tuxedo.org/~esr/faqs/smart-questions.html Do yourself a favour and get the current version. gcc -c-D_HPUX_SOURCE -fno-strict-aliasing -D

Re: (Fwd) Question about Oracle DBD:DBI

2002-12-11 Thread Jonathan Leffler
Pauley, Alan wrote: I tried to install DBI-1.32 on my Solaris 8 machine. The perl Makefile.PL ran fine. I than ran the make and got about ten pages of errors. I have been reading the README files and other doc's on CPAN, but I'm still a little confused. Should I install perl -5.8.0 and try this

RE: :ODBC Test Errors on MS SQL??

2002-12-11 Thread Jeff Urlwin
Lance, > Platform: RedHat 7.3 Ok, I test w/SUSE 7.x > DBI: Latest Version My version is 1.30 > DBI::ODBC: Version 1.0 > Using the EasySoft ODBC Bridge as the transport to the > Microsoft Server... > latest version. I tested this version using Easysoft's OOB version 1.0.0.32, unixODBC 2.2.3 an

DBI::ODBC Test Errors on MS SQL??

2002-12-11 Thread Lance Wilson
Platform: RedHat 7.3 DBI: Latest Version DBI::ODBC: Version 1.0 Using the EasySoft ODBC Bridge as the transport to the Microsoft Server... latest version. I already have the ODBC bridge working correctly, tested, should be fully ODBC 3.0 compliant, etc. No problems installing the DBI Software a

Interesting problem with Cache::MemoryCache

2002-12-11 Thread Ken Miller
I'm playing around with using Cache::MemoryCache to store some database 'objects'. However, when I stuff an object into the cache, and the cache goes out of scope, I get these messages: SV = RV(0x8f11e0) at 0x8f41cc REFCNT = 1 FLAGS = (ROK) RV = 0x8f41d8 (in cleanup) dbih_getcom han

Re: Problem installing DBI: "can't locate Time/HiRes.pm in @INC"

2002-12-11 Thread Tim Bunce
On Wed, Dec 11, 2002 at 03:50:14PM -0500, Francis Hwang wrote: > I'm doing a server migration and having trouble installing DBI. t/40profile > isn't compiling, I guess, because it can't find Time/HiRes: > > It seems like this is a prereq that's going to be taken out of DBI, as Tim > Bunce writes a

Re: t/10examp failed on solaris8

2002-12-11 Thread Tim Bunce
I'm not sure why it's happening, but unless you depend on Tainting I think you could ignore that test failure. Tim. On Wed, Dec 11, 2002 at 10:04:44AM +0100, [EMAIL PROTECTED] wrote: > The test t/10examp failed with perl 5.005_03 for sun4-solaris. > > > > t/10examp...Insecure dependen

Problem installing DBI: "can't locate Time/HiRes.pm in @INC"

2002-12-11 Thread Francis Hwang
I'm doing a server migration and having trouble installing DBI. t/40profile isn't compiling, I guess, because it can't find Time/HiRes: t/40profileCan't locate Time/HiRes.pm in @INC (@INC contains: blib/arch blib/lib /usr/lib/perl5/5.6.1/i386-linux /usr/lib/perl5/5.6.1/i386-linux /usr/

Re: ACT! (version 4) for Windows -- is there support?

2002-12-11 Thread Michael R. Wolf
[EMAIL PROTECTED] (Unknown Sender) writes: > You've got two options for interacting with ACT! via Perl. > You can use the Win32::OLE modules to interface with ACT! methods > and you can access the database files via DBD::ODBC or DBD::XBase. > > Have fun reading the SDK and the rest of ACT!'s tech

Installing DBD oracle 1.12 over HPUX11i

2002-12-11 Thread Daniel Tong
I have a trouble to install DBD:Oracle 1.12. environment: perl 5.8 build from source (I configured as use 64 bit possible) OS: HPUX11i (64bit) Oracle: 9.2(64bit) C complier: ansic C I installed perl5.8, fine (

Make error on DBI-1.18 on HP-UX 11i

2002-12-11 Thread Graham Maloon
When issuing the make, I get the errors below. Please help. Thanks Graham gcc -c-D_HPUX_SOURCE -fno-strict-aliasing -D_LARGEFILE_SOURCE -D VERSION=\"1.18\" -DXS_VERSION=\"1.18\" -fPIC "-I/usr/local/lib/perl5/5.8.0/PA-R ISC2.0/CORE" -Wall -Wno-comment -DDBI_NO_THREADS Perl.c In file

Error: no suitable installation target found for package DBD-Orac le

2002-12-11 Thread Brian Kuhn
Hello, I need some help. I've been trying to install DBD-Oracle all day. Other modules (DBD-ODBC, DBI) have installed fine, but for some reason, I get "Error: no suitible installation target found for package DBD-Oracle." Has anyone else gotten this error before/know how to fix it? I've incl

Re: /hpx/work/ee/8.1.7.4/hpx32/src_0424/lib

2002-12-11 Thread ulairi
This insanity it caused by the Makefile.PL somehow parsing in way (and I do mean WAY) too many -l switches for the compile line, which overloads the ld parser. I'm not a good enough coder to actually find and fix the problem, but here's what I found as a solution. Perhaps someone who codes better t

t/10examp failed on solaris8

2002-12-11 Thread anders . reggestad
The test t/10examp failed with perl 5.005_03 for sun4-solaris.   t/10examp...Insecure dependency in parameter 1 of DBI::st=HASH(0x1cea04)->FETCH method call while running with -T switch at t/10examp.t line 320. DBI handle cleared whilst still active.     dbih_clearcom (sth 0x1cf

RE: (Fwd) Question about Oracle DBD:DBI

2002-12-11 Thread Pauley, Alan
Title: RE: (Fwd) Question about Oracle DBD:DBI I tried to install DBI-1.32 on my Solaris 8 machine. The perl Makefile.PL ran fine. I than ran the make and got about ten pages of errors. I have been reading the README files and other doc's on CPAN, but I'm still a little confused. Should

Re: DBI with arrays assigned in SQL

2002-12-11 Thread Michael A Chase
On Wed, 11 Dec 2002 12:16:41 - "Ho, Tony" <[EMAIL PROTECTED]> wrote: > In my Perl code, I declare an array, say @some_array. > I later open a file with a column of numbers i.e. > 1 > 2 > 3 > . > and assign these values the array using the unshift command. > i.e. > while (<..>) { > unshif

Re: Calling Sorted Procedure

2002-12-11 Thread Michael A Chase
On Wed, 11 Dec 2002 08:48:52 +0200 Rami Shibli <[EMAIL PROTECTED]> wrote: > I need some help regarding sorted procedures on ORACLE; I need to call the > sorted procedure from my application that returns a string. And I don't know > how to do it It's in the fine manual: http://xmlproj.com/fom-serv

RE: Calling Sorted Procedure

2002-12-11 Thread Breedlove, Robert
I assume you mean stored procedures. Here's a function that does it for me. This procedure stored information into the database. sub UpdateSLIC { my ($notice_id, $noticetype, $postdate, $sysstatus, $start_date, $end_date, $cancelsnotice, $state, $noticetext) = @_; $ENV{'OR

Re: DBI with arrays assigned in SQL

2002-12-11 Thread darren chamberlain
On Wednesday, December 11, 2002, at 01:47 PM, Bong Tumanut wrote: > I just did some testing. Your SQL is > SELECT ... IN 1 2 3 > That's syntactically incorrect. IIRC, IN requires parens and commas: $sql = "SELECT ... IN (" . join(", ", @some_array) . ")"; Or just: local $" = ", "; $sql =

Re: DBI with arrays assigned in SQL

2002-12-11 Thread Marcel Grünauer
On Wednesday, December 11, 2002, at 02:13 PM, Marcel Grünauer wrote: chomp(@some_array, <$fh>); duh. this isn't right. chomp(@some_array = <$fh>); marcel --

Re: DBI with arrays assigned in SQL

2002-12-11 Thread Marcel Grünauer
On Wednesday, December 11, 2002, at 01:47 PM, Bong Tumanut wrote: --- "Ho, Tony" <[EMAIL PROTECTED]> wrote: Hi guys I was wondering if you could help me. In my Perl code, I declare an array, say @some_array. I later open a file with a column of numbers i.e. 1 2 3 . and assign these values the

RE: DBI with arrays assigned in SQL

2002-12-11 Thread Bong Tumanut
I just did some testing. Your SQL is SELECT ... IN 1 2 3 That's syntactically incorrect. Bong Tumanut DBA --- "Ho, Tony" <[EMAIL PROTECTED]> wrote: > Hi Bong > That's correct. > Tony > > -Original Message- > From: Bong Tumanut [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 11, 20

RE: DBI with arrays assigned in SQL

2002-12-11 Thread Ho, Tony
Hi Bong That's correct. Tony -Original Message- From: Bong Tumanut [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 1:24 PM To: Ho, Tony; '[EMAIL PROTECTED]' Subject: Re: DBI with arrays assigned in SQL I'm a Perl newbie but are you generating the SQL such that it is syntact

Re: DBI with arrays assigned in SQL

2002-12-11 Thread Bong Tumanut
I'm a Perl newbie but are you generating the SQL such that it is syntactically SELECT... IN (1,2,3) ? Bong Tumanut DBA --- "Ho, Tony" <[EMAIL PROTECTED]> wrote: > Hi guys > I was wondering if you could help me. > > In my Perl code, I declare an array, say @some_array. > I later open a file with

DBI with arrays assigned in SQL

2002-12-11 Thread Ho, Tony
Hi guys I was wondering if you could help me. In my Perl code, I declare an array, say @some_array. I later open a file with a column of numbers i.e. 1 2 3 . and assign these values the array using the unshift command. i.e. while (<..>) { unshift(@some_array, $_); } I would like to use the