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

Reply via email to