SELECT myvalues FROM mytable WHERE myid IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#mylist#" list="yes">)
Off the top of my head, I can't remember if you need the parens with cfqueryparam or not. On Jan 22, 2008 1:31 PM, Erika L. Walker <[EMAIL PROTECTED]> wrote: > Episode 435: Erika's brain once again melts down after years of not really > doing any code. Whilst she is becoming intimately familiar with loops, > structs and arrays once again, the dreaded ValueList has halted her progress > today. > > Erika: I have a select statement with a where clause. I want the records > whose ID's exist in my List. Help! > > Person to the rescue: insert where clause here please ... > > :D > > Much thanks. > I mean seriously, I should just be shot and put out to pasture. I don't even > know why I am playing with this stuff ... > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:251592 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
