tag:blogger.com,1999:blog-34747871229314590232024-02-19T22:05:09.340-08:00VB Script FAQ's & Interview Questions and answersSumedhhttp://www.blogger.com/profile/11533458660230230361noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3474787122931459023.post-1746059611781742582008-08-06T04:57:00.002-07:002008-12-22T20:23:13.697-08:00Adding VBScript Code to an HTML Page<blockquote><span style="font-family:Verdana, Arial, Helvetica;font-size:85%;">You can use the SCRIPT element to add VBScript code to an HTML page.</span></blockquote> <h5><span style="font-family:Verdana, Arial, Helvetica;font-size:85%;">The <script> Tag</span></h5> <blockquote> <span style="font-family:Verdana, Arial, Helvetica;font-size:85%;">VBScript code is written within paired <script> tags. For example, a procedure to test a delivery date might appear as follows: </span><blockquote><pre><span style="font-family:Verdana, Arial, Helvetica;font-size:85%;"><span style="font-family:Courier New;font-size:100%;">
<br /><script language="VBScript">
<br /><!--
<br /> Function CanDeliver(Dt)
<br /> CanDeliver = (CDate(Dt) - Now()) > 2
<br /> End Function
<br />-->
<br /></script>
<br /></span></span></pre> </blockquote> <span style="font-family:Verdana, Arial, Helvetica;font-size:85%;">Beginning and ending <script> tags surround the code. The LANGUAGE attribute indicates the scripting language. You must specify the language because browsers can use other scripting languages. Notice that the <span style="font-family:Courier New;font-size:85%;">CanDeliver</span> function is embedded in comment tags (<!-- and -->). This prevents browsers that don't understand the <script> tag from displaying the code.</span><p> <span style="font-family:Verdana, Arial, Helvetica;font-size:85%;">Since the example is a general function—it isn't tied to any particular form control—you can include it in the HEAD section of the page: </span></p><blockquote><pre><span style="font-family:Verdana, Arial, Helvetica;font-size:85%;"><span style="font-family:Courier New;font-size:100%;">
<br /><html>
<br /><head>
<br /><title>Place Your Order</title>
<br /><script language="VBScript">
<br /><!--
<br /> Function CanDeliver(Dt)
<br /> CanDeliver = (CDate(Dt) - Now()) > 2
<br /> End Function
<br />-->
<br /></script>
<br /></head>
<br /><body>
<br />...
<br /></span></span></pre> </blockquote> <span style="font-family:Verdana, Arial, Helvetica;font-size:85%;">You can use SCRIPT blocks anywhere in an HTML page. You can put them in both the BODY and HEAD sections. However, you'll probably want to put all general-purpose scripting code in the HEAD section in order to keep all the code together. Keeping your code in the HEAD section ensures that all code is read and decoded before it's needed by any calls from within the BODY section.</span><p> <span style="font-family:Verdana, Arial, Helvetica;font-size:85%;">One notable exception to this rule is that you may want to provide inline scripting code within forms to respond to the events of objects in your form. For example, you can embed scripting code to respond to a button click in a form: </span></p><blockquote><pre><span style="font-family:Verdana, Arial, Helvetica;font-size:85%;"><span style="font-family:Courier New;font-size:100%;">
<br /><html>
<br /><head>
<br /><title>Test Button Events</title>
<br /></head>
<br /><body>
<br /><form name="Form1">
<br /> <input type="Button" name="Button1" value="Click">
<br /> <script for="Button1" event="onClick" language="VBScript">
<br /> MsgBox "Button Pressed!"
<br /> </script>
<br /></form>
<br /></body>
<br /></html>
<br /></span></span></pre> </blockquote> <span style="font-family:Verdana, Arial, Helvetica;font-size:85%;"> Most of your code will appear in either <b>Sub</b> or <b>Function</b> procedures and will be called only when code you have written causes it to execute. However, you can write VBScript code outside procedures, but still within a SCRIPT block. This code is executed only once, when the HTML page loads. This allows you to initialize data or dynamically change the look of your Web page when it loads. </span></blockquote>Sumedhhttp://www.blogger.com/profile/11533458660230230361noreply@blogger.com2tag:blogger.com,1999:blog-3474787122931459023.post-86586643979634489772008-08-06T04:57:00.001-07:002008-12-22T20:23:13.697-08:00What Is VBScript?<span style="font-family:Verdana, Arial, Helvetica;font-size:85%;"><a name="overview"></a> </span><blockquote> <span style="font-family:Verdana, Arial, Helvetica;font-size:85%;">Microsoft Visual Basic Scripting Edition, the newest member of the Visual Basic family of programming languages, brings active scripting to a wide variety of environments, including Web client scripting in Microsoft Internet Explorer and Web server scripting in Microsoft Internet Information Server. </span></blockquote> <h5><span style="font-family:Verdana, Arial, Helvetica;font-size:85%;">Easy to Use and Learn</span></h5> <blockquote> <span style="font-family:Verdana, Arial, Helvetica;font-size:85%;">If you already know Visual Basic or Visual Basic for Applications, VBScript will be very familiar. Even if you don't know Visual Basic, once you learn VBScript, you're on your way to programming with the whole family of Visual Basic languages. Although you can learn about VBScript in just these few Web pages, they don't teach you how to program. To get started programming, take a look at <i>Step by Step</i> books available from Microsoft Press. </span></blockquote> <h5><span style="font-family:Verdana, Arial, Helvetica;font-size:85%;">ActiveX Scripting</span></h5> <blockquote> <span style="font-family:Verdana, Arial, Helvetica;font-size:85%;">VBScript talks to host applications using ActiveX™ Scripting. With ActiveX Scripting, browsers and other host applications don't require special integration code for each scripting component. ActiveX Scripting enables a host to compile scripts, obtain and call entry points, and manage the namespace available to the developer. With ActiveX Scripting, language vendors can create standard language run times for scripting. Microsoft will provide run-time support for VBScript. Microsoft is working with various Internet groups to define the ActiveX Scripting standard so that scripting engines can be interchangeable. ActiveX Scripting is used in Microsoft® Internet Explorer and in Microsoft® Internet Information Server. </span></blockquote> <h5><span style="font-family:Verdana, Arial, Helvetica;font-size:85%;">VBScript in Other Applications and Browsers</span></h5> <blockquote> <span style="font-family:Verdana, Arial, Helvetica;font-size:85%;">As a developer, you can license VBScript source implementation at no charge for use in your products. Microsoft provides binary implementations of VBScript for the 32-bit Windows® API, the 16-bit Windows API, and the Macintosh®. VBScript is integrated with World Wide Web browsers. VBScript and ActiveX Scripting can also be used as a general scripting language in other applications. </span></blockquote>Sumedhhttp://www.blogger.com/profile/11533458660230230361noreply@blogger.com0tag:blogger.com,1999:blog-3474787122931459023.post-22663029117844130042008-08-06T04:51:00.000-07:002008-12-22T20:23:13.698-08:00 VBScript Tutorial<meta equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///D:%5CDOCUME%7E1%5Cshesu04%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C06%5Cclip_filelist.xml"><title>Oracle Certification Program Candidate Guide</title><o:smarttagtype namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place"></o:smarttagtype><!--[if gte mso 9]><xml> <o:documentproperties> <o:author>misebast</o:Author> <o:version>11.9999</o:Version> </o:DocumentProperties> </xml><![endif]--><!--[if gte mso 9]><xml> <w:worddocument> <w:view>Normal</w:View> <w:zoom>0</w:Zoom> <w:punctuationkerning/> <w:validateagainstschemas/> <w:saveifxmlinvalid>false</w:SaveIfXMLInvalid> <w:ignoremixedcontent>false</w:IgnoreMixedContent> <w:alwaysshowplaceholdertext>false</w:AlwaysShowPlaceholderText> <w:compatibility> <w:breakwrappedtables/> <w:snaptogridincell/> <w:wraptextwithpunct/> <w:useasianbreakrules/> <w:dontgrowautofit/> <w:usefelayout/> </w:Compatibility> <w:browserlevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:latentstyles deflockedstate="false" latentstylecount="156"> </w:LatentStyles> </xml><![endif]--><!--[if !mso]><object classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id="ieooui"></object> <style> st1\:*{behavior:url(#ieooui) } </style> <![endif]--><style> <!-- /* Font Definitions */ @font-face {font-family:SimSun; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-alt:ËÎÌå; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} @font-face {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-alt:Verdana; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:536871559 0 0 0 415 0;} @font-face {font-family:"\@SimSun"; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-alt:"\@Arial Unicode MS"; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:SimSun;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <p class="MsoNormal" style=""><b><span style="font-size: 14pt; font-family: Verdana; color: black;">VBScript Variables<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><b><span style="font-size: 14pt; font-family: Verdana; color: black;"><o:p> </o:p></span></b></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">What is a Variable?<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">A variable is a "container" for information you want to store. A variable's value can change during the<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">script. You can refer to a variable by name to see its value or to change its value. In VBScript, all variables<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">are of type <i>variant</i>, that can store different types of data.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;"><o:p> </o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">Rules for Variable Names:<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Must begin with a letter<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Cannot contain a period (.)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Cannot exceed 255 characters<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;"><o:p> </o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">Declaring Variables<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">You can declare variables with the Dim, Public or the Private statement. Like this:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">dim name<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">name=some value<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Now you have created a variable. The name of the variable is "name".<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">You can also declare variables by using its name in your script. Like this:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">name=some value<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Now you have also created a variable. The name of the variable is "name".<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">However, the last method is not a good practice, because you can misspell the variable name later in your<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">script, and that can cause strange results when your script is running. This is because when you misspell<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">for example the "name" variable to "nime" the script will automatically create a new variable called<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">"nime". To prevent your script from doing this you can use the Option Explicit statement. When you use<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">this statement you will have to declare all your variables with the dim, public or private statement. Put the<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Option Explicit statement on the top of your script. Like this:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">option explicit<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">dim name<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">name=some value<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;"><o:p> </o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">Assigning Values to Variables<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">You assign a value to a variable like this:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">name="Hege"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">i=200<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">The variable name is on the left side of the expression and the value you want to assign to the variable is on the right. Now the variable "name" has the value "Hege".<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;"><o:p> </o:p></span></b></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">Lifetime of Variables<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">How long a variable exists is its lifetime.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">When you declare a variable within a procedure, the variable can only be accessed within that procedure.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">When the procedure exits, the variable is destroyed. These variables are called local variables. You can have local variables with the same name in different procedures, because each is recognized only by the procedure in which it is declared.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">If you declare a variable outside a procedure, all the procedures on your page can access it. The lifetime of these variables starts when they are declared, and ends when the page is closed.<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;"><o:p> </o:p></span></b></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">Array Variables<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Sometimes you want to assign more than one value to a single variable. Then you can create a variable that can contain a series of values. This is called an array variable. The declaration of an array variable uses parentheses ( ) following the variable name. In the following example, an array containing 3 elements is declared:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">dim names(2)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: red;">The number shown in the parentheses is 2. We start at zero so this array contains 3 elements</span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">. This is a fixed-size array. You assign data to each of the elements of the array like this:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">names(0)="Tove"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">names(1)="Jani"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">names(2)="Stale"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Similarly, the data can be retrieved from any element using the index of the particular array element you want. Like this:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">mother=names(0)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">You can have up to 60 dimensions in an array. Multiple dimensions are declared by separating the numbers in the parentheses with commas. Here we have a two-dimensional array consisting of 5 rows and 7 columns:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">dim table(4, 6)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;"><o:p> </o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">An example of how to use arrays<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Note that the following VBScript runs on the client side, which is different from ASP.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;"><html><o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;"><body><o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;"><script type="text/vbscript"><o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">dim famname(5)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">famname(0)="Jan Egil"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">famname(1)="Tove"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">famname(2)="Hege"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">famname(3)="Stale"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">famname(4)="Kai Jim"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">famname(5)=99+2<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">for i=0 to 5<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">document.write(famname(i) & "<br />")<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">next<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">document.write("<br /><br />")<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">dim v(1,1)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">v(0,0) = "Daniel"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">v(0,1) = "Ben"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">v(1,0) = "Roger"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">v(1,1) = 25<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">document.write(v(0,0) & "<br />")<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">document.write(v(0,1) & "<br />")<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">document.write(v(1,0) & "<br />")<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">document.write((v(1,1)+1) & "<br />")<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR"></script><o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;"></body><o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;"></html><o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;"><o:p> </o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 14pt; font-family: Verdana; color: black;">VBScript Functions<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">VBScript Procedures<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">In VBScript the “function”s are actually called “procedure”s.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">We have two kinds of procedures: The Sub procedure and the Function procedure.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">A Sub procedure:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">is a series of statements, enclosed by the Sub and End Sub statements<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">can perform actions, but <b>does not return </b>a value<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">can take arguments that are passed to it by a calling procedure<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">without arguments, must include an empty set of parentheses ()<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Sub mysub()<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">some statements<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">End Sub<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">or<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Sub mysub(argument1,argument2)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">some statements<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">End Sub<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">A Function procedure:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">is a series of statements, enclosed by the Function and End Function statements<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">can perform actions and <b>can return </b>a value<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">can take arguments that are passed to it by a calling procedure<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">without arguments, must include an empty set of parentheses ()<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">returns a value by assigning a value to its name<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Function myfunction()<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">some statements<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">myfunction=some value<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">End Function<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">or<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Function myfunction(argument1,argument2)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">some statements<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">myfunction=some value<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">End Function<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">Call a Sub or Function Procedure<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">When you call a Function in your code, you do like this:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">name = findname()<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Here you call a Function called "findname", the Function returns a value that will be stored in the variable<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">"name".<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Or, you can do like this:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">msgbox "Your name is " & findname()<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Here you also call a Function called "findname", the Function returns a value that will be displayed in the<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">message box.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">When you call a Sub procedure you can use the Call statement, like this:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Call MyProc(argument)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Or, you can omit the Call statement, like this:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">MyProc argument<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;"><o:p> </o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 14pt; font-family: Verdana; color: black;">VBScript Conditional Statements<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">Conditional Statements<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Very often when you write code, you want to perform different actions for different decisions. You can use<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">conditional statements in your code to do this.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">In VBScript we have three conditional statements:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">if...then...else statement </span></b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">- use this statement if you want to select one of two sets of lines to<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">execute<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">if...then...elseif statement </span></b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">- use this statement if you want to select one of many sets of lines to<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">execute<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">select case statement </span></b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">- use this statement if you want to select one of many sets of lines to<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">execute<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">If....Then.....Else<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">You should use the If...Then...Else statement if you want to<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">execute some code if a condition is true<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">select one of two blocks of code to execute<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">If you want to execute only <b>one </b>statement when a condition is true, you can write the code on one line:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">if i=10 Then msgbox "Hello"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">There is no ..else.. in this syntax. You just tell the code to perform <b>one action </b>if the condition is true (in<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">this case if i=10).<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">If you want to execute <b>more than one </b>statement when a condition is true, you must put each statement<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">on separate lines and end the statement with the keyword "End If":<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">if i=10 Then<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">msgbox "Hello"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">i = i+1<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">end If<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">There is no ..else.. in this syntax either. You just tell the code to perform <b>multiple actions </b>if the condition<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">is true.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">If you want to execute a statement if a condition is true and execute another statement if the condition is<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">not true, you must add the "Else" keyword:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">if i=10 then<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">msgbox "Hello"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">else<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">msgbox "Goodbye"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">end If<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">The first block of code will be executed if the condition is true, and the other block will be executed<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">otherwise (if i is not equal to 10).<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">If....Then.....Elseif<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">You can use the if...then...elseif statement if you want to select one of many blocks of code to execute:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">if payment="Cash" then<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">msgbox "You are going to pay cash!"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">elseif payment="Visa" then<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">msgbox "You are going to pay with visa."<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">elseif payment="AmEx" then<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">msgbox "You are going to pay with American Express."<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">else<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">msgbox "Unknown method of payment."<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">end If<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">Select Case<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">You can also use the SELECT statement if you want to select one of many blocks of code to execute:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">select case payment<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">case "Cash"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">msgbox "You are going to pay cash"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">case "Visa"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">msgbox "You are going to pay with visa"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">case "AmEx"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">msgbox "You are going to pay with American Express"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">case Else<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">msgbox "Unknown method of payment"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">end select<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">This is how it works: First we have a single expression (most often a variable), that is evaluated once. The<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">value of the expression is then compared with the values for each Case in the structure. If there is a match,<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">the block of code associated with that Case is executed.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;"><o:p> </o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 14pt; font-family: Verdana; color: black;">VBScript Looping Statements<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">Looping Statements<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Very often when you write code, you want to allow the same block of code to run a number of times. You<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">can use looping statements in your code to do this.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">In VBScript we have four looping statements:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">For...Next statement </span></b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">- runs statements a specified number of times.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">For Each...Next statement </span></b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">- runs statements for each item in a collection or each element of an<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">array<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Do...Loop statement </span></b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">- loops while or until a condition is true<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">While...Wend statement </span></b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">- Do not use it - use the Do...<st1:place st="on">Loop</st1:place> statement instead<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">For...Next<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">You can use a <b>For...Next </b>statement to run a block of code, when you know how many repetitions you<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">want.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">You can use a counter variable that increases or decreases with each repetition of the loop, like this:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">For i=1 to 10<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">some code<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Next<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">The <b>For </b>statement specifies the counter variable (<b>i</b>) and its start and end values. The <b>Next </b>statement<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">increases the counter variable (<b>i</b>) by one.<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;">Step Keyword<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Using the <b>Step </b>keyword, you can increase or decrease the counter variable by the value you specify.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">In the example below, the counter variable (<b>i</b>) is increased by two each time the loop repeats.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">For i=2 To 10 Step 2<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">some code<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Next<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">To decrease the counter variable, you must use a negative <b>Step </b>value. You must specify an end value that<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">is less than the start value.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">In the example below, the counter variable (<b>i</b>) is decreased by two each time the loop repeats.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">For i=10 To 2 Step -2<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">some code<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Next<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;">Exit a For...Next<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">You can exit a For...Next statement with the Exit For keyword.<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">For Each...Next<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">A <b>For Each...Next </b>loop repeats a block of code for each item in a collection, or for each element of an<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">array.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">The <b>For Each...Next </b>statement looks almost identical to the For...Next statement. The difference is that<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">you do not have to specify the number of items you want to loop through.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">dim names(2)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">names(0)="Tove"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">names(1)="Jani"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">names(2)="Hege"<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">For Each x in names<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">document.write(x & "<br />")<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Next<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">Do...Loop<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">You can use Do...<st1:place st="on">Loop</st1:place> statements to run a block of code when you do not know how many repetitions you<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">want. The block of code is repeated while a condition is true or until a condition becomes true.<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;">Repeating Code While a Condition is True<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">You use the While keyword to check a condition in a Do...<st1:place st="on">Loop</st1:place> statement.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Do While i>10<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">some code<o:p></o:p></span></p> <p class="MsoNormal" style=""><st1:place st="on"><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Loop</span></st1:place><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;"><o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">If <b>i </b>equals 9, the code inside the loop above will never be executed.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Do<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">some code<o:p></o:p></span></p> <p class="MsoNormal" style=""><st1:place st="on"><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Loop</span></st1:place><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;"> While i>10<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">The code inside this loop will be executed at least one time, even if <b>i </b>is less than 10.<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;">Repeating Code Until a Condition Becomes True<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">You use the Until keyword to check a condition in a Do...<st1:place st="on">Loop</st1:place> statement.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Do Until i=10<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">some code<o:p></o:p></span></p> <p class="MsoNormal" style=""><st1:place st="on"><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Loop</span></st1:place><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;"><o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">If <b>i </b>equals 10, the code inside the loop will never be executed.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Do<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">some code<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Loop Until i=10<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">The code inside this loop will be executed at least one time, even if <b>i </b>is equal to 10.<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;">Exit a Do...<st1:place st="on">Loop</st1:place><o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">You can exit a Do...<st1:place st="on">Loop</st1:place> statement with the Exit Do keyword.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Do Until i=10<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">i=i-1<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">If i<10></o:p></span></p> <p class="MsoNormal" style=""><st1:place st="on"><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Loop</span></st1:place><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;"><o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">The code inside this loop will be executed as long as <b>i </b>is different from 10, and as long as <b>i </b>is greater than<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">10.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;"><o:p> </o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 14pt; font-family: Verdana; color: black;">VBScript Keywords<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">VBScript Keywords<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Keyword Description<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Empty Used to indicate an uninitialized variable value. A variable value is<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">uninitialized when it is first created and no value is assigned to it, or<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">when a variable value is explicitly set to empty.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">dim x 'the variable x is uninitialized!<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">x="ff" 'the variable x is NOT uninitialized anymore<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">x=empty 'the variable x is uninitialized!<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Note: </span></b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">This is not the same as Null!!<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">False Has a value equal to 0<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Nothing Used to disassociate an object variable from an object to release system<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">resources.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Example: set myObject=Nothing<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Null Used to indicate that a variable contains no valid data.<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Note: </span></b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">This is not the same as Empty!!<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">True Has a value equal to -1<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;"><o:p> </o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 14pt; font-family: Verdana; color: black;">VBScript Built-in Functions (partial)<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><b><span style="font-family: Verdana; color: black;">Some useful VBScript built-in functions:<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">Conversion Functions<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Function Description<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Asc </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Converts the first letter in a string to ANSI code<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">CBool </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Converts an expression to a variant of subtype Boolean<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">CByte </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Converts an expression to a variant of subtype Byte<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">CCur </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Converts an expression to a variant of subtype Currency<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">CDate </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Converts a valid date and time expression to the variant of subtype Date<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">CDbl </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Converts an expression to a variant of subtype Double<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Chr </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Converts the specified ANSI code to a character<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">CInt </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Converts an expression to a variant of subtype Integer<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">CLng </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Converts an expression to a variant of subtype Long<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">CSng </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Converts an expression to a variant of subtype Single<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">CStr </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Converts an expression to a variant of subtype String<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Hex </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the hexadecimal value of a specified number<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Oct </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the octal value of a specified number<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">Example of CInt function:<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">The CInt function converts an expression to a variant of subtype Integer.<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Note: </span></b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">The value must be a number between -32768 and 32767.<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;">Syntax<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">CInt(expression)<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Parameter Description<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">expression Required. Any valid expression<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;">Example 1<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">dim a<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">a=134.345<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">document.write(CInt(a))<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Output:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">134<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;">Example 2<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">dim a<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">a=-30000.24<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">document.write(CInt(a))<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Output:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">-30000<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">Math Functions<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Function Description<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Abs </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the absolute value of a specified number<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Atn </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the arctangent of a specified number<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Cos </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the cosine of a specified number (angle)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Exp </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns <i>e </i>raised to a power<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Hex </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the hexadecimal value of a specified number<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Int </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the integer part of a specified number<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Fix </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the integer part of a specified number<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Log </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the natural logarithm of a specified number<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Oct </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the octal value of a specified number<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Rnd </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns a random number less than 1 but greater or equal to 0<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Sgn </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns an integer that indicates the sign of a specified number<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Sin </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the sine of a specified number (angle)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Sqr </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the square root of a specified number<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Tan </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the tangent of a specified number (angle)<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">Example of Rnd function:<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">The Rnd function returns a random number. The number is always less than 1 but greater or equal to 0.<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;">Syntax<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Rnd[(number)]<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Parameter Description<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">number Optional. A valid numeric expression<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">If number is:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;"><0></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">>0 - Rnd returns the next random number in the sequence<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">=0 - Rnd returns the most recently generated number<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Not supplied - Rnd returns the next random number in the sequence<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;">Example 1<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">document.write(Rnd)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Output:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">0.7055475<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;">Example 2<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">'If you refresh the page,<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">'using the code in example 1,<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">'the SAME random number will show over and over.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">'Use the Randomize statement generate a new random number<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">'each time the page is reloaded!<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Randomize<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">document.write(Rnd)<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Output:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">0.4758112<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;">Example 3<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">'Here is how to produce random integers in a<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">'given range:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">dim max,min<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">max=100<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">min=1<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">document.write(Int((max-min+1)*Rnd+min))<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Output:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">71<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">String Functions<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Function Description<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">InStr </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the position of the first occurrence of one string within another.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">The search begins at the first character of the string<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">InStrRev </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the position of the first occurrence of one string within another.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">The search begins at the last character of the string<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">LCase </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Converts a specified string to lowercase<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Left </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns a specified number of characters from the left side of a string<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Len </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns the number of characters in a string<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">LTrim </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Removes spaces on the left side of a string<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">RTrim </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Removes spaces on the right side of a string<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Trim </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Removes spaces on both the left and the right side of a string<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Mid </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns a specified number of characters from a string<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Replace </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Replaces a specified part of a string with another string a specified<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">number of times<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Right </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns a specified number of characters from the right side of a string<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">Space </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns a string that consists of a specified number of spaces<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">StrComp </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Compares two strings and returns a value that represents the result of<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">the comparison<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">String </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Returns a string that contains a repeating character of a specified length<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">StrReverse </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Reverses a string<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: rgb(145, 11, 9);">UCase </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Converts a specified string to uppercase<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">Example of StrComp function:<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">The StrComp function compares two strings and returns a value that represents the result of the<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">comparison.<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">The StrComp function can return the following values:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">If string1 <></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">If string1 = string2 - StrComp returns 0<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">If string1 > string2 - StrComp returns 1<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">If string1 or string2 is Null - StrComp returns Null<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;">Syntax<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">StrComp(string1,string2[,compare])<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Parameter Description<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">string1 Required. A string expression<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">string2 Required. A string expression<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">compare Optional. Specifies the string comparison to use. Default is 0<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 8.5pt; font-family: Verdana; color: black;">Can have one of the following values:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">0 = vbBinaryCompare - Perform a binary comparison<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: SimSun; color: black;" lang="ZH-CN">·</span><span style="font-size: 10pt; font-family: Symbol; color: black;"> </span><span style="font-size: 8.5pt; font-family: Verdana; color: black;">1 = vbTextCompare - Perform a textual comparison<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;" lang="FR">Example 1<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;" lang="FR">document.write(StrComp("VBScript","VBScript"))<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Output:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">0<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;">Example 2<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">document.write(StrComp("VBScript","vbscript"))<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Output:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">-1<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 9.5pt; font-family: Verdana; color: black;">Example 3<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">document.write(StrComp("VBScript","vbscript",1))<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">Output:<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 9.5pt; font-family: "Courier New"; color: black;">0<o:p></o:p></span></p> <p class="MsoNormal" style=""><b><span style="font-size: 10pt; font-family: Verdana; color: black;">More Function References:<o:p></o:p></span></b></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: Verdana; color: black;">For more function references, you can check the reference materials from<o:p></o:p></span></p> <p class="MsoNormal"><b><span style="font-size: 10pt; font-family: Verdana; color: purple;">http://www.w3schools.com/vbscript/vbscript_ref_functions.asp</span></b><span style="font-size: 10pt; font-family: Verdana; color: black;">.</span></p> Sumedhhttp://www.blogger.com/profile/11533458660230230361noreply@blogger.com0