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
!
- 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
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
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
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
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
[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
. 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
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
9 matches
Mail list logo