|
|
Home » ASP Home » Math Home » CBit Function
A D V E R T I S E M E N T
| Title |
CBit Function |
| Description |
CBit converts anything to an integer that is suitable for use with
MS SQL Server bit fields.
CBit ensures that a 1 or 0 will always be returned by the function,
regardless of the data type or value of the input expression.
CBit returns a 0 or 1 value based on the following criteria (see table).
Criteria is applied in the order stated below. Once any criteria
is recognized by CBit, no other criteria will be checked to determine
the value of the bit field. In other words, CBit goes with the first
criteria that matches and then stops testing the variant input and
returns the results of the first applicable test.
Variant Argument CBit Returns
------------------------------------------------------------------
if variant can be converted to sub-type 1
string and is considered alpha-numeric
and if the value is: "on", "true", "y",
or "t"
if variant can be converted to sub-type 0
string and is considered alpha-numeric
and if the value is: "off", "false", "n",
"f", or ""
if variant can be converted to a long 1
value and is greater than 0
if variant can be converted to a long 0
value and is less than 0
if variant is numeric but raises an error 0
when being converted to long
if variant is null, empty or an array 0
if variant is an object and is set to 1
anything other than Nothing
if variant is an object and is set to 0
Nothing
if data type or value of passed variant 0
argument is not given a value based on
the above criteria
If CBit cannot determine the bit status of a particular variant entry,
CBit always returns 0.
|
| Category |
ASP » Math |
| Hits |
381252 |
| Code |
Select and Copy the Code
|
|
|
Related Source Codes
A D V E R T I S E M E N T
|
Subscribe to SourceCodesWorld - Techies Talk |
New! Click here to Add your Code!
ASP Home | C Home | C++ Home | COBOL Home | Java Home | Pascal Home
Source Codes Home Page | |
|
Add to Favorites
Make Home Page
