|Syntactic Confectionery Delight|
Re: Seeking a non-quoted DBI placeholderby salvadors (Pilgrim)
|on Jan 30, 2001 at 21:08 UTC||Need Help??|
Anyone know if theres a way to get DBI to not quote a specific placeholder on a statement
Ignoring the flaws that others have already pointed out with your example, it's also worth remembering that DBI will not quote numbers.
This can cause problems when you have a CHAR column to which (sometimes) wish insert numbers. e.g if you had an ISBN column in a book table, the query:
would be fine when passed
But when passed
it won't quote the ISBN. On some databases (definitely on MySQL) this will have the effect of not using the index on this column, massively slowing down this query - particularly if you have the 1.2 million books in print in this table!