Re: Postgres w/DBI

2001-10-14 Thread Terrence Brannon
On Sunday, October 14, 2001, at 07:48 PM, Ilya Sterin wrote: >> I tire of stating this and I wonder why people want to gloss over this >> glaringly obvious fact: SQL varies from vendor to vendor. > > Definitelly does, but if you stick to the SQL standard than you should > have > no problems as m

RE: Postgres w/DBI

2001-10-14 Thread Ilya Sterin
> -Original Message- > From: Terrence Brannon [mailto:[EMAIL PROTECTED]] > Sent: Sunday, October 14, 2001 11:54 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Postgres w/DBI > > > > On Sunday, October 14, 2001, at 08:41 AM, Sterin, Ilya wrote: > > > >

Re: DBI::db::selectall_arrayref somehow reblesses the $dbh argument

2001-10-14 Thread Stephen Clouse
I think the main issue is that you're missing the most important part of t/subclass.t, the call to init_rootclass that identifies your subclass for the DBI dispatcher. You should never need a bless call anywhere in your subclass, DBI should handle it automagically. I'd wager that most of the

Re: Postgres w/DBI

2001-10-14 Thread mickalo
Randall, >>On 14 Oct 2001 10:50:45 -0700, [EMAIL PROTECTED] (Randal L. Schwartz) wrote: >>However, instead of doing things the hard way, you'll find that with >>Pg's subselects and views and triggers and true transactions and >>column constraints and references, things will get mighty simpler.

Re: Postgres w/DBI

2001-10-14 Thread Terrence Brannon
On Sunday, October 14, 2001, at 08:41 AM, Sterin, Ilya wrote: > > >> -Original Message- >> From: Terrence Brannon [mailto:[EMAIL PROTECTED]] >> Sent: Sunday, October 14, 2001 10:38 AM >> To: [EMAIL PROTECTED] >> Cc: [EMAIL PROTECTED] >> Subject: Re: Postgres w/DBI >> >> >> >> On Sunday,

RE: so sorryl..

2001-10-14 Thread Sterin, Ilya
How did you subscribe? Ilya > -Original Message- > From: JOSHUA CHANG-YOL BAEK [mailto:[EMAIL PROTECTED]] > Sent: Sunday, October 14, 2001 6:37 AM > To: [EMAIL PROTECTED] > Subject: so sorryl.. > > > how to unsubscribe? > > - cybaek > > - Original Message - > From: "Stephen

RE: Postgres w/DBI

2001-10-14 Thread Sterin, Ilya
> -Original Message- > From: Terrence Brannon [mailto:[EMAIL PROTECTED]] > Sent: Sunday, October 14, 2001 10:38 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: Postgres w/DBI > > > > On Sunday, October 14, 2001, at 07:25 AM, [EMAIL PROTECTED] wrote: > > > Hello All, > >

RE: LongReadLen

2001-10-14 Thread Sterin, Ilya
Depending on your database. With DBD::Oracle compiled with OCI7 libs it's 65535, but if compiled with OCI8 libs than there is no limit and can be set to the largest field size in bytes. Ilya > -Original Message- > From: dane k [mailto:[EMAIL PROTECTED]] > Sent: Saturday, October 13, 200

Re: Postgres w/DBI

2001-10-14 Thread Terrence Brannon
On Sunday, October 14, 2001, at 07:25 AM, [EMAIL PROTECTED] wrote: > Hello All, > > We've been using MySQL with Perl/DBI for quiet awhile, and have been > looking at > trying Postgres. I was wonder how much re-coding is involved if we use > our > existing scripts with Postgres instead of MySQL

Postgres w/DBI

2001-10-14 Thread mickalo
Hello All, We've been using MySQL with Perl/DBI for quiet awhile, and have been looking at trying Postgres. I was wonder how much re-coding is involved if we use our existing scripts with Postgres instead of MySQL?? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Inte

example code private_* attributes not working for me

2001-10-14 Thread Terrence Brannon
ok, in this module, the standard handle attribute NUM_OF_FIELDS does work perfectly fine for STORE-ing/FETCH-ing $sth fields however, when I try to create a private attribute and fetch it (via the lines $sth->FETCH) i get the standard field but not my private one also, I am aware that

Re: DBI::db::selectall_arrayref somehow reblesses the $dbh argument

2001-10-14 Thread Terrence Brannon
Ok, per request I am showing my code. The first thing I edit was edit DBI.pm,, version 1.19 and do a use Data::Dumper; print Dumper($dbh) in DBD::_::db::selectall_arrayref - sub selectall_arrayref { my ($dbh, $stmt, $attr, @bind) = @_; use Data::Dumper; warn "SAR: ", D

package perl question

2001-10-14 Thread Afgin Shlomit
I try to write a package file. For just make it work I define package file that contain : package Conferences; # assumes Some/Module.pm use strict; use Exporter (); use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS); $VERSION = 1.00; @ISA = qw(Exporter); @EXPORT

so sorryl..

2001-10-14 Thread JOSHUA CHANG-YOL BAEK
how to unsubscribe? - cybaek - Original Message - From: "Stephen Clouse" <[EMAIL PROTECTED]> To: "Terrence Brannon" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, October 14, 2001 7:15 PM Subject: Re: do private_* attributes actually work? > -BEGIN PGP SIGN

Re: LongReadLen

2001-10-14 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sat, Oct 13, 2001 at 08:59:13PM -0700, dane k wrote: > What is the max size of LongReadLen ? As much memory as your environment can allocate. See the docs for help in figuring out the best size to set it to. - -- Stephen Clouse <[EMAIL PROTECT

Re: DBI::db::selectall_arrayref somehow reblesses the $dbh argument

2001-10-14 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sat, Oct 13, 2001 at 05:15:14PM -0700, [EMAIL PROTECTED] wrote: > I have studied t/subclass.t and have created a subclass of DBI::st and > DBI::db. > > Something mystifies me though. Even though I have a database handle > blessed into my subclas

Re: do private_* attributes actually work?

2001-10-14 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sat, Oct 13, 2001 at 05:54:13PM -0700, Terrence Brannon wrote: > It would be nice is t/subclass.t were updated with an example of how to > use private attributes... Although the STORE of such attributes did not > throw an error, I was not able to