Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: DBI - Table names & placeholders

by GrandFather (Sage)
on Apr 24, 2010 at 05:00 UTC ( #836641=note: print w/ replies, xml ) Need Help??


in reply to DBI - Table names & placeholders

Given you can only insert into one table at a time, if you want to insert into several tables you are going to have to wrap the insert code in a loop and generate the SQL and a statement handle for each table so string interpolation for the table name is just fine. That assumes of course that your table names come from a trusted source (not, for example, from Mrs Drop-Tables).

True laziness is hard work


Comment on Re: DBI - Table names & placeholders

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (19)
As of 2015-07-07 19:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (93 votes), past polls