in your case, perhaps this would suffice <cfif safetrace.recordcount GT 0> RDT_MOBLID IN (<cfqueryparam value="#valueList(Safetrace.R_MDL_MOBLID)#" list="yes" cfsqltype="cf_sql_varchar">) </cfif>
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 (<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. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200215 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
