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
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
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
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
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
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 (
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 (
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
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
9 matches
Mail list logo