Re: Trouble making set_sql work...

[prev] [thread] [next] [Date index for 2004/07/13]

From: Andy Harrison
Subject: Re: Trouble making set_sql work...
Date: 20:52 on 13 Jul 2004

On Tue, 13 Jul 2004 21:08:52 +0100, colm-cdbi@xxxxxxxxx.xx.xx
<colm-cdbi@xxxxxxxxx.xx.xx> wrote:
> 
> No, not at all.  I didn't mean to toss around harmful phrases like 'in
> the spirit of Class::DBI' :)
> 
> All I meant by that is that I was advocating (above) a way
> to implement your request in terms of features in Class::DBI that are
> designed for that purpose.  Using set_sql with a variable interpolated
> from main:: is not a portable solution, having the functionality in a
> class method seems like a good solution within the existing Class::DBI
> framework.
> 
> > What's the proper thing to do in a situation like
> > this where you might have to make a proprietary sql statement to get
> > the results you need?
> 
> IMHO, if you need to do it then just go ahead and do it just bear in
> mind that somebody will probably have wanted to do it before and will have
> provided a way to make your life easier.

Good point.  Thanx.  I'm trying to get my brain wrapped around the
maintainable code philosophy, but in that respect, I'm still a novice.

        -- 
        Andy Harrison