select case problem

noamsmadja · #1 (**permalink**) 01-15-08, 04:24

case 1 to 10
do this

isnt it supposed to work?

gvee · #2 (**permalink**) 01-15-08, 05:25

Have you tried

Code:

Select Case someVariable
  Case 1 - 10
    Response.Write("1-10")

Or...
Select Case True
  Case (someVariable >= 1 AND someVariable <= 10)
    Response.Write("1-10")

The "TO" keyword is not supported in VBScript.

noamsmadja · #3 (**permalink**) 01-15-08, 07:28

ok,

i'll try the first one later. unless it works i'll use an If, i think case True is not tidy.

thx!! (again)

gvee · #4 (**permalink**) 01-15-08, 07:46

I'm not sure the first suggestion will work, but I am sure that the second will.

But you are right, with the second one you might as well use an If!

The point in a case statement is that the case (i.e. someValue) is only evaluated the once and then compared to various conditions until true.
An If statement evaluates the case for each executed line.

So in theory, case statements are more efficient; the exception being Select True.

noamsmadja · #5 (**permalink**) 01-15-08, 07:58

took me some time to remember adding End Ifs and Thens. am used to IF{}

i keep seeing this _ line break for coding. ppl use it to break long lines in their code.... for some reason it isnt working for me...

thats how i was trying to do it:

record.source="SELECT * FROM cell1" _
"cell2" _
"cell3" _
"cell4" _
"WHERE etc etc etc"

wt am i doing wrong? else than using SELECT *

gvee · #6 (**permalink**) 01-15-08, 08:42

You're using SELECT * (still!)
Remember our string concatenator?
You've split multiple strings over multiple lines

Marvels · #7 (**permalink**) 02-13-08, 05:07

To : is supoted but not in the way written here (i.e. For i = 1 to 10)

Does that SELECT CASE TRUE work ??? hmmm ok
would rather do :

Code:

dim blValue as boolean=TRUE
blValue=myTxt.Visible
SELECT CASE blValue
CASE TRUE
CASE FALSE

(as im writing it down seem logical that it would work.)
but isn't the case allway true then ???
True = true, why would u then have a select case

SQL : Be sure to put a space befor you start a new line i.e.

Code:

 
slSql= "SELECT ID, Name,WHATEVER"  & _
            " , Age ,Sex" & _
            " , Street, No AS [House number]  ,Postalcode"& _
            " FROM MyTable" & _
            " INNER JOIN OTHER TABLE ON MyTable.ID=OTHER.ID" & _
            " WHERE ID < " & MyInputParameter & _
            " ORDER BY NAME"
EDIT : ok,  Georgev was right as usual  ;-)  (was missing an quote and linecontinuation  )

This way you never have to do a "difficult" left/right to see if there is a space at the end
Break the line on each Function