Discuss "If-Then Problem" in the ASP Development forum.

todd2006 · #1 (**permalink**) April 7th, 2008, 01:35 PM

If problem

--------------------------------------------------------------------------------

Hi,

I have 3 variables which store values like this

lunch="1"
dinner="2"
snacks="3"

if lunch is selected then the value is 1 if not its blank
if dinner is selected then the value is 2 if not its blank
if snacks is selected then the value is 3 if not its blank

If all 3 are selected the price is $12
if 2 of them is selected the price is $8
if one of them is selected the price is $5

so here is the code

Code:

If lunch="1" And dinner="2" And snacks="3" Then
	finaltotal="12"
End If

If (lunch="1" And dinner="2") or (lunch="1" And snacks="3") Or (dinner="2" And snacks="3") Then
	finaltotal="8"

End If

If (lunch="1") Or (dinner="2") Or (snacks="3")  Then
	finaltotal="5"
End If

but its not working any idea

todd

mehere · #2 (**permalink**) April 7th, 2008, 01:38 PM

need to use ElseIfs ... the way you have it now, is that you're going to go through each if/then statement ... hence you could change your variable value. try something like this:

Code:

If lunch="1" And dinner="2" And snacks="3" Then
	finaltotal="12"
ElseIf (lunch="1" And dinner="2") or (lunch="1" And snacks="3") Or (dinner="2" And snacks="3") Then
	finaltotal="8"
ElseIf (lunch="1") Or (dinner="2") Or (snacks="3")  Then	
             finaltotal="5"
End If

Wolffy · #3 (**permalink**) April 7th, 2008, 01:54 PM

Any particular reason your variables need to be 1, 2 and 3 (and strings no less). If you can make it so that variable=1 if select, 0 if not, then this becomes a much easier problem by using a SELECT CASE.

Code:

SELECT CASE lunch+dinner+snacks  ' assume Int, otherwise convert
CASE 3 
  finaltotal = 12
CASE 2
  finaltotal = 8
CASE 1
  finaltotal = 5
CASE ELSE
  finaltotal = 0
END SELECT

In the event the values just have to be different, can you make it 1, 2 and 4? Then

Code:

SELECT CASE lunch+dinner+snacks  ' assume Int, otherwise convert
CASE 7 
  finaltotal = 12
CASE 3,5,6
  finaltotal = 8
CASE 1,2,4
  finaltotal = 5
CASE ELSE
  finaltotal = 0
END SELECT

richyrich · #4 (**permalink**) April 30th, 2008, 05:35 AM

Due to inactivity of 14 days, this thread is deemed abandoned and is now closed. If this thread was marked as "Solved", the orginal poster may mark it as "Unsolved" via the Thread Tools menu, thus re-opening the thread. If this thread was not marked as "Solved", the original poster may re-open the thread via the Thread Tools menu.

Regards,

richyrich
DeveloperBarn Forums Moderator

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Discuss "If-Then Problem" in the ASP Development forum.

ASP Development - Learn coding practices and tips to get the best out of your Active Server Pages (ASP). The Classic ASP forum is for ASP/VBScript and ASP/JScript applications.