The quote method did not solve the problem. Placeholders do not appear to be the problem.... see My node
Note the update section.
As much as I want to blame my code it is suspiciously starting to look like a problem with DBI or the underlying
DBD::XBASE or XBASE modules.
| [reply] |
Hey, waswas... great link. It does not, however, solve the problem. Please see My Node and the update section there.
Placeholders don't appear to be the solution and neither the quote method nor single-quoting the tablename works.
Any further comments you might have would be most appreciated. | [reply] |
Good catch - exactly right. Use placeholders - they'll increase performance (not necessarily in this particular situation) and fix all quoting issues in one-fell-swoop. No reason not to use placeholders. Read the perldocs on placeholders by doing
perldoc DBI
and search (using the forward slash '/') for 'Placeholders'.
HTH. | [reply]
[d/l] |