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