try this:
<cfset mdlList = valueList (Safetrace.R_MDL_MOBLID)>
<cfif listLen (mdlList) gt 0>
run your normal query
<cfelse>
select * from your table
where 0 = 1
</cfif>
Marius Milosav
www.scorpiosoft.com
It's not about Technology, it's about people
Virtual Company (VICO) Application demo
www.scorpiosoft.com/vicodemo/login.cfm
----- Original Message -----
From: "Ian Skinner" <[EMAIL PROTECTED]>
To: "CF-Talk" <cf-talk@houseoffusion.com>
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 would cause the query to
return all records.
>
>
> --------------
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
>
> "C code. C code run. Run code 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:
> ....
> ....<cfif Safetrace.recordCount>
> .... RDT_MOBLID IN (<cfqueryparam
> ....value="#valueList(Safetrace.R_MDL_MOBLID)#" list="yes"
> ....cfsqltype="cf_sql_varchar">)
> ....</cfif>
> ....
> ....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 (<cfqueryparam
> ....value="#valueList(Safetrace.R_MDL_MOBLID)#" list="yes"
> ....cfsqltype="cf_sql_varchar">)
> ....>
> ....> --------------
> ....> Ian Skinner
> ....> Web Programmer
> ....> BloodSource
> ....> www.BloodSource.org
> ....> Sacramento, CA
> ....>
> ....> "C code. C code run. Run code run. Please!"
> ....> - Cynthia Dunning
> ....>
> ....> Confidentiality Notice: This message including any
> ....> attachments is for the sole use of the intended
> ....> recipient(s) and may contain confidential and privileged
> ....> information. Any unauthorized review, use, disclosure or
> ....> distribution is prohibited. If you are not the
> ....> intended recipient, please contact the sender and
> ....> delete any copies of this message.
> ....>
> ....>
> ....
> ....
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200224
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
