>- see footer for list info -<
Rich
I think you're hitting a CF 'feature' whereby empty lists are ignored, so:
<cfset myList = "a,b,,c,,,d,e">
<cfoutput>
#listLen(myList)#
</cfoutput>
Gives 5!
I think you'd be better off putting the list values in an array, then
looping through the array and comparing it against the value from the query.
An extra few lines, but not the end of the world... and you could always
comment what you've done to clarify the business logic ;-)
Cheers
Robin
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of RichL
Sent: 23 August 2005 10:53
To: Coldfusion Development
Subject: Re: [CF-Dev] ListFind including blank
>- see footer for list info -<
yes I did think about that ... but I wanted to put the actual values I
don't want in there to show some exact business logic within the code
itself for maintenance purposes - which is why I was trying to use the
ListFind with Not - to show the business cases I don't want to find
On 8/23/05, Allan Cliff <[EMAIL PROTECTED]> wrote:
> >- see footer for list info -<
> If it is always a numeric value then
>
> <CFIF NOT val(qCheckPII.piirenewal) LTE 0>
>
> Allan
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of RichL
> Sent: 23 August 2005 11:41
> To: Coldfusion Development
> Subject: Re: [CF-Dev] ListFind including blank
>
>
> >- see footer for list info -<
> what I am trying to achieve is the following using ListFind:
>
> <cfif (qCheckPII.piirenewal IS NOT -1 ) AND (qCheckPII.piirenewal IS NOT
> '')>
>
>
>
> On 8/23/05, RichL <[EMAIL PROTECTED]> wrote:
> > No the list is one I am manually creating - the query variable is just
>
> > one single value that I want to check the list with.
> >
> > It is the manual list that I want to put a blank in to check if the
> > query variable may be NULL (amongst other things)
> >
> > but it is not recognising the query variable within the list when the
> > query variable value on the DB is null
> >
> > On 8/23/05, Snake <[EMAIL PROTECTED]> wrote:
> > > >- see footer for list info -<
> > > If you are using Valuelist() to convert your query to a list, then
> > > the null should be an empty value in the list.
> > >
> > > I.E.
> > >
> > > 1,2,,4,5
> > >
> > > Russ
> > >
> > > -----Original Message-----
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED] On Behalf Of RichL
> > > Sent: 23 August 2005 10:12
> > > To: cfdev
> > > Subject: [CF-Dev] ListFind including blank
> > >
> > > >- see footer for list info -<
> > > Hi guys
> > >
> > > <cfif Not ListFind("'',-1",qCheckPII.piirenewal,",")>
> > > <option value="X">remove override</option> </cfif>
> > >
> > > I want to check a variable against two values in a list. one of the
> > > values i want to check is for blank (in case it comes back from the
> > > DB as Null but the ListFind doesn't seem to pick up the blank
> > > although the -1 is working.
> > >
> > > The code is above. For clarity - at the beginnin is one double
> > > quote, then two single quotes (to try and do the NULL) then a comma,
>
> > > then the minus 1 then the end double quote to end the list.
> > >
> > > What do I need to change to make the NULL value be picked up in the
> > > ListFind (I am presuming that you can do this in one step) ??
> > > --
> > > Rich
> > > _______________________________________________
> > >
> > > For details on ALL mailing lists and for joining or leaving lists,
> > > go to http://list.cfdeveloper.co.uk/mailman/listinfo
> > >
> > > --
> > > CFDeveloper Sponsors:-
> > > >- Hosting provided by www.cfmxhosting.co.uk -<
> > > >- Forum provided by www.fusetalk.com -<
> > > >- DHTML Menus provided by www.APYCOM.com -<
> > > >- Lists hosted by www.Gradwell.com -<
> > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your
> > > >help -<
> > >
> > >
> > > _______________________________________________
> > >
> > > For details on ALL mailing lists and for joining or leaving lists,
> > > go to http://list.cfdeveloper.co.uk/mailman/listinfo
> > >
> > > --
> > > CFDeveloper Sponsors:-
> > > >- Hosting provided by www.cfmxhosting.co.uk -<
> > > >- Forum provided by www.fusetalk.com -<
> > > >- DHTML Menus provided by www.APYCOM.com -<
> > > >- Lists hosted by www.Gradwell.com -<
> > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your
> > > >help -<
> > >
> >
> >
> > --
> > Rich
> >
>
>
> --
> Rich
> _______________________________________________
>
> For details on ALL mailing lists and for joining or leaving lists, go to
> http://list.cfdeveloper.co.uk/mailman/listinfo
>
> --
> CFDeveloper Sponsors:-
> >- Hosting provided by www.cfmxhosting.co.uk -<
> >- Forum provided by www.fusetalk.com -<
> >- DHTML Menus provided by www.APYCOM.com -<
> >- Lists hosted by www.Gradwell.com -<
> >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help
>
> >-<
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> ______________________________________________________________________
> _______________________________________________
>
> For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
>
> --
> CFDeveloper Sponsors:-
> >- Hosting provided by www.cfmxhosting.co.uk -<
> >- Forum provided by www.fusetalk.com -<
> >- DHTML Menus provided by www.APYCOM.com -<
> >- Lists hosted by www.Gradwell.com -<
> >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help
-<
>
--
Rich
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Forum provided by www.fusetalk.com -<
>- DHTML Menus provided by www.APYCOM.com -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Forum provided by www.fusetalk.com -<
>- DHTML Menus provided by www.APYCOM.com -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
