Any other mail list?

2001-04-09 Thread luozhenyu

Hi, all,
I'm new to the list. I just begin to learn perl, and I want some other mail
list about perl programming (like CGI, GUI, Network, IPC, RPC, etc) besides
DBI. Who can tell me. Thanks a lot!!!

Luo Zhenyu



RE: Where is it??

2001-04-09 Thread Sterin, Ilya

Works on my system.  ActiveState 5.6, 
perldoc DBD::Oracle.

Try to reinstall the module.

Ilya Sterin

-Original Message-
From: Pettit, Chris L
To: Dbi-Users (E-mail)
Sent: 04/09/2001 6:09 AM
Subject: Where is it??

I've seen several references to perldoc DBD::Oracle.
from my win32 system, an input: perldoc DBD::Oracle
returns: no documentation found.
I have the modules installed via PPM.
I tried www.perldoc.com and a search for DBD::Oracle returns (0).
I'm starting to think this might be a win32 thing,
or I've missed something keenly simple.
===
chris

"They have computers, and they may have other
weapons of mass destruction."
- Janet Reno

"If you think there's a solution,
you're a part of the problem." 
- George Carlin

==





uninstall DBI

2001-04-09 Thread Hardy Merrill

I'm playing with different client server configurations, and I
want to "uninstall" DBI from one machine - I ran "make uninstall",
but it says that unistall is deprecated - it shows a bunch of
unlink's, but when I look after the uninstall ends, all the files
are still there.  How do I uninstall DBI?

TIA.

-- 
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com



RE: Where is it?? I think I know Y.

2001-04-09 Thread Pettit, Chris L

Well, it's another mystery.
My classified machine at work, that I manually loaded is fine.
It's there.
My machine(s) at home, loaded with PPM, don't have it.
--
Amid a bright flash, and odor of sizzled cerebral tissue.
"Ahh,huh, I think I know the answer  ", he exclaimed, sounding nearly
astute as Maxwell Smart. 
--
At work I *accidentally* loaded DBD::Oracle not DBD::Oracle8.
Then loaded DBD::Oracle8.
I'd be willing to bet, at least $1-$.98, I never loaded DBD::Oracle at home.
So, I will have to see if the info comes up with DBD::Oracle8.
chris

-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 9:44 AM
To: 'Pettit, Chris L '; 'Dbi-Users (E-mail) '
Subject: RE: Where is it??


Works on my system.  ActiveState 5.6, 
perldoc DBD::Oracle.

Try to reinstall the module.

Ilya Sterin

-Original Message-
From: Pettit, Chris L
To: Dbi-Users (E-mail)
Sent: 04/09/2001 6:09 AM
Subject: Where is it??

I've seen several references to perldoc DBD::Oracle.
from my win32 system, an input: perldoc DBD::Oracle
returns: no documentation found.
I have the modules installed via PPM.
I tried www.perldoc.com and a search for DBD::Oracle returns (0).
I'm starting to think this might be a win32 thing,
or I've missed something keenly simple.
===
chris

"They have computers, and they may have other
weapons of mass destruction."
- Janet Reno

"If you think there's a solution,
you're a part of the problem." 
- George Carlin

==




[OT] Re: Any other mail list?

2001-04-09 Thread Alexander Farber (EED)

luozhenyu wrote:
 I'm new to the list. I just begin to learn perl, and I want some other mail
 list about perl programming (like CGI, GUI, Network, IPC, RPC, etc) besides
 DBI. Who can tell me. Thanks a lot!!!

http://lists.perl.org



Re: Where is it?? I think I know Y.

2001-04-09 Thread Michael A. Chase

My system with ActivePerl has never had DBD::Oracle8 loaded, just
DBD::Oracle.

Is the DBD::Oracle documentation in the Online Documentation in your
DBD::Oracle8 only machine?

If it is a problem with the PPM module, you should report it to ActiveState.
Their mail lists are described at http://www.ActiveState.com/ .
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Pettit, Chris L" [EMAIL PROTECTED]
To: "Dbi-Users (E-mail)" [EMAIL PROTECTED]
Cc: "Sterin, Ilya" [EMAIL PROTECTED]
Sent: Monday, April 09, 2001 7:30 AM
Subject: RE: Where is it?? I think I know Y.


 Well, it's another mystery.
 My classified machine at work, that I manually loaded is fine.
 It's there.
 My machine(s) at home, loaded with PPM, don't have it.
 --
 Amid a bright flash, and odor of sizzled cerebral tissue.
 "Ahh,huh, I think I know the answer  ", he exclaimed, sounding nearly
 astute as Maxwell Smart.
 --
 At work I *accidentally* loaded DBD::Oracle not DBD::Oracle8.
 Then loaded DBD::Oracle8.
 I'd be willing to bet, at least $1-$.98, I never loaded DBD::Oracle at
home.
 So, I will have to see if the info comes up with DBD::Oracle8.
 chris

 -Original Message-
 From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
 Sent: Monday, April 09, 2001 9:44 AM
 To: 'Pettit, Chris L '; 'Dbi-Users (E-mail) '
 Subject: RE: Where is it??


 Works on my system.  ActiveState 5.6,
 perldoc DBD::Oracle.

 Try to reinstall the module.

 Ilya Sterin

 -Original Message-
 From: Pettit, Chris L
 To: Dbi-Users (E-mail)
 Sent: 04/09/2001 6:09 AM
 Subject: Where is it??

 I've seen several references to perldoc DBD::Oracle.
 from my win32 system, an input: perldoc DBD::Oracle
 returns: no documentation found.
 I have the modules installed via PPM.
 I tried www.perldoc.com and a search for DBD::Oracle returns (0).
 I'm starting to think this might be a win32 thing,
 or I've missed something keenly simple.
 ===
 chris

 "They have computers, and they may have other
 weapons of mass destruction."
 - Janet Reno

 "If you think there's a solution,
 you're a part of the problem."
 - George Carlin

 ==






RE: Problems builing and testing DBD::ODBC with Cygwin

2001-04-09 Thread Paul A. Chernoch

That was indeed the patch that I used. I have since discovered that there 
were many copies of sqlext.h on my machine and one had an erroneous 
function prototype:

The prototype that I found was:
SQLRETURN SQL_API 
SQLDriverConnect(SQLHDBC,SQLHWND,SQLCHAR,SQLSMALLINT,SQLCHAR*,SQLSMALLINT,SQLSMALLINT*,SQLUSMALLINT);

But it should have been:
SQLRETURN SQL_API 
SQLDriverConnect(SQLHDBC,SQLHWND,SQLCHAR*,SQLSMALLINT,SQLCHAR*,SQLSMALLINT,SQLSMALLINT*,SQLUSMALLINT);

This fixes the compiler warning, but the tests still fail as bad as before. 
What next?

- Paul

At 10:40 AM 4/9/2001 +1000, Neil Lunn wrote:

Paul,

Was the patch applied from this message.

http://sources.redhat.com/ml/cygwin/2000-08/msg00464.html

This should apply to a clean distribution of DBD-ODBC-0.28.

Neil

  -Original Message-
  From: Paul A. Chernoch [mailto:[EMAIL PROTECTED]]
  Sent: Sunday, April 08, 2001 7:16 AM
  To: [EMAIL PROTECTED]
  Subject: Problems builing and testing DBD::ODBC with Cygwin
 
 
  I searched through the Cygwin archives on redhat and got part
  way there. I
  have patched my Makefile.PL to reflect their recommendations
  (like #UNDEF
  WIN32 and removing "-lodbccp32") to deal with the win32.h
  problems. This
  got me to be able to compile at least. But I get one
  troublesome warning,
  and most of the tests fail. The warning below is "warning:
  passing arg 3 of
  `SQLDriverConnect' makes integer from pointer without a cast". Any
  suggestions? I use perl 5.6.1 on Windows 2000, using cygwin 1.1.8.
 
  - Paul
 
  --
 
  gcc -c -I. -I/usr/lib/perl5/site_perl/5.6.1/cygwin/auto/DBI
  -DPERL_USE_SAFE_PUTENV -DHAS_SBRK_PROTO -fno-strict-aliasing
-DUSEIMPORTLIB -O2   -DVERSION=\"0.28\"
  -DXS_VERSION=\"0.28\"  -I/usr/lib/perl5/5.6.1/cygwin/CORE  ODBC.c
  gcc -c -I. -I/usr/lib/perl5/site_perl/5.6.1/cygwin/auto/DBI
  -DPERL_USE_SAFE_PUTENV -DHAS_SBRK_PROTO -fno-strict-aliasing
-DUSEIMPORTLIB -O2   -DVERSION=\"0.28\"
  -DXS_VERSION=\"0.28\"  -I/usr/lib/perl5/5.6.1/cygwin/CORE  dbdimp.c
  dbdimp.c: In function `odbc_db_login':
  dbdimp.c:171: warning: passing arg 3 of `SQLDriverConnect'
  makes integer
  from pointer without a cast
  Running Mkbootstrap for DBD::ODBC ()
  chmod 644 ODBC.bs
  rm -f blib/arch/auto/DBD/ODBC/ODBC.dll
  LD_RUN_PATH="/usr/local/lib" ld2 -o
  blib/arch/auto/DBD/ODBC/ODBC.dll  -s
  -L/usr/local/lib ODBC.o dbdimp.o -lodbc32  /usr
  /lib/perl5/5.6.1/cygwin/CORE/libperl5_6_1.a -lodbc32
  dllwrap --dllname ODBC.dll --driver-name gcc --dlltool dlltool
  --export-all-symbols --as as --output-def libODBC.def --o
  utput-lib libODBC.a \
-s -L/usr/local/lib ODBC.o dbdimp.o -lodbc32
  /usr/lib/perl5/5.6.1/cygwin/CORE/libperl5_6_1.a -lodbc32
  dllwrap: no export definition file provided
  dllwrap: creating one, but that may not be what you want
  mv ODBC.dll libODBC.a blib/arch/auto/DBD/ODBC/
  chmod 755 blib/arch/auto/DBD/ODBC/ODBC.dll
  cp ODBC.bs blib/arch/auto/DBD/ODBC/ODBC.bs
  chmod 644 blib/arch/auto/DBD/ODBC/ODBC.bs
  bash-2.04$ make test
  PERL_DL_NONLAZY=1 /usr/bin/perl5.6.1 -Iblib/arch -Iblib/lib
  -I/usr/lib/perl5/5.6.1/cygwin -I/usr/lib/perl5/5.6.1 -e 'use
Test::Harness qw(runtests $verbose); $verbose=0; runtests
  @ARGV;' t/*.t
  t/01baseok
  t/02simple..ok 1/14  0 [main] perl5.6.1 1980
  handle_exceptions:
  Exception: STATUS_ACCESS_VIOLATION
  1770 [main] perl5.6.1 1980 stackdump: Dumping stack trace to
  perl5.6.1.exe.stackdump
  t/02simple..dubious
   Test returned status 0 (wstat 139, 0x8b)
   test program seems to have generated a core
  DIED. FAILED tests 2-14
   Failed 13/14 tests, 7.14% okay
  t/03dbatt...ok 1/6  0 [main] perl5.6.1 2008
  handle_exceptions:
  Exception: STATUS_ACCESS_VIOLATION
  3815 [main] perl5.6.1 2008 stackdump: Dumping stack trace to
  perl5.6.1.exe.stackdump
  t/03dbatt...dubious
   Test returned status 0 (wstat 139, 0x8b)
   test program seems to have generated a core
  DIED. FAILED tests 2-6
   Failed 5/6 tests, 16.67% okay
  t/05methok 1/6  0 [main] perl5.6.1 2024
  handle_exceptions:
  Exception: STATUS_ACCESS_VIOLATION
  1250 [main] perl5.6.1 2024 stackdump: Dumping stack trace to
  perl5.6.1.exe.stackdump
  t/05methdubious
   Test returned status 0 (wstat 139, 0x8b)
   test program seems to have generated a core
  DIED. FAILED tests 2-6
   Failed 5/6 tests, 16.67% okay
  t/09bindok 1/9  0 [main] perl5.6.1 1968
  handle_exceptions:
  Exception: STATUS_ACCESS_VIOLATION
  1240 [main] perl5.6.1 1968 stackdump: Dumping stack trace to
  perl5.6.1.exe.stackdump
  t/09binddubious
   Test returned status 0 (wstat 139, 0x8b)
   test program seems to have generated a core
  DIED. FAILED tests 2-9
   Failed 8/9 tests, 11.11% okay
  Failed Test  Status Wstat Total Fail  Failed  List of Failed
  

Re: (Fwd) Calling an Oracle Stored Procedure from PERL

2001-04-09 Thread Paul A. Chernoch

I have called Oracle stored procedures from Perl successfully using bound 
named parameters. I am too busy to reduce my program down to a size 
suitable for posting to a mailing list, but any interested parties may 
e-mail me directly. In a separate message I will respond directly to the 
questioner.

My success has been with Perl  5.005_03 (an older ActiveState build 523) 
and DBI 1.14. I am trying to port it to Cygwin, but am having trouble with 
DBD::ODBC. (The DBD::Oracle part does work, though.) DBI 1.15 causes 
problems with DBD::Oracle for some reason.

- Paul

At 04:00 PM 4/8/2001 -0700, you wrote:
I answered you directly last week.  Perhaps you should use SQL*Loader
instead.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Tim Bunce" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, April 08, 2001 11:47 AM
Subject: (Fwd) Calling an Oracle Stored Procedure from PERL


  From: [EMAIL PROTECTED] ()
  To: [EMAIL PROTECTED]
  Subject: Calling an Oracle Stored Procedure from PERL
  Date: Fri, 6 Apr 2001 16:13:49 -0700
 
  I am a beginner PERL programmer and looking for some advice if anyone can
  help.  I just started to learn PERL about 2-3 weeks ago and I like it
  alot!!!
 
  The problem...I currently receive a daily flat file that is loaded into an
  Oracle (8.0.5) database.  When I assumed responsibility of this system the
  PERL scripts were already written.  Since some of the data is incorrect
that
  gets loaded into the Oracle db I need to update it.  I have written an
  Oracle Package (Stored Procedure) in PL/SQL to perform this update
HOWEVER,
  I don't know how to call the package from the PERL script.  I'm assuming
it
  is relatively simple however I'm unsure and was looking for some help.
 
  I have installed the DBI, DBD::Oracle modules.  I am able to connect and
  retrieve data from my Oracle db.  Do I need anything more?  It just the
  procedure that I have all my update code written into and compiled reside
on
  the server and I'm not sure how to call the Package.  Help??
 
  Anyone have any suggestions/advice...or better yetAn example piece of
  code with comments would be great if you have one!?!?!

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Paul Anton Chernoch
Zeborg, Inc.
500 West Cummings Park
Woburn, MA 01801

t: 781.759.0105
f: 781.935.5090
c: 781.606.7382

http://www.zeborg.com
This message is a personal and confidential communication. If you are not
the intended recipient, please do not read, copy, or use it, and do not
disclose it to others. Please notify the sender of the delivery error by
replying to this message, and then delete it from your system. Thank you.

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .





LIKE / QUOTE probleme ?

2001-04-09 Thread Nicolas JOURDEN

Hi,

I've got an problem develloping a research tool...

Well, using quote param ($dbh-quote (string); )...

I would like to get juste that :
va\nukl\sjj

But using that one it's return :
'va\nukl\sjj'

How to cancel the ' and ' at the top of the return string and at the end ?

Just for information I do a LIKE reuquest :

$dbh-prepare("SELECT foo FROM bar WHERE fore LIKE '%". $dbh-quote( 
$string ). "%'";


Thanks, I think that I'm explicit ?
If you can't understand what I mean, well I suck :/

-- 

 =-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=
 Nicolas  JOURDEN - [EMAIL PROTECTED] - #41100039 - +33 0681940905
 http://www.wedoo.com/   - La Nouvelle Facon de Surfer...
 http://ddx.wedoo.com/   - Mon site perso.
 Programmeur, Integrateur  | Perl, CGI, Mysql/PostgreSQL, HTML, Design
 =-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=




Re: LIKE / QUOTE probleme ?

2001-04-09 Thread Ronald J Kimball

On Mon, Apr 09, 2001 at 06:01:19PM +0200, Nicolas JOURDEN wrote:
 Hi,
 
 I've got an problem develloping a research tool...
 
 Well, using quote param ($dbh-quote (string); )...
 
 I would like to get juste that :
 va\nukl\sjj
 
 But using that one it's return :
 'va\nukl\sjj'
 
 How to cancel the ' and ' at the top of the return string and at the end ?

But that's the whole point of calling quote()...  :)


 Just for information I do a LIKE reuquest :
 
 $dbh-prepare("SELECT foo FROM bar WHERE fore LIKE '%". $dbh-quote( 
 $string ). "%'";
 

Try this instead:

  $sth = $dbh-prepare("SELECT foo FROM bar WHERE fore LIKE " .
   $dbh-quote("%$string%"));

Or, with placeholders:

  $sth = $dbh-prepare("SELECT foo FROM bar WHERE fore LIKE ?");
  $sth-execute("%$string%");


Ronald



RE: Problems builing and testing DBD::ODBC with Cygwin

2001-04-09 Thread Paul A. Chernoch

Neil,

I must sheepishly admit that I had already made changes to the Makefile.pl 
before applying the patch so the patch was not entirely successful. After 
getting a fresh copy of the library and applying the patch, all is well and 
not only the tests but my application run successfully. Thank you for your 
assistance and those critical words "apply to a clean distribution".

   - Paul

At 10:40 AM 4/9/2001 +1000, Neil Lunn wrote:

Paul,

Was the patch applied from this message.

http://sources.redhat.com/ml/cygwin/2000-08/msg00464.html

This should apply to a clean distribution of DBD-ODBC-0.28.

Neil

  -Original Message-
  From: Paul A. Chernoch [mailto:[EMAIL PROTECTED]]
  Sent: Sunday, April 08, 2001 7:16 AM
  To: [EMAIL PROTECTED]
  Subject: Problems builing and testing DBD::ODBC with Cygwin
 
 
  I searched through the Cygwin archives on redhat and got part
  way there. I
  have patched my Makefile.PL to reflect their recommendations
  (like #UNDEF
  WIN32 and removing "-lodbccp32") to deal with the win32.h
  problems. This
  got me to be able to compile at least. But I get one
  troublesome warning,
  and most of the tests fail. The warning below is "warning:
  passing arg 3 of
  `SQLDriverConnect' makes integer from pointer without a cast". Any
  suggestions? I use perl 5.6.1 on Windows 2000, using cygwin 1.1.8.
 
  - Paul
 
  --
 
  gcc -c -I. -I/usr/lib/perl5/site_perl/5.6.1/cygwin/auto/DBI
  -DPERL_USE_SAFE_PUTENV -DHAS_SBRK_PROTO -fno-strict-aliasing
-DUSEIMPORTLIB -O2   -DVERSION=\"0.28\"
  -DXS_VERSION=\"0.28\"  -I/usr/lib/perl5/5.6.1/cygwin/CORE  ODBC.c
  gcc -c -I. -I/usr/lib/perl5/site_perl/5.6.1/cygwin/auto/DBI
  -DPERL_USE_SAFE_PUTENV -DHAS_SBRK_PROTO -fno-strict-aliasing
-DUSEIMPORTLIB -O2   -DVERSION=\"0.28\"
  -DXS_VERSION=\"0.28\"  -I/usr/lib/perl5/5.6.1/cygwin/CORE  dbdimp.c
  dbdimp.c: In function `odbc_db_login':
  dbdimp.c:171: warning: passing arg 3 of `SQLDriverConnect'
  makes integer
  from pointer without a cast
  Running Mkbootstrap for DBD::ODBC ()
  chmod 644 ODBC.bs
  rm -f blib/arch/auto/DBD/ODBC/ODBC.dll
  LD_RUN_PATH="/usr/local/lib" ld2 -o
  blib/arch/auto/DBD/ODBC/ODBC.dll  -s
  -L/usr/local/lib ODBC.o dbdimp.o -lodbc32  /usr
  /lib/perl5/5.6.1/cygwin/CORE/libperl5_6_1.a -lodbc32
  dllwrap --dllname ODBC.dll --driver-name gcc --dlltool dlltool
  --export-all-symbols --as as --output-def libODBC.def --o
  utput-lib libODBC.a \
-s -L/usr/local/lib ODBC.o dbdimp.o -lodbc32
  /usr/lib/perl5/5.6.1/cygwin/CORE/libperl5_6_1.a -lodbc32
  dllwrap: no export definition file provided
  dllwrap: creating one, but that may not be what you want
  mv ODBC.dll libODBC.a blib/arch/auto/DBD/ODBC/
  chmod 755 blib/arch/auto/DBD/ODBC/ODBC.dll
  cp ODBC.bs blib/arch/auto/DBD/ODBC/ODBC.bs
  chmod 644 blib/arch/auto/DBD/ODBC/ODBC.bs
  bash-2.04$ make test
  PERL_DL_NONLAZY=1 /usr/bin/perl5.6.1 -Iblib/arch -Iblib/lib
  -I/usr/lib/perl5/5.6.1/cygwin -I/usr/lib/perl5/5.6.1 -e 'use
Test::Harness qw(runtests $verbose); $verbose=0; runtests
  @ARGV;' t/*.t
  t/01baseok
  t/02simple..ok 1/14  0 [main] perl5.6.1 1980
  handle_exceptions:
  Exception: STATUS_ACCESS_VIOLATION
  1770 [main] perl5.6.1 1980 stackdump: Dumping stack trace to
  perl5.6.1.exe.stackdump
  t/02simple..dubious
   Test returned status 0 (wstat 139, 0x8b)
   test program seems to have generated a core
  DIED. FAILED tests 2-14
   Failed 13/14 tests, 7.14% okay
  t/03dbatt...ok 1/6  0 [main] perl5.6.1 2008
  handle_exceptions:
  Exception: STATUS_ACCESS_VIOLATION
  3815 [main] perl5.6.1 2008 stackdump: Dumping stack trace to
  perl5.6.1.exe.stackdump
  t/03dbatt...dubious
   Test returned status 0 (wstat 139, 0x8b)
   test program seems to have generated a core
  DIED. FAILED tests 2-6
   Failed 5/6 tests, 16.67% okay
  t/05methok 1/6  0 [main] perl5.6.1 2024
  handle_exceptions:
  Exception: STATUS_ACCESS_VIOLATION
  1250 [main] perl5.6.1 2024 stackdump: Dumping stack trace to
  perl5.6.1.exe.stackdump
  t/05methdubious
   Test returned status 0 (wstat 139, 0x8b)
   test program seems to have generated a core
  DIED. FAILED tests 2-6
   Failed 5/6 tests, 16.67% okay
  t/09bindok 1/9  0 [main] perl5.6.1 1968
  handle_exceptions:
  Exception: STATUS_ACCESS_VIOLATION
  1240 [main] perl5.6.1 1968 stackdump: Dumping stack trace to
  perl5.6.1.exe.stackdump
  t/09binddubious
   Test returned status 0 (wstat 139, 0x8b)
   test program seems to have generated a core
  DIED. FAILED tests 2-9
   Failed 8/9 tests, 11.11% okay
  Failed Test  Status Wstat Total Fail  Failed  List of Failed
  --
  --
  t/02simple.t   0   13914   13  92.86%  2-14
  t/03dbatt.t0   139 65  83.33%  2-6
  

Re: Help with installing DBD::Oracle

2001-04-09 Thread Michael A. Chase

'Just move the modules' is not the instruction for installing modules in
ActiveState Perl.  Look up PPM in the fine Online Documentation that came
with ActiveState Perl and follow the instructions.

The usual 'perl Makefile.pl ...' process doesn't normally work with
ActiveState Perl, but ActiveState has a large library of pre-built modules
ready for you to use.

Don't forget to install DBI before DBD::Oracle or DBD::Oracle8 (depending on
the version of Oracle client software you have in your system).
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Reuss, Bob" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 09, 2001 12:12 PM
Subject: Help with installing DBD::Oracle


 I am trying to install the DBD::Oracle module on my Windows 2000 system.
I
 have downloaded the module and have extracted the files via winzip.  Here
is
 where I run into problems.  If I follow the installation instructions for
 active state and just move the modules, it doesn't work.  If I run the
 makefile.pl file, I get multiple library errors, but, it finds all the
 oracle paths correctly, and the DBI paths, etc...  The problem then is I
 need to run make on the makefile.  I do not have a make utility installed
on
 the windows 2000 server.  I tried to install a few I found on the web but
 they did not work.  Can anyone help me with solutions on how to install
the
 module?





MSAccess DB Problem

2001-04-09 Thread Juan Antonio Celaya Guzman




To whom it may concern,

Hi there,

I have a problem trying to get my perl script working. I remember when I
installed
the Activestate implementation I did a test for DB Accessing and it worked fine
but then I change to another implementation which one comes with an Apache
Web Server so I decided to switch -I am talking about Indigostar -,  the server
worked fine, the cgis worked fine but when DB Accessing comes I can  not figured
out what is going on.

I am using the DBI interface provided with the implementation please see the
script
below.

#!perl -w

use DBI;
use CGI;

# EXPLICIT VARIABLE DECLARE FOLLOWS
my @drivers;
my $driver;
my @dsns;
my $dsn;
my $q;

$q = new CGI;
print $q-header;
print $q-start_html("Conectividad");

@drivers = DBI-available_drivers;
 print "\n\n";
foreach $driver (@drivers){
 print "$driver\n";
 @dsns = DBI-data_sources($drivers[0]) or print "\t-No DSN available\n";
 foreach $dsn (@dsns){
  print "\t-$dsn\n";
 };
};
print "\nAplicacion de acceso a la Base de Datos de Conectividad";
print $q-end_html;


 there is nothing fancy just trying to see what DSN do I have access, well it
happens I
setup a DSN previously called Test which one is pointing to my Access DB, but
whenever
I run the script I got the following:

Content-Type: text/html

!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN"
HTMLHEADTITLEConectividad/TITLE
/HEADBODY

ADO
 -No DSN available
ExampleP
 -No DSN available
Proxy
 -No DSN available
mysql
 -No DSN available

Aplicacion de acceso a la Base de Datos de Conectividad/BODY/HTML


Sorry I a sent you such a huge email, I am not even registered in your email
List, but I want
you to have the whole picture.

Could you please register me, My name is Juan Antonio Celaya, I am from Mexico.
Thanks beforehand.

Best regards,

  Juan Antonio Celaya
  email: [EMAIL PROTECTED]





Binding to Output Parameters using DBD::ODBC

2001-04-09 Thread Bruce Hodge

I am using DBD::ODBC drivers to connect to a Sybase 11.5 database. I have 
migrated a bunch of procedures from Oracle 8i that use output parameters to 
return data. I was migrating an abstract database interface that I built 
dbObject.pm, which previously called the Oracle stored procedures. I 
verified that the ODBC prepare statement was being correctly built {call 
get_seq(?,?,?)} and when I called DBI::bind_param_inout on the 3rd output 
parameter I got the error message "Can't bind output values (currently)". 
Now I know I am not the only one who has ever tried this so can someone 
please tell me how to bind Perl variables to stored procedure's output 
parameters using DBD::ODBC.

Thanks,
Bruce


```
   (o o)
--oOO--(_)--OOo
Bruce HodgeDynaScript Internet Language
P.O. Box 428   http://www.dynascript.com
Greenfield, NY 12833   [EMAIL PROTECTED]
-o00-00o---




Re: Binding to Output Parameters using DBD::ODBC

2001-04-09 Thread Michael Peppler

Bruce Hodge writes:
  I am using DBD::ODBC drivers to connect to a Sybase 11.5 database. I have 
  migrated a bunch of procedures from Oracle 8i that use output parameters to 
  return data. I was migrating an abstract database interface that I built 
  dbObject.pm, which previously called the Oracle stored procedures. I 
  verified that the ODBC prepare statement was being correctly built {call 
  get_seq(?,?,?)} and when I called DBI::bind_param_inout on the 3rd output 
  parameter I got the error message "Can't bind output values (currently)". 
  Now I know I am not the only one who has ever tried this so can someone 
  please tell me how to bind Perl variables to stored procedure's output 
  parameters using DBD::ODBC.

The OUTPUT params are probably returned as regular result rows in ODBC
(that's the way they are returned when using the Sybase libraries...)

Michael
-- 
Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED]
http://www.mbay.net/~mpeppler - [EMAIL PROTECTED]
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: [EMAIL PROTECTED]



RE: Help with installing DBD::Oracle

2001-04-09 Thread Curt Russell Crandall

What distribution of Perl are you using.  If it is not ActiveState, then
most likely the correct way to install your module would be to use the
CPAN module.  You can do a perldoc on CPAN for instructions.

--Curt

On Mon, 9 Apr 2001, Reuss, Bob wrote:

 Ok, I followd the docs, but ran into a new problem.  We are using a product
 'Interwoven' that installs a version of perl that I was told was using
 ActiveState Perl.  After following the docs, I realized that this is not
 true.  Now the question would be, how do I install the DBD::Oracle on a
 Windows 2000 system not running ActiveState Perl?
 
 Thanks,
 Bob Reuss
 
  -Original Message-
  From:   Michael A. Chase [SMTP:[EMAIL PROTECTED]]
  Sent:   Monday, April 09, 2001 2:47 PM
  To: Reuss, Bob; [EMAIL PROTECTED]
  Subject:Re: Help with installing DBD::Oracle
  
  'Just move the modules' is not the instruction for installing modules in
  ActiveState Perl.  Look up PPM in the fine Online Documentation that came
  with ActiveState Perl and follow the instructions.
  
  The usual 'perl Makefile.pl ...' process doesn't normally work with
  ActiveState Perl, but ActiveState has a large library of pre-built modules
  ready for you to use.
  
  Don't forget to install DBI before DBD::Oracle or DBD::Oracle8 (depending
  on
  the version of Oracle client software you have in your system).
  --
  Mac :})
  ** I normally forward private database questions to the DBI mail lists. **
  Give a hobbit a fish and he'll eat fish for a day.
  Give a hobbit a ring and he'll eat fish for an age.
  - Original Message -
  From: "Reuss, Bob" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Monday, April 09, 2001 12:12 PM
  Subject: Help with installing DBD::Oracle
  
  
   I am trying to install the DBD::Oracle module on my Windows 2000 system.
  I
   have downloaded the module and have extracted the files via winzip.
  Here
  is
   where I run into problems.  If I follow the installation instructions
  for
   active state and just move the modules, it doesn't work.  If I run the
   makefile.pl file, I get multiple library errors, but, it finds all the
   oracle paths correctly, and the DBI paths, etc...  The problem then is I
   need to run make on the makefile.  I do not have a make utility
  installed
  on
   the windows 2000 server.  I tried to install a few I found on the web
  but
   they did not work.  Can anyone help me with solutions on how to install
  the
   module?
  
 




Re: Binding to Output Parameters using DBD::ODBC

2001-04-09 Thread Curt Russell Crandall

Can't do it... the Sybase driver does not allow placeholders in a prepare
of a stored proc.  I spent the better part of a day trying to figure out
why my code wasn't working when doing something similar until I read
Cheetah's section on DBD::Sybase.

--Curt

On Mon, 9 Apr 2001, Bruce Hodge wrote:

 I am using DBD::ODBC drivers to connect to a Sybase 11.5 database. I have 
 migrated a bunch of procedures from Oracle 8i that use output parameters to 
 return data. I was migrating an abstract database interface that I built 
 dbObject.pm, which previously called the Oracle stored procedures. I 
 verified that the ODBC prepare statement was being correctly built {call 
 get_seq(?,?,?)} and when I called DBI::bind_param_inout on the 3rd output 
 parameter I got the error message "Can't bind output values (currently)". 
 Now I know I am not the only one who has ever tried this so can someone 
 please tell me how to bind Perl variables to stored procedure's output 
 parameters using DBD::ODBC.
 
 Thanks,
 Bruce
 
 
 ```
(o o)
 --oOO--(_)--OOo
 Bruce HodgeDynaScript Internet Language
 P.O. Box 428   http://www.dynascript.com
 Greenfield, NY 12833   [EMAIL PROTECTED]
 -o00-00o---
 
 




Re: Binding to Output Parameters using DBD::ODBC

2001-04-09 Thread Curt Russell Crandall

Ooops, I thought you were using the DBD::Sybase driver.  Sorry.

On Mon, 9 Apr 2001, Bruce Hodge wrote:

 I am using DBD::ODBC drivers to connect to a Sybase 11.5 database. I have 
 migrated a bunch of procedures from Oracle 8i that use output parameters to 
 return data. I was migrating an abstract database interface that I built 
 dbObject.pm, which previously called the Oracle stored procedures. I 
 verified that the ODBC prepare statement was being correctly built {call 
 get_seq(?,?,?)} and when I called DBI::bind_param_inout on the 3rd output 
 parameter I got the error message "Can't bind output values (currently)". 
 Now I know I am not the only one who has ever tried this so can someone 
 please tell me how to bind Perl variables to stored procedure's output 
 parameters using DBD::ODBC.
 
 Thanks,
 Bruce
 
 
 ```
(o o)
 --oOO--(_)--OOo
 Bruce HodgeDynaScript Internet Language
 P.O. Box 428   http://www.dynascript.com
 Greenfield, NY 12833   [EMAIL PROTECTED]
 -o00-00o---
 
 




Re: Binding to Output Parameters using DBD::ODBC

2001-04-09 Thread Michael Peppler

Curt Russell Crandall writes:
  Can't do it... the Sybase driver does not allow placeholders in a prepare
  of a stored proc.  I spent the better part of a day trying to figure out
  why my code wasn't working when doing something similar until I read
  Cheetah's section on DBD::Sybase.

The next version of DBD::Sybase *will* allow this (although it still
won't handle in/out bindings)

Michael
-- 
Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED]
http://www.mbay.net/~mpeppler - [EMAIL PROTECTED]
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: [EMAIL PROTECTED]



Re: Help with installing DBD::Oracle

2001-04-09 Thread Michael A. Chase

If it's not ActiveState Perl, you need to build the modules with the same C
compiler and libraries as were used to create Perl.  You can find out most
of that information by running 'perl -V'.

If they didn't use MSVC, you will probably also need to use dmake in place
of nmake which is available from the CPAN/modules/by-authors/id/GSAR
directory in CPAN.

Your best bet for getting the correct information is to talk to the people
who originally built the perl you are using.

Good luck.  You're going to need it.  Most of the time we recommend starting
with a fresh, local build of perl, but that might mess up Interwoven.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Reuss, Bob" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 09, 2001 1:27 PM
Subject: RE: Help with installing DBD::Oracle


 Ok, I followd the docs, but ran into a new problem.  We are using a
product
 'Interwoven' that installs a version of perl that I was told was using
 ActiveState Perl.  After following the docs, I realized that this is not
 true.  Now the question would be, how do I install the DBD::Oracle on a
 Windows 2000 system not running ActiveState Perl?





RE: MSAccess DB Problem

2001-04-09 Thread Difalco, Phil


CHANGE:
  @dsns = DBI-data_sources($drivers[0]) or print "\t-No DSN available\n";
TO:
  @dsns = DBI-data_sources($driver) or print "\t-No DSN available\n";


-Original Message-
From: Juan Antonio Celaya Guzman [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 1:36 PM
Subject: MSAccess DB Problem


I have a problem trying to get my perl script working. I remember when I
installed
the Activestate implementation I did a test for DB Accessing and it worked
fine
but then I change to another implementation which one comes with an Apache
Web Server so I decided to switch -I am talking about Indigostar -,  the
server
worked fine, the cgis worked fine but when DB Accessing comes I can  not
figured
out what is going on.

I am using the DBI interface provided with the implementation please see the
script below.

#!perl -w

use DBI;
use CGI;

# EXPLICIT VARIABLE DECLARE FOLLOWS
my @drivers;
my $driver;
my @dsns;
my $dsn;
my $q;

$q = new CGI;
print $q-header;
print $q-start_html("Conectividad");

@drivers = DBI-available_drivers;
print "\n\n";
foreach $driver (@drivers){
  print "$driver\n";
  @dsns = DBI-data_sources($drivers[0]) or print "\t-No DSN available\n";
  foreach $dsn (@dsns){
print "\t-$dsn\n";
  };
};
print "\nAplicacion de acceso a la Base de Datos de Conectividad";
print $q-end_html;


there is nothing fancy just trying to see what DSN do I have access, well it
happens I
setup a DSN previously called Test which one is pointing to my Access DB,
but whenever
I run the script I got the following:

Content-Type: text/html

!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN"
HTMLHEADTITLEConectividad/TITLE
/HEADBODY

ADO
 -No DSN available
ExampleP
 -No DSN available
Proxy
 -No DSN available
mysql
 -No DSN available

Aplicacion de acceso a la Base de Datos de Conectividad/BODY/HTML


Sorry I a sent you such a huge email, I am not even registered in your email
List, but I want you to have the whole picture.

Could you please register me, My name is Juan Antonio Celaya, I am from
Mexico.



RE: MSAccess DB Problem

2001-04-09 Thread Juan Antonio Celaya Guzman



Hi Phil,

When I used [0] I was trying to refer to the ADO DSNs but
it doesnt matter really, by changing this sentence I will
get the DSNs for every Driver Installed, see what I got replacing
the sentence.

Content-Type: text/html

!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN"
HTMLHEADTITLEConectividad/TITLE
/HEADBODY

ADO
 -No DSN available
ExampleP
 -dbi:ExampleP:dir=.
Proxy
install_driver(Proxy) failed: Cant Locate RPC/PlClient.pm in @INC  (@INC
Contains:
C:/Apache/lib  C:/Apache/site/lib .)  at  C:/Apache/site/lib/DBD/Proxy.pm line
28.

BEGIN failed -- Complitaion aborted at C:


I think the problem is I am not getting the ODBC driver, It should appears OBCD
and then
under it my DSN Test no?? I am not really sure what the problem is any idea??








Binding to Output Parameters using DBD::ODBC

2001-04-09 Thread Bruce Hodge

I am using DBD::ODBC drivers to connect to a Sybase 11.5 database. I have 
migrated a bunch of procedures from Oracle 8i that use output parameters to 
return data. I was migrating an abstract database interface that I built 
dbObject.pm, which previously called the Oracle stored procedures. I 
verified that the ODBC prepare statement was being correctly built {call 
get_seq(?,?,?)} and when I called DBI::bind_param_inout on the 3rd output 
parameter I got the error message "Can't bind output values (currently)". 
Now I know I am not the only one who has ever tried this so can someone 
please tell me how to bind Perl variables to stored procedure's output 
parameters using DBD::ODBC.

Thanks,
Bruce


```
   (o o)
--oOO--(_)--OOo
Bruce HodgeDynaScript Internet Language
P.O. Box 428   http://www.dynascript.com
Greenfield, NY 12833   [EMAIL PROTECTED]
-o00-00o---




Re: Most common anything in a database --

2001-04-09 Thread Ronald J Kimball

On Fri, Apr 06, 2001 at 08:26:28PM -0400, Sean Cooper wrote:
 Hello all --
 
 I'm sorry if this is off topic, but does anybody know of a way to find
 the most common entry in a database using an SQL query? I'm using MySQL
 to cache search engine terms and want to find the 5 most common terms
 
 
 I can do it in perl pretty easily using a hash to store the counts of
 each value, but don't want to do it that way unless there is no way to do
 it in SQL.

Here's how I would accomplish this:

SELECT term, count(*)
FROM   search_terms
GROUP BY term
ORDER BY count(*)

And the first five rows returned would contain the five most common terms.


Ronald



Re: DBI 1.15 subclassing bug!

2001-04-09 Thread Phil R Lawrence

Tim Bunce [EMAIL PROTECTED] wrote:
 On Fri, Apr 06, 2001 at 05:11:38PM -0400, Phil R Lawrence wrote:
Uncaught exception from user code:
  DBI-disconnect is not a DBI method...
 I wouldn't want to call you a beginner, but somewhere, for some
 reason, you're executing DBI-disconnect or $foo-disconnect
 where $foo contains DBI.

You were kind to not call me a beginner!  Nonetheless, the issue was a
screwed up @ISA ordering.  See below for the bug.

I'm glad you added the code to make DBI-disconnect blow up in DBI
1.15.  I learned a bit more about inheritance as a result.

Thanks,
Phil R Lawrence


package STORIT;
use SUBCLASS_DBI;
use vars qw( @ISA );
@ISA = qw ( SUBCLASS_DBI );

sub new {
my $proto = shift;
my $class = ref($proto) || $proto;
my $s = $class-test_connect or die;

return $s;
}

#==
package STORIT::db;
use vars qw( @ISA );
@ISA = qw( STORIT SUBCLASS_DBI::db );
#  ^^
#  this caused disconnect invocation to be first looked
#  for as a DBI method (due to STORIT's @ISA) instead
#  of as a SUBCLASS_DBI::db method (which would have
#  correctly resolved as a DBI::db method).

#==
package STORIT::st;
use vars qw( @ISA );
@ISA = qw(SUBCLASS_DBI::st);