Re: IsDefined do this...

2002-11-20 Thread Stephen Moretti
> Still, however, I am confused about your solution. When I run it (and the > ListFindNoCase version), it doesn't work, but the FindNoCase version does. > I'm not sure why. In any case, what is the inconsistency in results that > you mention with FindNoCase? I'd just like to know so that I avoid

RE: IsDefined do this...

2002-11-19 Thread Cornillon, Matthieu
FindNoCase? I'd just like to know so that I avoid future pitfalls. Thanks, Matthieu -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 12:09 PM To: CF-Talk Subject: Re: IsDefined do this... > Would you post the exact cfif sta

Re: IsDefined do this...

2002-11-19 Thread Stephen Moretti
> Would you post the exact cfif statement (non-nested version) > you are using that is causing a problem and let us know what error it's > showing? > > You could also use this: > > FindNoCase("documents",qgetdir.strOmit)> > Nope You get the same inconsistant results as CONTAINS. > The docume

RE: IsDefined do this...

2002-11-19 Thread FlashGuy
false and any other number > will evaluate to true. > > Hope this is useful. > > Matthieu > > > > -Original Message- > From: FlashGuy [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 19, 2002 11:24 AM > To: CF-Talk > Subject: Re: IsDefined do

RE: IsDefined do this...

2002-11-19 Thread Cornillon, Matthieu
CF-Talk Subject: Re: IsDefined do this... I tried the below but it won't work? Only the nested No > > You can do it in one CFIF. No need to nest > > GT 0> > > If CFIF fails on one part of the condition it doesn't evaluate the rest of > the condition

Re: IsDefined do this...

2002-11-19 Thread Stephen Moretti
> I tried the below but it won't work? > Won't work? What's the error? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forum

Re: IsDefined do this...

2002-11-19 Thread FlashGuy
ginal Message - > From: "John Beynon" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, November 19, 2002 4:02 PM > Subject: RE: IsDefined do this... > > > > Would that not be a nested CFIF block? > > > >

RE: IsDefined do this...

2002-11-19 Thread FlashGuy
That worked. Thanks much. On Tue, 19 Nov 2002 16:02:16 -, John Beynon wrote: > Would that not be a nested CFIF block? > > > > ... > > ... > > > > jb. > > -Original Message- > From: FlashGuy [mailto:[EMAIL PROTECTED]] > Sent: 19 November 2002 15:

Re: IsDefined do this...

2002-11-19 Thread Stephen Moretti
the result you expect if there is more than one occurance of 'documents' in the strOmit list. Regards Stephen - Original Message - From: "John Beynon" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 19, 2002 4:02 PM

RE: IsDefined do this...

2002-11-19 Thread Dave Watts
> > > Len(Trim(qgetdir.strOmit)) GT 0> > > Would that not be a nested CFIF block? > > > > ... > > ... > > The original CFIF condition is fine. In CF 4.0.1 and higher, CF will perform short-circuit evaluation, so that if the first conditional part of a compound

Re: IsDefined do this...

2002-11-19 Thread Bryan Stevenson
OTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 19, 2002 8:02 AM Subject: RE: IsDefined do this... > Would that not be a nested CFIF block? > > > > ... > > ... > > > > jb. > > -Original Message- > From

RE: IsDefined do this...

2002-11-19 Thread John Beynon
Would that not be a nested CFIF block? ... ... jb. -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 19 November 2002 15:54 To: CF-Talk Subject: IsDefined do this... Hi, I'm checking a field in my database and if its equal

RE: IsDefined do this...

2002-11-19 Thread Adrian Lynch
Would putting an AND in there help? Ade -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 19 November 2002 15:54 To: CF-Talk Subject: IsDefined do this... Hi, I'm checking a field in my database and if its equal to something do this...otherwise...do else... Here is my