Empty list for an IN clause

2005-03-28 Thread Ian Skinner
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

RE: Empty list for an IN clause

2005-03-28 Thread Ian Skinner
! - 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

Re: Empty list for an IN clause

2005-03-28 Thread Douglas Knudsen
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

Re: Empty list for an IN clause

2005-03-28 Thread Sam Farmer
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

Re: Empty list for an IN clause

2005-03-28 Thread Scott Kellogg
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

Re: Empty list for an IN clause

2005-03-28 Thread Sam Farmer
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

RE: Empty list for an IN clause

2005-03-28 Thread Ian Skinner
[mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 9:44 AM To: CF-Talk Subject: Re: Empty list for an IN clause Add null=#yesnoformat(NOT listlen(valuelist(Safetrace.R_MDL_MOBLID)))# RDT_MOBLID IN (cfqueryparam value=#valueList(Safetrace.R_MDL_MOBLID)# list=yes

RE: Empty list for an IN clause

2005-03-28 Thread Ian Skinner
. Please! - Cynthia Dunning -Original Message- From: Sam Farmer [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 9:37 AM To: CF-Talk Subject: Re: Empty list for an IN clause Put the whole clause in a cfif statement: cfif Safetrace.recordCount

Re: Empty list for an IN clause

2005-03-28 Thread Marius Milosav
www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Ian Skinner [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 28, 2005 12:51 PM Subject: RE: Empty list for an IN clause I thought of that, but I need the query to return no records, and because