RE: Database layout and query questions...

2003-06-18 Thread Michael Ragsdale
>>Thanks again for all the good feedback. If anyone can recommend >>a good book that could help me out on this I would be most >>appreciative. I have some MySQL reference books, but nothing that really >>goes into database design. I am planning on taking some database courses at a local I did

RE: Database layout and query questions...

2003-06-18 Thread Ron Savage
On Wed, 18 Jun 2003 09:11:27 -0500, NIPP, SCOTT V (SBCSI) wrote: Hi Scott >I have this book, however, it doesn't really have any good >information that I have found specifically regarding database >design. The >one area where I am really in need of help is in database design. I >can >work t

Re: DBI (1.32, 1.37) transforms data before passing it to the driver? (XML and UTF-8 getting in the way?)

2003-06-18 Thread Jonathan Leffler
Dear Tom, Tim, Jay, Sorry for the top posting - Lotus Notes makes anything else impossibly cumbersome. Thanks for the information, and I'm sorry you ran into the same problem. I tried your pack/unpack trick with Perl 5.8.0 and that does not seem to work -- it converted everything into UTF-8

Re: qustion about oop and dbi

2003-06-18 Thread Jan Theofel
Hello, On Wed, Jun 18, 2003 at 01:10:37PM -0500, Neibarger Scott H wrote: > I would recommend Object Oriented Perl by Damian Conway. That's probably the > best book you can read; it's full of real-world examples and witty > commentary. This is the book I used to learn Object Oriented Perl but I

RE: qustion about oop and dbi

2003-06-18 Thread Neibarger Scott H
I would recommend Object Oriented Perl by Damian Conway. That's probably the best book you can read; it's full of real-world examples and witty commentary. -Original Message- From: Jan Theofel [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 12:44 PM To: [EMAIL PROTECTED] Subject:

RE: qustion about oop and dbi

2003-06-18 Thread Greg.Hering
Go to http://www.perldoc.com/perl5.8.0/pod/perl.html and learn this first: perlbootPerl OO tutorial for beginners perltootPerl OO tutorial, part 1 perltoocPerl OO tutorial, part 2 perlbot Perl OO tricks and examples Then search the [EMAIL PROTECTED] archive for 'Hel

qustion about oop and dbi

2003-06-18 Thread Jan Theofel
Hello, the programs I've written in Perl using DBI are not wirtten in oop. Of course I use the DBI methods and stuff os objects, but the rest of my code is none-oop. Now I want to switch this and write my programs also in oop. My question is, if there are articles which describe how to do this

RE: Database layout and query questions...

2003-06-18 Thread Sarnowski, Chris
This is really an off-topic question for this list. You should join a db-specific list (e.g. the list at lazydba.com or the fatcity.com Oracle-L list). But I will sneak in a recommendation: 'Relational Database Design' by Charles J. Wertz (CRC Press, 1993). The book is ancient, but still quite re

RE: Database layout and query questions...

2003-06-18 Thread NIPP, SCOTT V (SBCSI)
Thanks for the great feedback. This is exactly what I was hoping for. Unfortunately, I think I am still missing some key database fundamentals to completely understanding some of your suggestions. I guess where I am still missing something is how I can layout the table(s) to handle the f

RE: Database layout and query questions...

2003-06-18 Thread NIPP, SCOTT V (SBCSI)
I have this book, however, it doesn't really have any good information that I have found specifically regarding database design. The one area where I am really in need of help is in database design. I can work through the scripting to access the database both for queries and data insertio

Re: DBI 1.37 Fails a test on Solaris 9 Perl 5.8.0 64bit

2003-06-18 Thread Tim Bunce
You can ignore that failure (the test is flawed). Tim. On Wed, Jun 18, 2003 at 01:05:53PM +0200, Thomas Mieslinger wrote: > Hi, > > i hope this question is one of the smarter questions sent to this list. > > i try to build DBI 1.37 for Perl 5.8.0 on Solaris 9 Sparc with the Sun C > Compiler (F

RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2

2003-06-18 Thread Bjorn.Naessens
Guys, I'm having the same problem atm. I have to install perl on aix 5l system for oracle 9.2 and need to stay supported to the other versions ( 8.1.7 ). So these questions : 1. Do you guys know where the newest version for aix is located ( 5.6 on bull website ) 2. Which environment needs to

Re: reading utf8 from mysql - should be: inserting utf8 into mysql - solved

2003-06-18 Thread Paul DuBois
At 8:42 -0400 6/18/03, Hardy Merrill wrote: I've been following this thread with interest - really curiosity. Your workaround seems like a lot of work - have you tried posting your question on a mysql mailing list? Paul Dubois has written some very good books on MySQL with sections on DBI use - I

Re: reading utf8 from mysql - should be: inserting utf8 into mysql - solved

2003-06-18 Thread Hardy Merrill
I've been following this thread with interest - really curiosity. Your workaround seems like a lot of work - have you tried posting your question on a mysql mailing list? Paul Dubois has written some very good books on MySQL with sections on DBI use - I think Paul is on this list - I'm hoping Pau

Re: Please help me in connecting to Oracle...

2003-06-18 Thread Hardy Merrill
Agha Jawad [EMAIL PROTECTED] wrote: > Dear all, > > I have a problem. I have installed "Indigo Perl". I have used the > following commands to install DBI for Oracle. > > Ipm install DDL-Oracle-1.11 > > This thing installed oracle.pm along with the other files. Then I wrote > the following cod

Re: reading utf8 from mysql - should be: inserting utf8 into mysql - solved

2003-06-18 Thread Brigitte Jellinek
Yesterday I wrote about problems with reading utf8, later I realized that the problems were actually in the inserting, not the reading. Today I found a workaround. The problem is caused by mysql, not by perl. Maybe I'm doing something really stupit, but it seems that my mysql-server doesn't acce

dbd-oracle for perl 5.8 ppm module

2003-06-18 Thread Jeffrey Beckstrom
Looking for the ppm version of dbd-oracle. A google search turned up www.xmlproj.com for it, but that server no longer exists. I have no C compiler so I can not get the source to compile. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street

Re: Perl DBI question w/ postgresql

2003-06-18 Thread Hardy Merrill
Kåre Olai Lindbach [EMAIL PROTECTED] wrote: > On Wed, 18 Jun 2003 06:51:39 -0400, you (Paul Boutros > <[EMAIL PROTECTED]>) wrote: > > >Quoting "Kovalcik, Mike A [ITS]" <[EMAIL PROTECTED]>: > > >> I'm trying to setup some scripts that will allow me to use Perl DBI to > >> INSERT into my table. Ho

Re: DBI (1.32, 1.37) transforms data before passing it to the driver? (XML and UTF-8 getting in the way?)

2003-06-18 Thread Tim Bunce
Tom Mornini's post was interesting and possibly relevant. I'd certainly like to understand what's happening here. Might also tie in with Brigitte's recent utf8 issues: http://perlwelt.horus.at/Beispiele/Magic/PerlUnicodeMysql/ Try using the latest 5.8.1 development snapshot, which has the most co

Re: Perl DBI question w/ postgresql

2003-06-18 Thread Kåre Olai Lindbach
On Wed, 18 Jun 2003 06:51:39 -0400, you (Paul Boutros <[EMAIL PROTECTED]>) wrote: >Quoting "Kovalcik, Mike A [ITS]" <[EMAIL PROTECTED]>: >> I'm trying to setup some scripts that will allow me to use Perl DBI to >> INSERT into my table. However, I have not had any success at all. I'm >> using pe

DBI 1.37 Fails a test on Solaris 9 Perl 5.8.0 64bit

2003-06-18 Thread Thomas Mieslinger
Hi, i hope this question is one of the smarter questions sent to this list. i try to build DBI 1.37 for Perl 5.8.0 on Solaris 9 Sparc with the Sun C Compiler (Forte 7). Because my database (informix) only has 64bit libraries the whole Perl and DBI has to be 64bit. When compiling DBI perl Makef

Re: Perl DBI question w/ postgresql

2003-06-18 Thread Paul Boutros
Two things come to mind: 1. $dbh->do() doesn't return a statement handle, I think. It just returns the count of rows affected. What happens if you put a $dbh->commit after the do()? 2. It could also be a quoting issue. Try using place-holders instead, with something like: my $sql = ' INSERT I

Please help me in connecting to Oracle...

2003-06-18 Thread Agha Jawad
Dear all, I have a problem. I have installed "Indigo Perl". I have used the following commands to install DBI for Oracle. Ipm install DDL-Oracle-1.11 This thing installed oracle.pm along with the other files. Then I wrote the following code in a simple text file and saved it as "abc.pl". The

Perl DBI question w/ postgresql

2003-06-18 Thread Kovalcik, Mike A [ITS]
Hi, I'm trying to setup some scripts that will allow me to use Perl DBI to INSERT into my table. However, I have not had any success at all. I'm using perl CGI as well so I've granted ALL permissions on my table to the apache user and I still can't INSERT. I can, however, UPDATE and SELECT on t