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. .... .... .... .... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:200213 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
