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