>- see footer for list info -< Thanks Robin and Steve I've decided to go for the GTE 1 route and more detailed commenting !!
cheers for all that replied with ideas..... i find this list v.interesting as you always get about 5 different approcahes to solve a challenge ;o) On 8/23/05, Robin Griffiths <[EMAIL PROTECTED]> wrote: > >- 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 -< > -- 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 -<
