Weird eh!

We came across this when populating a select box. We were comparing "00"
against a query that returned both "00" and "NO", and obviously both
matched.
They are supposed to be financial classifications, not true / false values!

We've coded around it, but it is a feature I would have preferred to be not
included.

Thanks all for responses.

Phil.


----- Original Message ----- 
From: "Vaughan Allan" <[EMAIL PROTECTED]>
To: "CFAussie Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, May 21, 2004 4:10 PM
Subject: [cfaussie] Re: What the???


> <CFOUTPUT>
> <CFIF (0 eq "00") and (0 eq false) and (false eq "00") and (1 eq "1") and
> ("yes" eq "1") and ("1" eq true) and ("yes" eq true)>
>         Weird eh?
> </CFIF>
> </CFOUTPUT>
>
> [EMAIL PROTECTED] wrote on 21/05/2004 04:02:29 PM:
>
> > On CFMX 6.1, windows...
> >
> > <cfif "00" eq "no">
> >      What the???
> > <cfelse>
> >      What I expect
> > </cfif>
> >
> > I get what the???
> >
> > Can anyone explain?
> >
> > Thanks,
> > Phil.
> >
> > ---
> > You are currently subscribed to cfaussie as:
> [EMAIL PROTECTED]
> > To unsubscribe send a blank email to
> [EMAIL PROTECTED]
> >
> > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
> > http://www.mxdu.com/ + 24-25 February, 2004
>
>
>
> To unsubscribe from this email please forward this email to:
[EMAIL PROTECTED]
>
> If this communication is not intended for you and you are not an
authorised recipient of this email you are prohibited by law from dealing
with or relying on the email or any file attachments. This prohibition
includes reading, printing, copying, re-transmitting, disseminating, storing
or in any other way dealing or acting in reliance on the information.  If
you have received this email in error, we request you contact ABN AMRO
Morgans Limited immediately by returning the email to
[EMAIL PROTECTED] and destroy the original. We will refund any
reasonable costs associated with notifying ABN AMRO Morgans. This email is
confidential and may contain privileged client information. ABN AMRO Morgans
has taken reasonable steps to ensure the accuracy and integrity of all its
communications, including electronic communications, but accepts no
liability for materials transmitted. Materials may also be transmitted
without the knowledge of ABN AMRO Morgans.  ABN AMRO Morgans Limited its
directors and employees do not accept liability for the results of any
actions taken or not on the basis of the information in this report. ABN
AMRO Morgans Limited and its associates hold or may hold securities in the
companies/trusts mentioned herein.  Any recommendation is made on the basis
of our research of the investment and may not suit the specific requirements
of clients.  Assessments of suitability to an individual?s portfolio can
only be made after an examination of the particular client?s investments,
financial circumstances and requirements.
> ABN AMRO Morgans Limited (ABN 49 010 669 726 AFSL 235410) A Participant of
ASX Group
>
>
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
[EMAIL PROTECTED]
>
> MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
> http://www.mxdu.com/ + 24-25 February, 2004
>


---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004

Reply via email to