>- see footer for list info -<
Not ideal, but you could add a character to force the null to be something,
like ...
<CFIF ListFind("|,|-1","|"&qCheckPII.piirenewal,",")>
... doesn't have to be |, of course, you can use any character you want
-----Original Message-----
From: RichL [mailto:[EMAIL PROTECTED]
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 -<
****************************************************************************
Notice: This e-mail and any attachments are confidential and may contain
legally privileged information and/or copyright material of Hansen
Technologies Limited or third parties. Copying, distributing, disclosing,
commercialising or otherwise acting in reliance on this e-mail and any
attachments is strictly prohibited unless you are the addressee of this
e-mail and have written permission to do so. If you have received this
e-mail in error please delete this e-mail (including any copies and
attachments) and contact Hansen Technologies Limited by return e-mail or by
telephone on + 61 39840 3000. Any views expressed in this e-mail are those
of the individual sender and may not necessarily reflect the views of or be
a commitment by the organisation, except where the individual sender has the
authority and expressly states them to be so.
****************************************************************************
_______________________________________________
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 -<
