dbWriter Home
IP to Country Look up
Site Map

IP to Country DB

Free Databases:

ASP Code

ASP Links

VB Script functions:
Array
Case/Select
In String (inStr)
Replace

HTML code:
SELECT Color
SELECT Countries
SELECT Language
SELECT State/Province

SQL:

SQL Functions:
Delete leading Char
Get Browser
Long number from IP

Stored Procedures:

SQL Tricks:
Delete ALL duplicates
Delete dup records

MISC
IP Address Owner
MS SQL Server

Mortgage Calcs:
how much is my payment
Loan Amortization
Loan Calculator
Mortgage Calculator
Motrgage Pay Off

dbWriter License

Link to US

Links

Contact US
 

VBScript: CASE Function.. ASP code

CASE function with an integer:

This CASE script tested on dbWriter:
Today is Saturday

<%
DIM idate
DIM strDate
idate=WeekDay(Date)

Select case idate
case 1 strDate="Today is Sunday"
case 2 strDate="Today is Monday"
case 3 strDate="Today is Tuesday"
case 4 strDate="Today is Wednesday"
case 5 strDate="Today is Thursday"
case 6 strDate="Today is Friday"
case 7 strDate="Today is Saturday"

case else strDate="Date ERROR!!"
end select

Response.write strDate
%>
 
 

CASE function with a string:

Click to test on dbWriter:
Case Test 1   Case Test 2    Case Test 3

Results of test = Test ERROR!!

<%
DIM mode
DIM strCASE
mode = trim(request.queryString("mod"))

Select Case mode
case "CaseTest1" strCASE="Test 1 Success"
case "CaseTest2" strCASE="Test 2 Success"
case "CaseTest3" strCASE="Test 3 Success"
case else strCASE="Test ERROR!!"
end select

Response.write strCASE
%>
 

Partners/Links © 2005 - 2008 dbWriter.com All Rights Reserved
This site is protected by the dbWriter IPtoCountry MS/SQL database!!
Site map | Link to US
Contact Us

Sign up for PayPal and start accepting credit card payments instantly.