<CASE value1[ /]>
... statements if switchExpression = value1 ...
<CASE op value2[ /]>
... statements if switchExpression op value2 is true ...
... statements if no <CASE> matches ...
SWITCH statement provides a multi-option branch based on a
given switchExpression, which is a SQL
SELECT clause expression.
The value of switchExpression is compared against each
CASE value, in the order they appear in the script, until one
matches. The statements that follow the matching
executed, up to the closing
</CASE>, or next
<DEFAULT>, or closing
</SWITCH> tag. Only the first
CASE (if any) is executed. If none of the
CASEs match, then the statements after the
tag, if present, are executed.
An optional operator can be given in a
CASE to use in
comparing its value to the
SWITCH value, instead of the default
eq. This can be useful in checking a range of values; note
the order of
CASE statements here:
<CASE lte 32> Ice
<CASE lt 60> Cold water
<CASE lt 100> Warm water
<CASE lt 212> Hot water
The same operators that are translated in
(here) are supported in
in version 8 and later.
</CASE> is not needed; execution doesn't fall through
to the next
CASE as in
if present, must be last, since
CASEs are checked in order of
IF ELSE ELSEIF