>- see footer for list info -< Ok, I didn't test it, I just assumed. I guess cf ignores empty elements in a list then. You could replace the NULL with another character then like "|" or something.
Russ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of RichL Sent: 23 August 2005 10:49 To: Coldfusion Development Subject: Re: [CF-Dev] ListFind including blank >- see footer for list info -< lol.... it didn't work that's the point of the email..unless I am misunderstanding you Russ? I have empty quotes..??? <cfif Not ListFind("'',-1",qCheckPII.piirenewal,",")> I've tried removing the quotes and having a blank position in the list also but that doesn't work On 8/23/05, Snake <[EMAIL PROTECTED]> wrote: > >- see footer for list info -< > '' empty quotes. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of RichL > Sent: 23 August 2005 10:31 > To: Coldfusion Development > Subject: Re: [CF-Dev] ListFind including blank > > >- 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 -< > > > _______________________________________________ > > 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 -<
