That will work fine but if there is an empty list you are asking the database to search for a clause that you know it will not find. Depending on your set up this could cause a performance hit.
Sam On Mon, 28 Mar 2005 09:27:27 -0800, Ian Skinner <[EMAIL PROTECTED]> wrote: > Ok, this seems to be working. > > RDT_MOBLID IN (<cfqueryparam > value="#listAppend(valueList(Safetrace.R_MDL_MOBLID),'0')#" list="yes" > cfsqltype="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----- > ....From: Ian Skinner > ....Sent: Monday, March 28, 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 (<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:200219 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
