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