On Wed, Aug 11, 2010 at 9:26 AM, Eric Roberts <[email protected]> wrote: > > 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...
Your cfsqltype should be based on the datatype of the field itself, so if your field type is "integer" then your cfsqltype should be cf_sql_integer If you used varchar, it would probably still work - especially if you're using sql server, but it would certainly degrade performance because indexes wouldn't get used, or the engine would convert your varchar bind variables that CF creates to integers and you don't want that. Ric ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:336186 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
