Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

Re: Re: Is there a module to generate SQL queries?

by rrwo (Friar)
on Oct 25, 2001 at 06:03 UTC ( #121347=note: print w/replies, xml ) Need Help??

in reply to Re: Is there a module to generate SQL queries?
in thread Is there a module to generate SQL queries?

Thanks, but DBIx::RecordSet is definitely what I'm not looking for. DBIx::SearchBuilder looks nice, but like the former it does too much.

I just want to create the SQL query, and then pass the parameters to the bindings. But I still want a statement handle to do what I will with.

An aside: DBIx::SearchBuilder seems poorly documented, and specific to certain databases.

Gripe: I can't stand it when there are modules that try to do everything (A+B+C), when I need a module to do A or B only, because I'm trying to do A+B+D instead. I do wish module authors would break up their modules into modules with distinct useful functions (i.e., SQL statement generation, statement handle searches, and then maybe a recordset add-on as all separate modules). It forces one to write portions of this from scratch! (Guess I'll E-mail the author about this....)

  • Comment on Re: Re: Is there a module to generate SQL queries?

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://121347]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (6)
As of 2016-10-25 14:33 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (320 votes). Check out past polls.