Syntax Question
am 17.11.2007 14:55:39 von J-P-W
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
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
Re: Syntax Question
am 17.11.2007 15:33:47 von reb01501
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"
Re: Syntax Question
am 17.11.2007 16:31:31 von J-P-W
On 17 Nov, 14:33, "Bob Barrows [MVP]"
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 -
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
Cool :)
Re: Syntax Question
am 17.11.2007 17:21:42 von reb01501
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"
Re: Syntax Question
am 17.11.2007 17:53:00 von J-P-W
On 17 Nov, 16:21, "Bob Barrows [MVP]"
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"
Whoops that was a typo, however, your last solution is the neatest -
thanks Bob
Jon
Re: Syntax Question
am 17.11.2007 18:53:21 von McKirahan
"J-P-W" wrote in message
news:af03f197-91f9-49e5-874a-7393f2dd38da@e1g2000hsh.googleg roups.com...
[snip]
> On 17 Nov, 14:33, "Bob Barrows [MVP]"
> 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
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
Re: Syntax Question
am 17.11.2007 19:45:57 von exjxw.hannivoort
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
--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
Re: Syntax Question
am 18.11.2007 07:53:41 von me
"Evertjan." wrote in message
news: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
>
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
>
> --
> Evertjan.
> The Netherlands.
> (Please change the x'es to dots in my emailaddress)
Re: Syntax Question
am 18.11.2007 16:18:48 von McKirahan
"ThatsIT.net.au" wrote in message
news:67AA2DFD-4317-4A5D-8BDD-14D45520ADDA@microsoft.com...
>
> "Evertjan." 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
Re: Syntax Question
am 23.11.2007 18:23:08 von me
"McKirahan" wrote in message
news:WpmdnWFbL48syt3anZ2dnUVZ_tuonZ2d@comcast.com...
> "ThatsIT.net.au" wrote in message
> news:67AA2DFD-4317-4A5D-8BDD-14D45520ADDA@microsoft.com...
>>
>> "Evertjan." 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
Re: Syntax Question
am 23.11.2007 19:48:18 von McKirahan
"ThatsIT.net.au" wrote in message
news:0B03165D-385B-490C-AB08-AB59F67BC46D@microsoft.com...
>
> "McKirahan" wrote in message
> news:WpmdnWFbL48syt3anZ2dnUVZ_tuonZ2d@comcast.com...
> > "ThatsIT.net.au" wrote in message
> > news:67AA2DFD-4317-4A5D-8BDD-14D45520ADDA@microsoft.com...
> >>
> >> "Evertjan." 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
Re: Syntax Question
am 25.11.2007 14:51:45 von me
"McKirahan" wrote in message
news:dYKdnbRn_v3avdranZ2dnUVZ_rWtnZ2d@comcast.com...
> "ThatsIT.net.au" wrote in message
> news:0B03165D-385B-490C-AB08-AB59F67BC46D@microsoft.com...
>>
>> "McKirahan" wrote in message
>> news:WpmdnWFbL48syt3anZ2dnUVZ_tuonZ2d@comcast.com...
>> > "ThatsIT.net.au" wrote in message
>> > news:67AA2DFD-4317-4A5D-8BDD-14D45520ADDA@microsoft.com...
>> >>
>> >> "Evertjan." 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
>
OK I see what you mean, my error