March 2003
Intermediate to advanced
512 pages
14h 30m
English
Content preview from VBScript in a Nutshell, 2nd EditionBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Name
CLng Function
Syntax
CLng(expression)expressionUse: Required
Data Type: Numeric or String
The range of
expressionis -2,147,483,648 to 2,147,483,647; fractions are rounded.
Return Value
expression cast as a type of
Long.
Description
Converts expression to a type of
Long; any fractional element of
expression is rounded.
Rules at a Glance
expressionmust evaluate to a numeric value; otherwise, a type mismatch error is generated.If the value of
expressionis outside the range of the long data type, an overflow error is generated.When the fractional part is exactly 0.5, CLng always rounds it to the nearest even number. For example, 0.5 rounds to 0, and 1.5 rounds to 2.
Example
<HTML>
<HEAD>
<SCRIPT LANGUAGE="VBScript">
Option Explicit
Sub cmdAdd_OnClick( )
Dim lSum, sNum1, sNum2
sNum1 = Window.Document.frmAdd.txtText1.Value
sNum2 = Window.Document.frmAdd.txtText2.Value
If IsNumeric(sNum1) And IsNumeric(sNum2) Then
lSum = CLng(sNum1) + CLng(sNum2)
Alert "The sum is: " & lSum
Else
Alert "The values you enter in the text boxes must be numeric."
End If
End Sub
</SCRIPT>
</HEAD>
<BODY>
<FORM NAME="frmAdd">
<INPUT TYPE="text" NAME="txtText1"><BR>
<INPUT TYPE="text" NAME="txtText2"><BR>
<INPUT TYPE="button" NAME="cmdAdd" VALUE="Sum">
</FORM>
</BODY>
</HTML>Programming Tips and Gotchas
Use IsNumeric to test whether
expressionevaluates to a number.CLng differs from the Fix and Int functions, which truncate, rather than round, the fractional part of a number. Also, Fix and Int always return a value ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.