>- see footer for list info -< 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 _______________________________________________ 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 -<
