what the force of many cannot
|
|
|
|
Your skill will accomplish what the force of many cannot |
|
| PerlMonks |
Answer: What are placeholders in DBI, and why would I want to use them? |
| ( #274758=categorized answer: print w/ replies, xml ) | Need Help?? |
|
Q&A > database programming > What are placeholders in DBI, and why would I want to use them? contributed by zby
Sometimes you get an error in a query with placeholders, but the same query with values pasted in the placeholders works. In this case you might need to use bind_params with the third parameter - type. Like this:
$sth->bind_param(1, $value, 4)
for integer values on my DBI.
I encountered this problem on a DB2 database accessed via ODBC, it seems that DBI quoted integer parameters and the database did not like it.
|
|
||||||||||||||||||