|
it
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Syntax Question
I want to evaluate 2 things, "Area" and "SubsQuestions" I need to know if Area = "Six" or Area = "Seven" AND SubsQuestions = "Yes" Is it ....... If Area = "Six" or Area = "Seven" AND SubsQuestions = "Yes" Then or ....... If Area = "Six" AND SubsQuestions = "Yes" or Area = "Seven" AND SubsQuestions = "Yes" Then To confirm...... Six and No is to be ignored ...... Seven and No is to be ignored ...... Seven and Yes will be dealt with ...... Six and Yes will be dealt with I'm getting confused just typing it! Thanks Jon J-P-W wrote:
Show quote > Hi, If Area = "Six" or (Area = "Seven" AND SubsQuestions ="Yes") then> > I want to evaluate 2 things, "Area" and "SubsQuestions" > > I need to know if Area = "Six" or Area = "Seven" AND SubsQuestions = > "Yes" > > Is it > > ...... If Area = "Six" or Area = "Seven" AND SubsQuestions = "Yes" > Then > > or > > ...... If Area = "Six" AND SubsQuestions = "Yes" or Area = "Seven" AND > SubsQuestions = "Yes" Then > Simple grouping -- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
Show quote
On 17 Nov, 14:33, "Bob Barrows [MVP]" <reb01...@NOyahoo.SPAMcom> Thanks.wrote: > J-P-W wrote: > > Hi, > > > I want to evaluate 2 things, "Area" and "SubsQuestions" > > > I need to know if Area = "Six" or Area = "Seven" AND SubsQuestions = > > "Yes" > > > Is it > > > ...... If Area = "Six" or Area = "Seven" AND SubsQuestions = "Yes" > > Then > > > or > > > ...... If Area = "Six" AND SubsQuestions = "Yes" or Area = "Seven" AND > > SubsQuestions = "Yes" Then > > Simple grouping > > If Area = "Six" or (Area = "Seven" AND SubsQuestions ="Yes") then > > -- > Microsoft MVP - ASP/ASP.NET > Please reply to the newsgroup. This email account is my spam trap so I > don't check it very often. If you must reply off-line, then remove the > "NO SPAM"- Hide quoted text - > > - Show quoted text - So I can have: If Area = ("Six" AND SubsQuestions = "Yes") or (Area = "Seven" AND SubsQuestions = "Yes") Then 'Do stuff Else 'Do not End If Cool :) J-P-W wrote:
>> No, that is not possible - the first parenthesis is in the wrong location: >> - Show quoted text - > > Thanks. > > So I can have: > > If Area = ("Six" AND SubsQuestions = "Yes") or (Area = "Seven" AND > SubsQuestions = "Yes") Then > 'Do stuff > Else > 'Do not > End If > it needs to be infront of Area: If (Area = "Six" AND SubsQuestions = "Yes") or _ (Area = "Seven" AND SubsQuestions = "Yes") Then It's also too verbose. This does exactly the same thing (the commutative property applies to boolean operators as well as arithmetic operators): If (Area = "Six" or Area = "Seven") AND SubsQuestions = "Yes" Then -- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
Show quote
On 17 Nov, 16:21, "Bob Barrows [MVP]" <reb01...@NOyahoo.SPAMcom> Whoops that was a typo, however, your last solution is the neatest -wrote: > J-P-W wrote: > > >> - Show quoted text - > > > Thanks. > > > So I can have: > > > If Area = ("Six" AND SubsQuestions = "Yes") or (Area = "Seven" AND > > SubsQuestions = "Yes") Then > > 'Do stuff > > Else > > 'Do not > > End If > > No, that is not possible - the first parenthesis is in the wrong location: > it needs to be infront of Area: > > If (Area = "Six" AND SubsQuestions = "Yes") or _ > (Area = "Seven" AND SubsQuestions = "Yes") Then > > It's also too verbose. This does exactly the same thing (the commutative > property applies to boolean operators as well as arithmetic operators): > > If (Area = "Six" or Area = "Seven") AND SubsQuestions = "Yes" Then > > -- > Microsoft MVP - ASP/ASP.NET > Please reply to the newsgroup. This email account is my spam trap so I > don't check it very often. If you must reply off-line, then remove the > "NO SPAM" thanks Bob Jon "J-P-W" <jonpw***@gmail.com> wrote in message [snip]news:af03f197-91f9-49e5-874a-7393f2dd38da@e1g2000hsh.googlegroups.com... > On 17 Nov, 14:33, "Bob Barrows [MVP]" <reb01...@NOyahoo.SPAMcom> Yes; though your first set of parentheses is wrong.> wrote: > > If Area = "Six" or (Area = "Seven" AND SubsQuestions ="Yes") then > So I can have: > > If Area = ("Six" AND SubsQuestions = "Yes") or (Area = "Seven" AND > SubsQuestions = "Yes") Then > 'Do stuff > Else > 'Do not > End If Also, for readability, take a look at this: If (SubsQuestions = "Yes" And Area = "Six") _ Or (SubsQuestions = "Yes" And Area = "Seven") Then 'Do stuff Else 'Do not End If McKirahan wrote on 17 nov 2007 in
microsoft.public.inetserver.asp.general: > Yes; though your first set of parentheses is wrong. I prefer for readability:> Also, for readability, take a look at this: > > If (SubsQuestions = "Yes" And Area = "Six") _ > Or (SubsQuestions = "Yes" And Area = "Seven") Then > 'Do stuff > Else > 'Do not > End If > SQy = SubsQuestions = "Yes" A6 = Area = "Six" A7 = Area = "Seven" If SQy AND (A6 OR A7) Then 'Do stuff Else 'Do not End If or: SQy = SubsQuestions = "Yes" A6 = Area = "Six" A7 = Area = "Seven" A6orA7 = A6 OR A7 If SQy AND A6orA7 Then 'Do stuff Else 'Do not End If -- Evertjan. The Netherlands. (Please change the x'es to dots in my emailaddress)
Show quote
"Evertjan." <exjxw.hannivo***@interxnl.net> wrote in message To use a bit of both your suggestionsnews:Xns99EBC912567ACeejj99@194.109.133.242... > McKirahan wrote on 17 nov 2007 in > microsoft.public.inetserver.asp.general: > >> Yes; though your first set of parentheses is wrong. >> Also, for readability, take a look at this: >> >> If (SubsQuestions = "Yes" And Area = "Six") _ >> Or (SubsQuestions = "Yes" And Area = "Seven") Then >> 'Do stuff >> Else >> 'Do not >> End If >> > > I prefer for readability: > > SQy = SubsQuestions = "Yes" > A6 = Area = "Six" > A7 = Area = "Seven" > > If SQy AND (A6 OR A7) Then > 'Do stuff > Else > 'Do not > End If > > or: > > SQy = SubsQuestions = "Yes" > A6 = Area = "Six" > A7 = Area = "Seven" > A6orA7 = A6 OR A7 > > If SQy AND A6orA7 Then > 'Do stuff > Else > 'Do not > End If > testQ = (SubsQuestions = "Yes") test6 = (Area = "Six") test7 = (Area = "Seven") IF testQ then IF test6 OR test7 THEN 'Do stuff END IF ELSE 'Do not END IF Show quote > > -- > Evertjan. > The Netherlands. > (Please change the x'es to dots in my emailaddress) "ThatsIT.net.au" <me@thatsit> wrote in message [snip]news:67AA2DFD-4317-4A5D-8BDD-14D45520ADDA@microsoft.com... > > "Evertjan." <exjxw.hannivo***@interxnl.net> wrote in message > news:Xns99EBC912567ACeejj99@194.109.133.242... > > [snip]> > I prefer for readability: > > > > SQy = SubsQuestions = "Yes" > > A6 = Area = "Six" > > A7 = Area = "Seven" > > > > If SQy AND (A6 OR A7) Then > > 'Do stuff > > Else > > 'Do not > > End If > To use a bit of both your suggestions Sorry, that's not equivalent;you don't handle:> testQ = (SubsQuestions = "Yes") > test6 = (Area = "Six") > test7 = (Area = "Seven") > > IF testQ then > IF test6 OR test7 THEN > 'Do stuff > END IF > ELSE > 'Do not > END IF IF test6 OR test7 THEN's ELSE
Show quote
"McKirahan" <N***@McKirahan.com> wrote in message yes it is,news:WpmdnWFbL48syt3anZ2dnUVZ_tuonZ2d@comcast.com... > "ThatsIT.net.au" <me@thatsit> wrote in message > news:67AA2DFD-4317-4A5D-8BDD-14D45520ADDA@microsoft.com... >> >> "Evertjan." <exjxw.hannivo***@interxnl.net> wrote in message >> news:Xns99EBC912567ACeejj99@194.109.133.242... > > [snip] > >> > >> > I prefer for readability: >> > >> > SQy = SubsQuestions = "Yes" >> > A6 = Area = "Six" >> > A7 = Area = "Seven" >> > >> > If SQy AND (A6 OR A7) Then >> > 'Do stuff >> > Else >> > 'Do not >> > End If > > [snip] > >> To use a bit of both your suggestions >> testQ = (SubsQuestions = "Yes") >> test6 = (Area = "Six") >> test7 = (Area = "Seven") >> >> IF testQ then >> IF test6 OR test7 THEN >> 'Do stuff >> END IF >> ELSE >> 'Do not >> END IF > > Sorry, that's not equivalent;you don't handle: > IF test6 OR test7 THEN's ELSE first subquerys must be true or it fails, only if subquerys is true need we test test6 or test7
Show quote
"ThatsIT.net.au" <me@thatsit> wrote in message Sorry, it's not.news:0B03165D-385B-490C-AB08-AB59F67BC46D@microsoft.com... > > "McKirahan" <N***@McKirahan.com> wrote in message > news:WpmdnWFbL48syt3anZ2dnUVZ_tuonZ2d@comcast.com... > > "ThatsIT.net.au" <me@thatsit> wrote in message > > news:67AA2DFD-4317-4A5D-8BDD-14D45520ADDA@microsoft.com... > >> > >> "Evertjan." <exjxw.hannivo***@interxnl.net> wrote in message > >> news:Xns99EBC912567ACeejj99@194.109.133.242... > > > > [snip] > > > >> > > >> > I prefer for readability: > >> > > >> > SQy = SubsQuestions = "Yes" > >> > A6 = Area = "Six" > >> > A7 = Area = "Seven" > >> > > >> > If SQy AND (A6 OR A7) Then > >> > 'Do stuff > >> > Else > >> > 'Do not > >> > End If > > > > [snip] > > > >> To use a bit of both your suggestions > >> testQ = (SubsQuestions = "Yes") > >> test6 = (Area = "Six") > >> test7 = (Area = "Seven") > >> > >> IF testQ then > >> IF test6 OR test7 THEN > >> 'Do stuff > >> END IF > >> ELSE > >> 'Do not > >> END IF > > > > Sorry, that's not equivalent;you don't handle: > > IF test6 OR test7 THEN's ELSE > > > yes it is, > > first subquerys must be true or it fails, only if subquerys is true need we > test test6 or test7 If the second test fails you do not perform "Do not". IF testQ then IF test6 OR test7 THEN 'Do stuff ELSE <= you don't allow for this 'Do not END IF ELSE 'Do not END IF
Show quote
"McKirahan" <N***@McKirahan.com> wrote in message OK I see what you mean, my errornews:dYKdnbRn_v3avdranZ2dnUVZ_rWtnZ2d@comcast.com... > "ThatsIT.net.au" <me@thatsit> wrote in message > news:0B03165D-385B-490C-AB08-AB59F67BC46D@microsoft.com... >> >> "McKirahan" <N***@McKirahan.com> wrote in message >> news:WpmdnWFbL48syt3anZ2dnUVZ_tuonZ2d@comcast.com... >> > "ThatsIT.net.au" <me@thatsit> wrote in message >> > news:67AA2DFD-4317-4A5D-8BDD-14D45520ADDA@microsoft.com... >> >> >> >> "Evertjan." <exjxw.hannivo***@interxnl.net> wrote in message >> >> news:Xns99EBC912567ACeejj99@194.109.133.242... >> > >> > [snip] >> > >> >> > >> >> > I prefer for readability: >> >> > >> >> > SQy = SubsQuestions = "Yes" >> >> > A6 = Area = "Six" >> >> > A7 = Area = "Seven" >> >> > >> >> > If SQy AND (A6 OR A7) Then >> >> > 'Do stuff >> >> > Else >> >> > 'Do not >> >> > End If >> > >> > [snip] >> > >> >> To use a bit of both your suggestions >> >> testQ = (SubsQuestions = "Yes") >> >> test6 = (Area = "Six") >> >> test7 = (Area = "Seven") >> >> >> >> IF testQ then >> >> IF test6 OR test7 THEN >> >> 'Do stuff >> >> END IF >> >> ELSE >> >> 'Do not >> >> END IF >> > >> > Sorry, that's not equivalent;you don't handle: >> > IF test6 OR test7 THEN's ELSE >> >> >> yes it is, >> >> first subquerys must be true or it fails, only if subquerys is true need > we >> test test6 or test7 > > Sorry, it's not. > > If the second test fails you do not perform "Do not". > > IF testQ then > IF test6 OR test7 THEN > 'Do stuff > ELSE <= you don't allow for this > 'Do not > END IF > ELSE > 'Do not > END IF >  |
|||||||||||||||||||||||
Other interesting topics