Detailed explanation of Asp functions

Recommended: parse code that uses ADO to connect to various databases
A brief introduction to several ADO connection methods: ODBCDSN, ODBCDSN-Less, OLEDBProvider, and MSRemoteProvider. 1. ODBCDSN connection I.DSN oConn.OpenDSN=AdvWorks;_ UID=Admin;_ PWD=; Note: Since MDAC2.1, this method cannot be used, that is, only the DSN file name is placed in ConnectString

Cbyte(string) Convert to a value of byte type

Ccur(string) Convert to currency value

Cdate(string) Convert to a value of the day-old type

Cdbl(string) converts to double precision value

Cint(string) Convert to integer value

Clng(string) converts to long integer value

Csng(string) converts to single-precision value

Cstr(var) converts to string value

Str(var) value converted to string

Val(string) string to numeric value

*******************

*******************

Abs(nmb) returns the absolute value of the number

Atn(nmb) Returns the arc tangent of a number

Cos(nmb) Returns the Yuxuan value of an angle

Exp(nmb) Returns the power value of the natural index

Int(nmb) Returns the shaping (carry) part of the number

Fix(nmb) Returns the skeleton (discarded) part of the number

Formatpercent(expression) Returns percentage

Hex(nmb) Returns the hex number of data

Log(nmb) Returns natural logarithm

Oct(nmb) Returns the angular number of the number

Rnd returns a random number greater than 0 and less than 1

Sgn(nmb) determines the positive and negative signs of a number

Sin(nmb) Returns the Zhenghyun value of the angle

Sqr(nmb) returns the quadratic root of the number

Tan(nmb) Returns the tangent value of a number

Asc(string) Returns ASCII string

Chr(charcode) Return characters according to character code

Instr(string,searchstr) Returns the first character position of the searched string, string is a string, and searchstr is a string to be searched

InstrRev(string,searchstr) Same as above, just start searching from the right

Lcase(var) Change the string to lowercase

Left(string,nmb) Returns nmb strings starting from the left from string

Len(string) Returns the length of the string

Ltrim(string) Cut off the space on the left side of the string

Share: How to convert a string to an array with Split and get the array subscript value
Using interval string storage can reduce the writing of several database fields, and it is also convenient for the extension of data in the future. For example: In the forum, the user's personalities include multiple personalities, optimistic, mature and steady, childish and naughty, gentle and considerate, etc. The corresponding values ​​are 0, 1, 2, 3, and 4 respectively. When storing these data, use interval strings to store the data into a text.