Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: A DBI Query Binding Pitfall

by lachoy (Parson)
on Sep 13, 2002 at 18:05 UTC ( [id://197675]=note: print w/replies, xml ) Need Help??


in reply to A DBI Query Binding Pitfall

I never quite understood why people bind table names. The whole purpose of binding variables is to deal with quoting issues, and, in more advanced databases, prepare a query plan that will allow subsequent execute() calls to execute faster. Table names don't have quoting problems, and you certainly can't create a query plan without a table name.

Do you know why people do this? Is it just exuberance with a particular way of doing things?

Chris
M-x auto-bs-mode

Replies are listed 'Best First'.
Re: Re: A DBI Query Binding Pitfall
by dws (Chancellor) on Sep 13, 2002 at 18:09 UTC
    I never quite understood why people bind table names. Do you know why people do this? Is it just exuberance with a particular way of doing things?

    I suspect it's because they've been told that hand-build queries are risk, and binding is good, but they don't understand the limitations.

    It's sort of like being told "Go that way" without being told "But look out for that puddle" or knowing to look out for one.

Log In?
Username:
Password:

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

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

    No recent polls found