Compound conditions question

[rosn459]

I have three conditions within a VBScript. For some reason, all three seem to execute regardless of what is selected. (Ex: The e-mail is sent if the user enters no, or yes. I only want the e-mail sent if the value of what the user enters exceeds 50000.) Below is my code. What am I missing?

Dim MyVar
MyVar=MsgBox("You have entered xyz. Do you want to continue?",292,"Warning")
If MyVar=7 Then
window.location="returntoform.asp"
ElseIf MyVar=6 And <output>#XYZ#</output> > 50000 And <output>#XYZ#</cfoutput> < 10000 Then
window.opener.location.reload()
window.close

ElseIf MyVar=6 And <output>#XYZ#</output> > 50000 Then
<mail to="#recipient#" from="#sender#" subject="">
Message Text Goes Here
</mail>
End If

 

[tsuji]

Hello rosn459,

How do you arrive at all at this script? Where does it suppose to put?

regards - tsuji

 

[rosn459]

This script runs only if another condition exists.

Ex:

<cfif Condition Y>
<script language="VBScript">
Dim MyVar
MyVar=MsgBox("You have entered xyz. Do you want to continue?",292,"Warning")
If MyVar=7 Then
window.location="returntoform.asp"
ElseIf MyVar=6 And <output>#XYZ#</output> > 50000 And <output>#XYZ#</cfoutput> < 10000 Then
window.opener.location.reload()
window.close

ElseIf MyVar=6 And <output>#XYZ#</output> > 50000 Then
<mail to="#recipient#" from="#sender#" subject="">
Message Text Goes Here
</mail>
End If
</cfif>

This is just part of the other processing my page does.

 

[tsuji]

rosn459,

Suggest you post the question to coldfusion forum at tek-tips:

http://tek-tips.com/threadminder.cfm?pid=232

- tsuji