Using keyword "To" in select case giving error.The following code is got from www.microsrosoft.com itself. What is the wrong with this?.
<%
Dim Number1
Number1 = 7 ' Initialize variable.
Select Case Number1 ' Evaluate Number1.
Case 1 To 5 ' Number1 between 1 and 5, inclusive.
Response.Write( "Between 1 and 5" )
' The following is the only Case clause that evaluates to True.
Case 6, 7, 8 ' Number1 between 6 and 8.
Response.Write( "Between 6 and 8")
Case 9 To 10 ' Number1 is 9 or 10.
Response.Write( "Greater than 8")
Case Else ' Other values.
Response.Write( "Not between 1 and 10")
End Select
%>
I'm getting a syntax error with a Select Case statement:
Select Case CSng(rs.fields("Field1")) Case 0 Response.Write "Test1" Case Is < 0 <<< Syntax Error Response.Write "Test2" Case Is > 0 <<< Syntax Error Response.Write "Test3" End Select
As far as I can tell the syntax *is* correct. What am I missing?
Code like this ======================= Select case q Case "a" Dim arr(5) Case "b" Dim arr(2) end select ===================== returns an error saying variable arr redefined. Should it be like that or an I using Select incorrectly? Perhaps something similar to break needs to be used?
I am having a hard time understanding how to use a SELECT CASE in ASP. I have used it in VB but never in ASP scripting.
Scenerio:
I have 2 textboxes on a form that I have to allow entry to one or the other or Both at the same time. Now I tried to use an If ElseIf but it got too hard to track, so now I am using a SELECT CASE Statement.
TEXBOX1 named strEnglish TEXBOX2 named strFrench
My code: <% strEnglish=Request.Form("strEnglish") strFrench=Request.Form("strFrench")
Select Case
Then I have no idea how to go from here, because I have 2 input textboxes to follow. Code:
"Stock Value" Could be anything from 0 to a million or so, and might include a decimal (12345.67) . I can't find how to do this:
Select Case StockValue Case 0 To 30000 response.Write("Less than 30000") Case 30000 To 80000 response.Write("30000 to 80000") Case 80000 To 180000 response.Write("80000 to 180000") Case Else ' > 180000 response.Write("Greater than 180000") End Select
I would like to know if there is alterntiave to using Select Case?I have over 80 files that a user can select from a drop down list and 'read'. Rather than writing out 80+ lines with INC files, what is the other less code option?
Function SetAvgClass(val) If NOT isnull(val) Then Select Case cint(val) Case (val < 100) SetAvgClass = "belowexpected" Case (val > 100) SetAvgClass = "aboveexpected" Case 100 SetAvgClass = "expected" End Select Else SetAvgClass = "belowexpected" End If End Function
The only case that seems to be working correctly is thw case 100. am i using incorrect syntax for the > and < statements?
I'm doing a form validation function in ASP. I have a password and a passwordVerify field that must be the same value. In a Select Case, how can I compare the two values?
Case "password" If Len(sFieldValue) <4 or Len(sFieldValue) >20 Then bFieldIsOkay = False Case "passwordVerify" If sFieldValue <> (someway to compare password) Then bFieldIsOkay = False ...
i have a select case statement that checks for a couple of options e.g.
<%select case aParameters(0) case 0 %>
.. some code
<%case 2 %>
however i would like to test for a certain condition within the select cases statment. To see if a session variable exists before implementing some code:
I need to filter the records of a table where the records contain a searchin string with no case sensitive compare, and all with one only sql statement.
"SELECT * FROM Stuff WHERE LOWER(StuffName) LIKE '%" & lcase(StrSearch) & "%'"
but the error is in the function LOWER exist a similar function ?
I have written some code which should dynamically build a table which is then populated with questionas and possible answers. The format of the answers will vary ie they may be in the form of a radio button which will be rated from 1-5, checkbox or a selectbox.
The first problem I have is if I do not comment out <select></select> I get an error message saying the page can not be found. when I do take it out I get asp timeout. Code:
I am trying to run an SQL SELECT query, however, I am experiencing some problems with it.
It is coming up with the error; " Microsoft VBScript compilation error '800a0401'
Expected end of statement "
It is pointing to line 46 which is highlight in bold within my code below; is the error coming up because of the way I have formatted the query?
strSQL = "SELECT * FROM tbl_lunch WHERE (((tbl_lunch.Type)="general")) ORDER BY tbl_lunch.Type;" Thanks for any help you may be able to give me on this
I'm getting this useful error '80040e14' when trying to run a select statement in an ASP page. The connection to SQL Server 2000 is ok. The variables in the Select statement, 'area' or 'areaid' are passed through form the previous page ok.The code is below... Any ideas? Is it something obviously dense on my part?? Code:
ASP error number 13 - Type mismatch with SELECT...FOR UPDATE statement. I got ASP error number 13 when I use the SELECT...FOR UPDATE statement as below. However, if I use SELECT statement without FOR UPDATE, it is fine and no error. I also tried Set objRs = objConn.Execute("SELECT * FROM EMP UPDATE OF EMPNO"), but it still couldn't help.
I have this below. If there are 0 records, I want to do nothing, which it does. I need to perform a task if there is more than one. Case > 1 doesn't work. The most records I would have are 5.
I have one very simple question. I an just going blank on this. I writing a select case statment and want to know if I can have one of the case equile 2 values.
IE :
select case animal case "dog" or "cat" /// this only works if i remove the or half 'write form here case "mouse" 'do something end select
i am working on a login page in asp classic with microsoft access at the back, in current scenerio the username and passwords are not case sensitive and i have to make them C.Sensitive. can any one help me in this regard?
right now i am developing a web site. i want to know how to write the code to change the case for the text which we entered in the text box control? for example: if user enter his name as john elan, then we should automatically convert that text into proper case. i mean the name should become John Elan.
I'm trying to build a case statement that when a person logs in, the login page sends them to a redirect script based on the query string redirect.asp?id=1.
So far i can make myself a basic case statement, but i'm confused on how to get the window to pop up in a 400 x 600 window with no tool bars and such. any ideas?
Since my website uses a font for headlines that doesn't exist on default in windows I want to dynamicly create my headlines with images(of characters) For this to work nicely I have to detect if a character is upper or lower case.
Like the string
"Welcome"
Here I want to replace the "W" with a upperw.png and then replace "elcome" with lowere.png, lowerl.png, lowerc.png...and so on, you get the picture.
Is this possible in asp (vbscript) ? or java if It's possible to integrate into my vbscript page.