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

Re^4: Multiple SQL statements in DBI

by tel2 (Pilgrim)
on Sep 07, 2012 at 22:16 UTC ( [id://992391]=note: print w/replies, xml ) Need Help??


in reply to Re^3: Multiple SQL statements in DBI
in thread Multiple SQL statements in DBI

Thanks Dave.  Yeah - I've been using placeholders & bind-variables, but did wonder about the need for those given my findings with DBI not allowing multiple statements, but you've semi-answered that, so thanks!

Replies are listed 'Best First'.
Re^5: Multiple SQL statements in DBI
by davido (Cardinal) on Sep 07, 2012 at 22:24 UTC

    Well for one thing a malicious user could supply the necessary values for interpolation, and in the last value, close the parents and continue on with an inner join that is constructed to reveal what you never intended to reveal, or to consume tons of resources. Imagine a chain of "order by".


    Dave

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others browsing the Monastery: (5)
As of 2024-04-24 08:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found