While people are sometimes lazy, it is not fair to just jump to that conclusion, and it is that negative attitude that has driven so many people to leave this list. It is all well and good to say RTFM, but if you are a newbie and do not know what you are looking for, you could easily completely miss quotedValueList()
On Mon, Aug 19, 2013 at 3:04 PM, Matt Quackenbush <quackfu...@gmail.com>wrote: > > I take an entirely different viewpoint on Dave's answer. I read the > original post and declined to answer because it seemed pretty obvious that > ZERO effort was put in place by the questioner to find an answer. My bet is > Dave had a similar feeling regarding the effort, but instead of declining > to answer gave the quickest and easiest answer that could/would be found by > a quick search or perusal of the documentation. Sometimes RTFM *is* the > appropriate response. ;-) > > > > > > > On Mon, Aug 19, 2013 at 9:50 AM, Mark A Kruger <mkru...@cfwebtools.com > >wrote: > > > > > Dave is allowed one weak answer per year... he's waited til August so I > say > > we give him a break :) > > > > -Mark > > > > -----Original Message----- > > From: DURETTE, STEVEN J [mailto:sd1...@att.com] > > Sent: Monday, August 19, 2013 8:46 AM > > To: cf-talk > > Subject: RE: Using IN() within a cfquery statement > > > > > > Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the > > better way? > > > > Where stuff in (<cfqueryparam value="#form.stuff#" cfsqltype="appropriate > > type" list="yes" separator="," />) > > > > Steve > > > > -----Original Message----- > > From: Dave Watts [mailto:dwa...@figleaf.com] > > Sent: Monday, August 19, 2013 9:42 AM > > To: cf-talk > > Subject: Re: Using IN() within a cfquery statement > > > > > > > I have a select name="stuff" multiple in a form filled with results > from > > a > > query. > > > I get the form field value: stuff=selection1,selection5,selection12. > > > > > > How do I then build a cfquery using the stuff variable in the IN() > > statement? > > > > Use the quotedValueList function to wrap single quotes around them. > > > > SELECT ... > > FROM ... > > WHERE STUFF IN (#quotedValueList(form.stuff)#) > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > http://training.figleaf.com/ > > > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > > GSA Schedule, and provides the highest caliber vendor-authorized > > instruction at our training centers, online, or onsite. > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
