CFIF problem in search criteria
I have 3 options in my search criteria ,they are Name,CompanyName and Phone number. The user can select any one of these . "Name" and "CompanyName" are working perfectly but there is some problem with the "Phone number" Please help >>The following code is for the used for searching> Untitled #GetResults.Recordcount# Client found for "#Form.Name#" + >.The following code is for search-input Untitled Document Please enter the following information: Name: OR CompanyName OR Phoneno: + >>>The following code is for Indexing Data SELECT Clt_Code, Clt_Name, Clt_CompanyName, Clt_Ph1, Clt_Email FROM Client Index Complete Index Complete --- FREE! The World's Best Email Address @email.com Reserve your name now at http://www.email.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFIF Problem with OR
or perhaps you DID read closer. :) Chris Olive DOHRS Website Administrator [EMAIL PROTECTED] -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 26, 2000 7:07 PM To: [EMAIL PROTECTED] Subject: RE: CFIF Problem with OR Ignore my lost post, didn't read it correctly the first time:-) Andrew Scott - Internet Development Totalnet Presence Pty. Ltd. Level 1-361 City Road SouthBank Vic 3006 Phone: 9690 4100 Mobile: 0412 777 958 www.totalnet.com.au > -Original Message- > From: Chris Lott [mailto:[EMAIL PROTECTED]] > Sent: Saturday, March 25, 2000 9:31 AM > To: [EMAIL PROTECTED] > Subject: Re: CFIF Problem with OR > > > > Probably a typo but actually its the opposite: > > > > listfind('4,13,43', "1") returns 0 (false) and listcontains('4,13,43', > "1") > > returns 2 (true) > > Yep, I mixed it up. The above is correct! > > -- > Chris > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > _talk or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFIF Problem with OR
um...not really. read it a bit closer. only one has to be true for the whole thing to be true. therefore, if ANY ONE of they is NOT true in his original condition, it will fail. ergo, we need ANDs. Chris Olive DOHRS Website Administrator [EMAIL PROTECTED] -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 26, 2000 7:03 PM To: [EMAIL PROTECTED] Subject: RE: CFIF Problem with OR Chris I can't believe you made that statement:-) If the ID needs to be either 1,13,4, or 43 as you have said then the cfif needs or to be either of these conditions. And means that all conditions needs to be meet before it becomes true Or means only one needs to be meet for the condition to be true:-) Andrew Scott - Internet Development Totalnet Presence Pty. Ltd. Level 1-361 City Road SouthBank Vic 3006 Phone: 9690 4100 Mobile: 0412 777 958 www.totalnet.com.au > -Original Message- > From: Olive, Christopher M Mr USACHPPM > [mailto:[EMAIL PROTECTED]] > Sent: Saturday, March 25, 2000 6:54 AM > To: '[EMAIL PROTECTED]' > Subject: RE: CFIF Problem with OR > > > so the ID has to be either 1, 13, 4, or 43? is that what you're trying to > do? > > if so, the ORs should be ANDs. what you are saying is this: > > say you have an ID of 13. > the first case is tried: ID IS NOT 1. > the ID is NOT 1, factually. so the IF returns TRUE, even though > the second > statement would return the opposite answer. > > Chris Olive > DOHRS Website Administrator > [EMAIL PROTECTED] > > > -Original Message- > From: Michel Gagnon [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 24, 2000 2:48 PM > To: [EMAIL PROTECTED] > Subject: CFIF Problem with OR > > > Hi there! > > What is wrong with this statement? > > "43")> > > I also tried: > > > > It executes what's inside even if ID is 43 > > Any ideas? > > -- > -- > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF Problem with OR
If you are truly writing the CFIF as you submitted it here, the CFIF has absolutely no way of matchine you up. Put your ID inside pound signs if you are setting a variable value. #ID# or if passing it, either #URL.ID# or #FORM.ID#. Then, I think your original will work. Dave = "Technology" is stuff that was invented after you were born. David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 - Original Message - From: Andrew Scott <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, March 26, 2000 6:03 PM Subject: RE: CFIF Problem with OR Chris I can't believe you made that statement:-) If the ID needs to be either 1,13,4, or 43 as you have said then the cfif needs or to be either of these conditions. And means that all conditions needs to be meet before it becomes true Or means only one needs to be meet for the condition to be true:-) Andrew Scott - Internet Development Totalnet Presence Pty. Ltd. Level 1-361 City Road SouthBank Vic 3006 Phone: 9690 4100 Mobile: 0412 777 958 www.totalnet.com.au > -Original Message- > From: Olive, Christopher M Mr USACHPPM > [mailto:[EMAIL PROTECTED]] > Sent: Saturday, March 25, 2000 6:54 AM > To: '[EMAIL PROTECTED]' > Subject: RE: CFIF Problem with OR > > > so the ID has to be either 1, 13, 4, or 43? is that what you're trying to > do? > > if so, the ORs should be ANDs. what you are saying is this: > > say you have an ID of 13. > the first case is tried: ID IS NOT 1. > the ID is NOT 1, factually. so the IF returns TRUE, even though > the second > statement would return the opposite answer. > > Chris Olive > DOHRS Website Administrator > [EMAIL PROTECTED] > > > -Original Message- > From: Michel Gagnon [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 24, 2000 2:48 PM > To: [EMAIL PROTECTED] > Subject: CFIF Problem with OR > > > Hi there! > > What is wrong with this statement? > > "43")> > > I also tried: > > > > It executes what's inside even if ID is 43 > > Any ideas? > > -- > -- > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFIF Problem with OR
Ignore my lost post, didn't read it correctly the first time:-) Andrew Scott - Internet Development Totalnet Presence Pty. Ltd. Level 1-361 City Road SouthBank Vic 3006 Phone: 9690 4100 Mobile: 0412 777 958 www.totalnet.com.au > -Original Message- > From: Chris Lott [mailto:[EMAIL PROTECTED]] > Sent: Saturday, March 25, 2000 9:31 AM > To: [EMAIL PROTECTED] > Subject: Re: CFIF Problem with OR > > > > Probably a typo but actually its the opposite: > > > > listfind('4,13,43', "1") returns 0 (false) and listcontains('4,13,43', > "1") > > returns 2 (true) > > Yep, I mixed it up. The above is correct! > > -- > Chris > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > _talk or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFIF Problem with OR
Chris I can't believe you made that statement:-) If the ID needs to be either 1,13,4, or 43 as you have said then the cfif needs or to be either of these conditions. And means that all conditions needs to be meet before it becomes true Or means only one needs to be meet for the condition to be true:-) Andrew Scott - Internet Development Totalnet Presence Pty. Ltd. Level 1-361 City Road SouthBank Vic 3006 Phone: 9690 4100 Mobile: 0412 777 958 www.totalnet.com.au > -Original Message- > From: Olive, Christopher M Mr USACHPPM > [mailto:[EMAIL PROTECTED]] > Sent: Saturday, March 25, 2000 6:54 AM > To: '[EMAIL PROTECTED]' > Subject: RE: CFIF Problem with OR > > > so the ID has to be either 1, 13, 4, or 43? is that what you're trying to > do? > > if so, the ORs should be ANDs. what you are saying is this: > > say you have an ID of 13. > the first case is tried: ID IS NOT 1. > the ID is NOT 1, factually. so the IF returns TRUE, even though > the second > statement would return the opposite answer. > > Chris Olive > DOHRS Website Administrator > [EMAIL PROTECTED] > > > -Original Message- > From: Michel Gagnon [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 24, 2000 2:48 PM > To: [EMAIL PROTECTED] > Subject: CFIF Problem with OR > > > Hi there! > > What is wrong with this statement? > > "43")> > > I also tried: > > > > It executes what's inside even if ID is 43 > > Any ideas? > > -- > -- > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFIF Problem with OR
Your syntax is incorrect. right now you're telling it to evaluate the block of code if ID is anything. Look at it this way... if ID is 43, it is STILL NOT 1... which means your code will execute. Change them to ANDs. Jordon -Original Message- From: Michel Gagnon [mailto:[EMAIL PROTECTED]] Sent: Friday, March 24, 2000 11:48 AM To: [EMAIL PROTECTED] Subject: CFIF Problem with OR Hi there! What is wrong with this statement? I also tried: It executes what's inside even if ID is 43 Any ideas? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF Problem with OR
> Probably a typo but actually its the opposite: > > listfind('4,13,43', "1") returns 0 (false) and listcontains('4,13,43', "1") > returns 2 (true) Yep, I mixed it up. The above is correct! -- Chris -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFIF Problem with OR
>Just be careful so you know when you need listfind and listcontains... > >listfind('4,13,43', "1") will return true >listcontains('4,13,43', "1") will not Probably a typo but actually its the opposite: listfind('4,13,43', "1") returns 0 (false) and listcontains('4,13,43', "1") returns 2 (true) Duane -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF Problem with OR
> > Try the listfind function: > > > > > > Your Code > > Just be careful so you know when you need listfind and listcontains... listfind('4,13,43', "1") will return true listcontains('4,13,43', "1") will not -- Chris -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFIF Problem with OR
Try my code -Original Message- From: Michel Gagnon [mailto:[EMAIL PROTECTED]] Sent: Friday, March 24, 2000 2:48 PM To: [EMAIL PROTECTED] Subject: CFIF Problem with OR Hi there! What is wrong with this statement? I also tried: It executes what's inside even if ID is 43 Any ideas? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF Problem with OR
Thanks! This also works very well!!! - Original Message - From: "Ian Potts" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 24, 2000 3:57 PM Subject: Re: CFIF Problem with OR > Try the listfind function: > > > Your Code > > > Ian > > Michel Gagnon wrote: > > > > Hi there! > > > > What is wrong with this statement? > > > > > "43")> > > > > I also tried: > > > > > > > > It executes what's inside even if ID is 43 > > > > Any ideas? > > > > -- > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > -- > Ian Potts > CenterGate Research Group, LLC. > http://www.centergate.com > "Technology so advanced, even we don't understand it!" > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF Problem with OR
>What is wrong with this statement? > >OR (ID IS NOT "43")> By using 'OR', you're saying it could be any of them, as long as it ain't ALL of them. Obviously it can't ever be all of them, and therefore it will always evaluate true. Try this instead: Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF Problem with OR
You are right! Thanks! - Original Message - From: "Olive, Christopher M Mr USACHPPM" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 24, 2000 3:53 PM Subject: RE: CFIF Problem with OR > so the ID has to be either 1, 13, 4, or 43? is that what you're trying to > do? > > if so, the ORs should be ANDs. what you are saying is this: > > say you have an ID of 13. > the first case is tried: ID IS NOT 1. > the ID is NOT 1, factually. so the IF returns TRUE, even though the second > statement would return the opposite answer. > > Chris Olive > DOHRS Website Administrator > [EMAIL PROTECTED] > > > -Original Message- > From: Michel Gagnon [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 24, 2000 2:48 PM > To: [EMAIL PROTECTED] > Subject: CFIF Problem with OR > > > Hi there! > > What is wrong with this statement? > > "43")> > > I also tried: > > > > It executes what's inside even if ID is 43 > > Any ideas? > > -- -- > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF Problem with OR
I tried without the quotes also - Original Message - From: "Fred Sanders" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 24, 2000 3:49 PM Subject: Re: CFIF Problem with OR > I would guess the quotes, ID is a number and your telling it a string > - Original Message - > From: "Michel Gagnon" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, March 24, 2000 1:47 PM > Subject: CFIF Problem with OR > > > > Hi there! > > > > What is wrong with this statement? > > > > > "43")> > > > > I also tried: > > > > > > > > It executes what's inside even if ID is 43 > > > > Any ideas? > > > > -- > > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFIF Problem with OR
well pick a number. say 42 42 IS NOT 1 = TRUE 42 IS NOT 13= TRUE etc. t || t || t || result = TRUE and do the if clause say 13 13 IS NOT 1 = TRUE 13 IS NOT 13= FALSE 13 IS NOT 4 = TRUE t || f || t see what i'm saying? always true, also inefficient try -Sean ___ Sean Brown <[EMAIL PROTECTED]> Systems Engineer <[EMAIL PROTECTED]> Westcar Consulting Group www.westcar.com Allaire Alliance Partner www.allaire.com ___ -Original Message- From: Michel Gagnon [mailto:[EMAIL PROTECTED]] Sent: Friday, March 24, 2000 2:48 PM To: [EMAIL PROTECTED] Subject: CFIF Problem with OR Hi there! What is wrong with this statement? I also tried: It executes what's inside even if ID is 43 Any ideas? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF Problem with OR
Try: HTH, Howie Hamlin -- inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668 === Please vote for iMS in the Most Innovative category here: *** http://www.sys-con.com/ColdFusion/readerschoice2000/ *** === Check out inFusion Mail Server - the world's most configurable email server *** inFusion Authenticator for IIS is now released! (download from CoolFusion.com) *** http://www.teletrends.com and http://www.coolfusion.com Software and utilities for ColdFusion, iHTML, Website, NTMail Latest versions available from our web site (inFusion Authenticator version 2.0 for WebSite and NTMail is now released) - Original Message - From: Michel Gagnon <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 24, 2000 2:47 PM Subject: CFIF Problem with OR > Hi there! > > What is wrong with this statement? > > "43")> > > I also tried: > > > > It executes what's inside even if ID is 43 > > Any ideas? > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFIF Problem with OR
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BF95CB.EE202C40 Content-Type: text/plain; charset="windows-1252" although it is perfered that he does not use the "" it won't throw back an error because it doesnt have to do any operations on them what he needs are AND not OR -Original Message- From: Fred Sanders [mailto:[EMAIL PROTECTED]] Sent: Friday, March 24, 2000 2:50 PM To: [EMAIL PROTECTED] Subject: Re: CFIF Problem with OR I would guess the quotes, ID is a number and your telling it a string - Original Message - From: "Michel Gagnon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 24, 2000 1:47 PM Subject: CFIF Problem with OR > Hi there! > > What is wrong with this statement? > > "43")> > > I also tried: > > > > It executes what's inside even if ID is 43 > > Any ideas? > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01BF95CB.EE202C40 Content-Type: text/html; charset="windows-1252" Content-Transfer-Encoding: quoted-printable RE: CFIF Problem with OR although it is perfered that he does not use the = "" it won't throw back an error because it doesnt have to do = any operations on them what he needs are AND not OR -Original Message- From: Fred Sanders [mailto:[EMAIL PROTECTED]">mailto:ftsdatasolutions@ma= ilroom.com] Sent: Friday, March 24, 2000 2:50 PM To: [EMAIL PROTECTED] Subject: Re: CFIF Problem with OR I would guess the quotes, ID is a number and your = telling it a string - Original Message - From: "Michel Gagnon" = <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 24, 2000 1:47 PM Subject: CFIF Problem with OR > Hi there! > > What is wrong with this statement? > > <CFIF (ID IS NOT "1") OR (ID IS = NOT "13") OR (ID IS NOT "4") OR (ID IS NOT > "43")> > > I also tried: > > <CFIF ID IS NOT = "1,13,4,43"> > > It executes what's inside even if ID is = 43 > > Any ideas? > > = = -- > Archives: http://www.eGroups.com/list/cf-talk" = TARGET=3D"_blank">http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli= sts/cf_talk" = TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= &body=3Dlists/cf_talk or send a message to [EMAIL PROTECTED] = with 'unsubscribe' in the body. ---= --- Archives: http://www.eGroups.com/list/cf-talk" = TARGET=3D"_blank">http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli= sts/cf_talk" = TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= &body=3Dlists/cf_talk or send a message to = [EMAIL PROTECTED] with 'unsubscribe' in the = body. --_=_NextPart_001_01BF95CB.EE202C40-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF Problem with OR
If you don't want it to execute when ID is 43, then you need AND's... not OR's. At 02:47 PM 3/24/2000 , you wrote: >Hi there! > >What is wrong with this statement? > >"43")> > >I also tried: > > > >It executes what's inside even if ID is 43 > >Any ideas? > >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF Problem with OR
Sounds like you want to use AND. The IF evaluates to true for the first condition (ID IS NOT "1"). Or, equivalently: ... Jim -Original Message- From: Michel Gagnon <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Friday, March 24, 2000 12:50 PM Subject: CFIF Problem with OR >Hi there! > >What is wrong with this statement? > >"43")> > >I also tried: > > > >It executes what's inside even if ID is 43 > >Any ideas? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFIF Problem with OR
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BF95CB.9CE18730 Content-Type: text/plain; charset="windows-1252" its because of the logic if your ID is 43 then it doesnt equal 1 does it? -Original Message- From: Michel Gagnon [mailto:[EMAIL PROTECTED]] Sent: Friday, March 24, 2000 2:48 PM To: [EMAIL PROTECTED] Subject: CFIF Problem with OR Hi there! What is wrong with this statement? I also tried: It executes what's inside even if ID is 43 Any ideas? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01BF95CB.9CE18730 Content-Type: text/html; charset="windows-1252" Content-Transfer-Encoding: quoted-printable RE: CFIF Problem with OR its because of the logic if your ID is 43 then it doesnt equal 1 does = it? -Original Message- From: Michel Gagnon [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]= Sent: Friday, March 24, 2000 2:48 PM To: [EMAIL PROTECTED] Subject: CFIF Problem with OR Hi there! What is wrong with this statement? <CFIF (ID IS NOT "1") OR (ID IS NOT = "13") OR (ID IS NOT "4") OR (ID IS NOT "43")> I also tried: <CFIF ID IS NOT "1,13,4,43"> It executes what's inside even if ID is 43 Any ideas? ---= --- Archives: http://www.eGroups.com/list/cf-talk" = TARGET=3D"_blank">http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli= sts/cf_talk" = TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= &body=3Dlists/cf_talk or send a message to = [EMAIL PROTECTED] with 'unsubscribe' in the = body. --_=_NextPart_001_01BF95CB.9CE18730-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF Problem with OR
Think about it, if ID is 43, its is NOT 13, and it is NOT 1so the expression evaluates to TRUE. I think you want AND's here, not OR's. Brian - Original Message - From: Michel Gagnon <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 24, 2000 1:47 PM Subject: CFIF Problem with OR > Hi there! > > What is wrong with this statement? > > "43")> > > I also tried: > > > > It executes what's inside even if ID is 43 > > Any ideas? > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFIF Problem with OR
The first statement will ALWAYS be true. You probably want to change the ORs to ANDs. If you want to CFIF block to be true if ID is not 1 or 13 or 4 or 43, change the ORs to ANDs. === Raymond Camden, Webmaster of the Death Clock (www.deathclock.com) Cold Fusion Jedi Master for Syntegra (www.syntegra.com) Allaire Certified Instructor and Member of Team Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Michel Gagnon [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 24, 2000 2:48 PM > To: [EMAIL PROTECTED] > Subject: CFIF Problem with OR > > > Hi there! > > What is wrong with this statement? > > "43")> > > I also tried: > > > > It executes what's inside even if ID is 43 > > Any ideas? > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > _talk or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF Problem with OR
Try the listfind function: Your Code Ian Michel Gagnon wrote: > > Hi there! > > What is wrong with this statement? > > "43")> > > I also tried: > > > > It executes what's inside even if ID is 43 > > Any ideas? > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Ian Potts CenterGate Research Group, LLC. http://www.centergate.com "Technology so advanced, even we don't understand it!" -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFIF Problem with OR
so the ID has to be either 1, 13, 4, or 43? is that what you're trying to do? if so, the ORs should be ANDs. what you are saying is this: say you have an ID of 13. the first case is tried: ID IS NOT 1. the ID is NOT 1, factually. so the IF returns TRUE, even though the second statement would return the opposite answer. Chris Olive DOHRS Website Administrator [EMAIL PROTECTED] -Original Message- From: Michel Gagnon [mailto:[EMAIL PROTECTED]] Sent: Friday, March 24, 2000 2:48 PM To: [EMAIL PROTECTED] Subject: CFIF Problem with OR Hi there! What is wrong with this statement? I also tried: It executes what's inside even if ID is 43 Any ideas? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF Problem with OR
I would guess the quotes, ID is a number and your telling it a string - Original Message - From: "Michel Gagnon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 24, 2000 1:47 PM Subject: CFIF Problem with OR > Hi there! > > What is wrong with this statement? > > "43")> > > I also tried: > > > > It executes what's inside even if ID is 43 > > Any ideas? > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFIF Problem with OR
Hi there! What is wrong with this statement? I also tried: It executes what's inside even if ID is 43 Any ideas? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.