> Since lists are also strings why not pass it in as a > varchar using cfsqltype="CF_SQL_VARCHAR" > > then within the stored procedure > > select * from country > where country_id IN (@countries) > > just make sure the varchar is large enough to hold a > little more than the maximum number of characters that > the list can contain
That won't work - the IN operator requires a list of integers in the above example. You can work around this by building a string and executing that string using EXEC or sp_executesql, as others have already mentioned in this thread. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
