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-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 r...@fuzzsonic.com 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

Using IN() within a cfquery statement

2013-08-19 Thread te...@it-werks.com te...@it-werks.com
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? Terry

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 around

RE: Using IN() within a cfquery statement

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

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... I'm

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 (cfqueryparam value=#form.stuff# cfsqltype=appropriate type list=yes separator=, /) Yes, that would absolutely be a better way, of course! I didn't even pay attention to the fact that this

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 dwa...@figleaf.com wrote: Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the better way? Where stuff in (cfqueryparam

Re: Using IN() within a cfquery statement

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

RE: Using IN() within a cfquery statement

2013-08-19 Thread DURETTE, STEVEN J
: Using IN() within a cfquery statement 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

Re: Using IN() within a cfquery statement

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

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 declining

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 Russ Michaels
coldfusiondocs.com not working properly either, so seems likely. On Mon, Aug 19, 2013 at 4:26 PM, Carl Von Stetten vonner.li...@vonner.netwrote: 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