Re: Removing auto-generated methods (set_sql)

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

From: William McKee
Subject: Re: Removing auto-generated methods (set_sql)
Date: 21:48 on 14 Jun 2004

On Mon, Jun 14, 2004 at 10:34:10PM +0100, colm-cdbi@xxxxxxxxx.xx.xx wrote:
> If you have a small number of fields you could achieve what
> you say (if I understand correctly) by creating a general piece
> of SQL like this :

Hi Colm,

That's an ingenious bit of SQL! I like the fact that it's contained in a
single prepared statement which boosts performance. I agree that it
could get ugly quickly.

For now, I'm going with Perrin's suggestion of using DBI directly. This
affords me the ability to be lazy and use SQL::Abstract to generate the
where clause and bind values.

Thanks for the idea,
William

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

(message missing)

Removing auto-generated methods (set_sql)
William McKee 16:27 on 14 Jun 2004

Re: Removing auto-generated methods (set_sql)
Tony Bowden 16:33 on 14 Jun 2004

Re: Removing auto-generated methods (set_sql)
William McKee 16:57 on 14 Jun 2004

Re: Removing auto-generated methods (set_sql)
Perrin Harkins 17:30 on 14 Jun 2004

Re: Removing auto-generated methods (set_sql)
William McKee 20:51 on 14 Jun 2004

Re: Removing auto-generated methods (set_sql)
Perrin Harkins 20:56 on 14 Jun 2004

Re: Removing auto-generated methods (set_sql)
colm-cdbi 21:34 on 14 Jun 2004

Re: Removing auto-generated methods (set_sql)
William McKee 21:48 on 14 Jun 2004

Re: Removing auto-generated methods (set_sql)
Tony Bowden 21:59 on 14 Jun 2004

Re: Removing auto-generated methods (set_sql)
Tim Bunce 08:44 on 15 Jun 2004

Re: Removing auto-generated methods (set_sql)
Tony Bowden 08:53 on 15 Jun 2004

Re: Removing auto-generated methods (set_sql)
William McKee 17:53 on 15 Jun 2004

Re: Removing auto-generated methods (set_sql)
Tony Bowden 19:59 on 15 Jun 2004

Re: Removing auto-generated methods (set_sql)
Perrin Harkins 00:04 on 16 Jun 2004