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