Re: Using IN() within a cfquery statement

2013-08-21 Thread Russ Michaels
I like the Mega mind response... you were right, I was less right On Wed, Aug 21, 2013 at 5:28 PM, Ron Thigpen wrote: > > Dave wasn't wrong, he was differently right. > > --rt > > On 8/19/13 10:08 AM, Raymond Camden wrote: > > > > I'm going to go print this email out right now. For the next t

Re: Using IN() within a cfquery statement

2013-08-21 Thread Ron Thigpen
Dave wasn't wrong, he was differently right. --rt On 8/19/13 10:08 AM, Raymond Camden wrote: > > I'm going to go print this email out right now. For the next time Dave is > wrong. Sometime in 2019. ~| Order the Adobe Coldfusion

Re: Using IN() within a cfquery statement

2013-08-19 Thread Russ Michaels
coldfusiondocs.com not working properly either, so seems likely. On Mon, Aug 19, 2013 at 4:26 PM, Carl Von Stetten wrote: > > I wonder if the problems with cfquickdocs and cfgloss are related to the > switchover of the ColdFusion docs to the new wiki format? Or is that > only for CF10 docs? >

Re: Using IN() within a cfquery statement

2013-08-19 Thread Carl Von Stetten
I wonder if the problems with cfquickdocs and cfgloss are related to the switchover of the ColdFusion docs to the new wiki format? Or is that only for CF10 docs? -Carl V. On 8/19/2013 7:15 AM, DURETTE, STEVEN J wrote: > I know from trying to look something up last week that I couldn't get to

Re: Using IN() within a cfquery statement

2013-08-19 Thread Dave Watts
> 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 declini

Re: Using IN() within a cfquery statement

2013-08-19 Thread Russ Michaels
- > > 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 wou

RE: Using IN() within a cfquery statement

2013-08-19 Thread DURETTE, STEVEN J
; > 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: Us

Re: Using IN() within a cfquery statement

2013-08-19 Thread Matt Quackenbush
x27;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...

Re: Using IN() within a cfquery statement

2013-08-19 Thread Raymond Camden
I'm going to go print this email out right now. For the next time Dave is wrong. Sometime in 2019. On Mon, Aug 19, 2013 at 8:53 AM, Dave Watts wrote: > > > Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the > better way? > > > > Where stuff in ( cfsqltype="appropriate typ

Re: Using IN() within a cfquery statement

2013-08-19 Thread Dave Watts
> Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the > better way? > > Where stuff in () Yes, that would absolutely be a better way, of course! I didn't even pay attention to the fact that this was in the form scope. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.co

RE: Using IN() within a cfquery statement

2013-08-19 Thread Mark A Kruger
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..

RE: Using IN() within a cfquery statement

2013-08-19 Thread DURETTE, STEVEN J
Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the better way? Where stuff in () 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

Re: Using IN() within a cfquery statement

2013-08-19 Thread Dave Watts
> 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 ar