Select Case Variable
I have an array made using split to create act_count variable below I am then using a select case to write names from array.. Code:
View RepliesI have an array made using split to create act_count variable below I am then using a select case to write names from array.. Code:
View RepliesCode 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 was trying to colorize my Events from my eventtable.
Past = Grey
Today = Yellow
Future = Blue
Now my question:
How can i specify a statement not when its EQUAL to a number but greater or less than zero for example
I tried this thing and some else but it didn't really work...
color="#6464ce"
Case Else
color="black"
End Select
Probably its a simple solution and don't see the forest because there are so many trees
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 also tried Case > 0 And <30000 .... and so on
how to write this select script please?
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?
View Replies View RelatedUsing 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
%>
Code:
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 two numbers that i need to combine and then depending on the result i need to write different instructions to the browser. Code:
View Replies View RelatedI'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?
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 m trying to use select statement in order to select a distinct word like 'c', but in the database i only want to select c when it occurs on its own not when it appears in another word.
eg i need to select the alphabet 'c' in 'the cat category is c' but not the 'c' in 'cat' or 'category'. I have used the code below but this seem to count all 'c'
select set rsTypes2 = con.execute("SELECT COUNT(two) AS total FROM march where two like '%c%'")
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 am working on a site with MS Access and ASP that needs to have data selected from a listbox, populate several span fields. I can do it with JavaScript but the array data is hard coded, I want the data brought in dynamically from an Access database. Here is my JavaScript code:
View Replies View Relatedfirst I typed this:
p=Request.QueryString("num")
then I typed this:
sqlstring = "select column1 from table where column2 like '%p%'"
it find nothing. anyway, if I replace the "p" in the second line to what it was equal, it does find what I need.
moreover, when I print "p" I get the right string.
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.
mycount=rs.recordcount
Select Case mycount
Case 0
Response.write ("No Records")
Case 1
i have this on my signup page
Set rs = Conn.Execute("SELECT * from rounds")
DO WHILE NOT rs.EOF
IF request.form("username") = rs.fields.item("username").value THEN
response.redirect("register2.asp")
END IF
rs.MoveNext
LOOP
the problem is.. some who signed up as say Jeff can still sign up as jeff
or jeFF how can i fix this??
My problem is like this:
http://www.4guysfromrolla.com/webte...q022400-1.shtml
But I use ASP + Access (Jet SQL 4)
i have a name in the variable like this
std="bill stevens"
I want to display it like this
Bill Stevens
i want to make the first letter as capital
here is my code
std=Request.form("stname")
stdnamedisplay=Ucase(Mid(std,1,1)) & Mid(std,2)
its not working it still displays as bill stevens
I am getting a syntax error on
Select Case Now
Case > "2/2/2004 12:30:00 AM"
response.redirect "votingover.asp"
case else
m=0
End Select
Is replace case sensitive?
View Replies View RelatedI 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?
View Replies View Relatedright 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.
View Replies View RelatedI'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?
Below is my sql search code in my asp page. But my search seems to be case sensitive. How can i modify it to make it not case sensitive?
<%
sqlString = "SELECT product_image, product_name, product_description, product_price " &_
"FROM Products " &_
"WHERE product_status = 1 " &_
"AND ( product_name LIKE '%" & searchFor & "%' " &_
"OR product_description LIKE '%" & searchFor & "%') " &_
"ORDER BY product_name "
SET RS = Conn.Execute( sqlString )
IF NOT RS.EOF AND searchFor <> "" THEN
%>
I have tried searching various sites including this one and I cant find a straight forward answer.
Code:
strSQL = "SELECT user.username FROM user WHERE username = '" & myUsername & "' AND password = '" & myPassword & "';"
How do I check for case sensitivity?
How to make first letter of word in upper case?
i.e. hello should return Hello
Is there any inbuilt function?
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.
I'm trying to put together that standard case include method of building websites in ASP. The variable for the ASP switch comes from a query string.
<%
Select Case Request.QueryString("page")
case "home"
<!--#include file = "content/home.inc"-->
end select
%>
It isn't working, though... do you guys spot a syntax error or something??
I have a access database that has data where the people entered their name all in upper case or in various forms of upper and lower case. Can a change all the data so it is in a proper format. Example: This is Joe Smoe. Or change it to be all lower case for email addresses?
View Replies View Relatedhow can I make the password entered into a database case sensitive when a user tries to sign in?
View Replies View Related