in reply to Re: Re^2: This one is perl related
in thread Quoted dates in SQL with placeholders
No, his problem is not with quotes. The database driver will interally "supply" these automatically.
dws' fine node explains the dangers in the placeholder emulation of some DBDs whose underlying database engine does not support those natively. These DBDs will allow you say things like SELECT * FROM ? where the placeholder is a stand-in for the table name or even SELECT * ? where you pass "FROM tbl ORDER BY name" as a "value".
The danger here is that no database does (and can) support this natively, so if you move from mySQL (emulated placeholders) to Oracle (native placeholders) your code will break. Placeholders must be used only for values.
As the original poster in this case does. He does not to construct any other part of the query with them.
Makeshifts last the longest.
|
|---|