empty row sometimes?

2001-10-19 Thread misc
hello all, I worked out what I need to do, but I'm not sure why the first thing I tried did not work. observe the following code snippet: $qry = "SELECT * FROM table WHERE field=5"; $sth = $dbconn->prepare($qry); $sth->execute or die($sth->errstr); $row1 = $sth->fetchrow_hashref; print " got

default column values

2001-10-19 Thread Jonathan Swartz
Hello dbi-users, We've been talking on the POOP-group list about the need to programmatically determine the default column values for a given table. This is essential for creating database-mapped objects without actually creating the row; you'd want the new object to be populated according to da

Need help with Instaling DBI 1.20 on Sun Sparc Solaris 8

2001-10-19 Thread Radek Hofman
Hello all! If anyone could help me... becouse I'm desperated :-( Thanx Radek Hofman * bash-2.03# make realclean rm -f blib/script/dbiproxy blib/script/dbish rm -rf Perl.c DBI.c DBI-1.20 Perl.xsi dbish dbiproxy n

RE: Building static Perl that includes DBI and DBD::Informix inside???

2001-10-19 Thread Gary L. Burnore
Ok, Ok, ya twisted my arm. I'll write up a howto over the weekend and post it to dbi-users. Others can add to it or rebut what I've written. :) At 21:14 10/18/2001, you wrote: >Hi all, > >I second Adam's request, I am looking for any sort >of document about building static Perl with modules, >

Re: Alzabo

2001-10-19 Thread Dave Rolsky
On Fri, 19 Oct 2001, David Kirol wrote: > I want to explore the Alzabo data modeling tool but I cannot find any > tutorial or how to on the web. Can anyone point me in the right direction? Someone also mentioned the Linux Journal article, which is a good start. Also, check out the docs at http:/

RE: Alzabo

2001-10-19 Thread Wilson, Doug
Check the links on Alzabo's home page http://alzabo.sourceforge.net/ especially the link to the Linux Journal article. > -Original Message- > From: David Kirol [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 19, 2001 2:07 PM > To: [EMAIL PROTECTED] > Subject: Alzabo > > > I want to e

Alzabo

2001-10-19 Thread David Kirol
I want to explore the Alzabo data modeling tool but I cannot find any tutorial or how to on the web. Can anyone point me in the right direction? Thanks

RE: Strange DBI Error.. Please help

2001-10-19 Thread Kotha, Nagaraju
May be this link can help you: http:[EMAIL PROTECTED]/msg00636.html --Raju -Original Message- From: Brad [mailto:[EMAIL PROTECTED]] Sent: Friday, October 19, 2001 10:22 AM To: DBI-Users Subject: Strange DBI Error.. Please help Howdy, I installed DBI, DBD, MySQL modules on a sun4u s

Strange DBI Error.. Please help

2001-10-19 Thread Brad
Howdy, I installed DBI, DBD, MySQL modules on a sun4u sparc without error. MySQL client works fine. (from command line) But Perl says this: my $dbh = DBI->connect("DBI:mysql:user=root;database=NETWORK", {'RaiseError' => 1}); -- error message -- ld.so.1: /usr/local/bin/perl: fatal: relocation

RE: Building static Perl that includes DBI and DBD::Informix inside???

2001-10-19 Thread Gary L. Burnore
Ok, Ok, ya twisted my arm. I'll write up a howto over the weekend and post it to dbi-users. Others can add to it or rebut what I've written. :) At 21:14 10/18/2001, you wrote: >Hi all, > >I second Adam's request, I am looking for any sort >of document about building static Perl with modules, >

RE: Problems with readings Blobs (restricts to 160 characters ONLY) i

2001-10-19 Thread Sterin, Ilya
No, you can select from BLOB by also setting the LongReadLen. Ilya -Original Message- From: bill thater To: [EMAIL PROTECTED]; Don Schleede Cc: '[EMAIL PROTECTED]' Sent: 10/19/01 7:22 AM Subject: Re: Problems with readings Blobs (restricts to 160 characters ONLY) i Don Schleede wrote:

RE: DBI and Win2K

2001-10-19 Thread Sterin, Ilya
First you are trying to install with ppm then you are compiling somthing??? Doesn't make sense. PPM installs already precompiled binaries. You also can't use gcc for compiling modules for ActivePerl because ActivePerl was compiled using VC++. Go do command line interface and type ppm install D

Re: **Thought DBI was Compiled okay - I was wrong **

2001-10-19 Thread bill thater
Brett W. McCoy wrote: > On Fri, 19 Oct 2001, Gretton, Michael , , WHS/PSD wrote: > > >>DBD for Oracle. I sent out an email to the users group here a week or so >>ago with my details and really didn't get a response. I am in a complete >>state of confusion. I am literal out of ideas. >> > >

Re: Problem with Oraperl and DBD::ORACLE within CGI scripts

2001-10-19 Thread Michael A Chase
Make sure the environment variables set in the webserver process are the same as those you have set when you run from the command line. Likely suspects are ORACLE_HOME, TNS_ADMIN, LD_LIBRARY_PATH, PERL5LIB, and SHLIB_PATH, but compare them all. Also make sure the account the webserver process ru

RE: **Thought DBI was Compiled okay - I was wrong **

2001-10-19 Thread Brett W. McCoy
On Fri, 19 Oct 2001, Gretton, Michael , , WHS/PSD wrote: > DBD for Oracle. I sent out an email to the users group here a week or so > ago with my details and really didn't get a response. I am in a complete > state of confusion. I am literal out of ideas. Didn't see the original, just re-join

Re: Problems with readings Blobs (restricts to 160 characters ONLY) i

2001-10-19 Thread bill thater
Don Schleede wrote: > I am trying to read a simple BLOB implemented as a LONG RAW in Oracle 8.1.7 > > using DBI 1.15 and DBD 1.06 I tried running a select on the column. I get > data back, but it is limited to ONLY 160 bytes. well, BLOB and LONG RAW are two different things. if you are using

Re: **Thought DBI was Compiled okay - I was wrong **

2001-10-19 Thread Tim Bunce
On Fri, Oct 19, 2001 at 07:07:30AM -0400, Gretton, Michael , , WHS/PSD wrote: > > I then I build DBD. I used to get core dumps using gcc but now with my brand > spanking new c compiler I get this: > > t/general...DBI->connect() failed: ORA-12157: TNS:internal network > communication erro

RE: **Thought DBI was Compiled okay - I was wrong **

2001-10-19 Thread Gretton, Michael , , WHS/PSD
DBD for Oracle. I sent out an email to the users group here a week or so ago with my details and really didn't get a response. I am in a complete state of confusion. I am literal out of ideas. My old email follows (ENVIRONMENT - HPUX 11.00 (64BIT) USING ORACLE 7.3.4 OR ORACLE 8.1.7 (TRIED BO

Re: DBI and Win2K

2001-10-19 Thread Bart Lateur
On Thu, 18 Oct 2001 07:36:31 +0200 (CEST), Daniel Pfeiffer wrote: >I have installed ActivePerl. Now I want to install the >DBI-Interface via PPM. >I use gcc on Win2K. Your perl and modules need to be compiled with the same (or at least, a very compatible) C compiler. ActivePerl was compiled usi