Re: Empty list for an IN clause

2005-03-28 Thread Marius Milosav
uot;Ian Skinner" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, March 28, 2005 12:51 PM Subject: RE: Empty list for an IN clause > I thought of that, but I need the query to return no records, and because of other statements in the where clause, this woul

RE: Empty list for an IN clause

2005-03-28 Thread Ian Skinner
e run. Please!" - Cynthia Dunning -Original Message- From: Sam Farmer [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 9:37 AM To: CF-Talk Subject: Re: Empty list for an IN clause Put the whole clause in a cfif statement: RDT

RE: Empty list for an IN clause

2005-03-28 Thread Ian Skinner
From: Scott Kellogg [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 9:44 AM To: CF-Talk ....Subject: Re: Empty list for an IN clause Add null="#yesnoformat(NOT listlen(valuelist(Safetrace.R_MDL_MOBLID)))#" RDT_MOBLID IN () Ian Ski

Re: Empty list for an IN clause

2005-03-28 Thread Sam Farmer
ww.BloodSource.org > Sacramento, CA > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > -Original Message----- > ....From: Ian Skinner > Sent: Monday, March 28, 2005 9:20 AM > To: CF-Talk > ....Subject: Empty list for an IN clause

Re: Empty list for an IN clause

2005-03-28 Thread Scott Kellogg
type="cf_sql_varchar">) AND > > >-- >Ian Skinner >Web Programmer >BloodSource >www.BloodSource.org >Sacramento, CA > >"C code. C code run. Run code run. Please!" >- Cynthia Dunning > >-Original Message----- >F

Re: Empty list for an IN clause

2005-03-28 Thread Sam Farmer
Put the whole clause in a cfif statement: RDT_MOBLID IN () Sam On Mon, 28 Mar 2005 09:19:35 -0800, Ian Skinner <[EMAIL PROTECTED]> wrote: > What is the simplest way to handle the possibility of an empty list for an IN > clause. > > For Example: > RDT_MOBLID IN (

Re: Empty list for an IN clause

2005-03-28 Thread Douglas Knudsen
in your case, perhaps this would suffice RDT_MOBLID IN () D On Mon, 28 Mar 2005 09:19:35 -0800, Ian Skinner <[EMAIL PROTECTED]> wrote: > What is the simplest way to handle the possibility of an empty list for an IN > clause. > > For Example: > RDT_MOBLID IN (

RE: Empty list for an IN clause

2005-03-28 Thread Ian Skinner
2005 9:20 AM To: CF-Talk ....Subject: Empty list for an IN clause What is the simplest way to handle the possibility of an empty list for an IN clause. For Example: RDT_MOBLID IN () -- Ian Skinner Web Programmer B

Empty list for an IN clause

2005-03-28 Thread Ian Skinner
What is the simplest way to handle the possibility of an empty list for an IN clause. For Example: RDT_MOBLID IN () -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidential