I was just reading up on the list attribute of cfqueryparam on Ben Nadel's blog ( http://www.bennadel.com/blog/425-ColdFusion-CFQueryParam-List-Attribute-Is-Sweeet-.htm)...greatarticle Ben ;-) I do have an item of clarification on how a list is treated with this. In the article you state (with example...bullet points added by the google apps interface)
- SELECT - id, name - FROM - blog_entry - WHERE - id IN ( ?,?,?,?,?,?,?,?,?,?,? ) As you can see, it treats each element of the list as its own bound variable (each list item gets its own CFQueryParam of sorts). Does this mean that if i have a list if integers, that the type should be CF_SQL_Integer or should it be CF_SQL_Varchar since it is a list? This is my first time working with the list attribute... Thanks! Eric ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336185 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
