Re: Removing auto-generated methods (set_sql)

[prev] [thread] [next] [Date index for 2004/06/14]

On Mon, Jun 14, 2004 at 05:33:21PM +0100, Tony Bowden wrote:
> > In testing my code, I discovered that repetitively calling the set_sql
> > function using the same name causes the following warning message:
> 
> Why are you calling it repetitively?

I thought that I may get this response. Perhaps you can point me to a
better way to do what I'm trying to achieve.

My script is being run in a mod_perl environment. I need to dynamically
generate a search based on input to a web form. This search requires a
join so I can't use standard CDBI methods. The WHERE clause could change
from call to call thus I regenerate it using SQL::Abstract.

Is there a way that I could generate the SQL once and set empty fields
to match anything? To my knowledge, that would only be possible using
LIKE and '%'. Any suggestions would be most appreciated.


> > Is there a problem with redefining a subroutine? If so, then
> > shouldn't there be a way to remove the created subs?
> 
> I'm not sure I follow. You don't remove the created one, you just don't
> create it in the first place. Why are you creating it multiple times?

See above. However, it seems like CDBI should allow a means to remove a
method if it is going to carp about redefining one. I don't see why I
shouldn't be able to redefine a set_sql statement.


Thanks,
William

        -- 
        Knowmad Services Inc.
http://www.knowmad.com