>- 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 -<
