Add null="#yesnoformat(NOT listlen(valuelist(Safetrace.R_MDL_MOBLID)))#"
RDT_MOBLID IN (<cfqueryparam value="#valueList(Safetrace.R_MDL_MOBLID)#" list="yes" cfsqltype="cf_sql_varchar" null="#yesnoformat(NOT listlen(valuelist(Safetrace.R_MDL_MOBLID)))#">) Ian Skinner 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. >.... >.... >.... >.... > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:200218 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