Jim Cromie wrote:
Id be more comfortable with things if you were to use placeholders more fully,
tho there are places it wont work (like an IN @list).
In what ways should more placeholder support be added? Note that
sql_interp qq[SELECT * FROM mytable WHERE x IN ], [EMAIL PROTECTED]
does indeed generate SQL such as
SELECT * FROM mytable WHERE x IN (?, ?, ?)
dependent upon the length of @list.
Well, I stand corrected. (clever/convincing of you to use the IN example
to show that ? are part of the intermediate/internal form). BTW, I didnt say
"more placeholder support", but it seems you are using them more than
Id thought at first.
My comment was based on a cursory read, and general queasyness with non-placeholder
construction of complex SQL - seeing all those $,@ just made me itch.
jimc
-davidm
.