Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re^2: Abstracting SQL without Stored Procedures

by paulbort (Hermit)
on Sep 30, 2004 at 18:16 UTC ( [id://395439]=note: print w/replies, xml ) Need Help??


in reply to Re: Abstracting SQL without Stored Procedures
in thread Abstracting SQL without Stored Procedures

Using a hash is a good idea, regardless of how you store it, because it allows you to dynamically switch between statements, for things like different sort orders, or different inserts. ( My app inserts a row in either a queue table or a log table depending on outside data. By constructing the inserts to use the same parameter list, I can just use the appropriate hash key. )

Another way to store the statements would be with Data::Dumper.

--
Spring: Forces, Coiled Again!
  • Comment on Re^2: Abstracting SQL without Stored Procedures

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others contemplating the Monastery: (4)
As of 2024-04-25 12:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found