more useful options | |
PerlMonks |
Re: MySQL Parameterized Query with Functionsby roboticus (Chancellor) |
on Sep 15, 2014 at 22:36 UTC ( [id://1100660]=note: print w/replies, xml ) | Need Help?? |
hoyt: Go with the first statement: you won't be able to plug functions in at the last moment. When you prepare the statement, the SQL server compiles the statement with the expectation that you're going to provide the actual values to stick into the table, *not* instructions on how to compute the value to stick into the table. Similarly, you can't use table names or join columns as parameters either. ...roboticus When your only tool is a hammer, all problems look like your thumb.
In Section
Seekers of Perl Wisdom
|
|