1. Function array () function: Create an array variable format: array (list) parameter: List is a numerical column in array variables, with comma intervals: <% i = array ("1", "2" , "3")%> Result: I is given to array 2. Function CINT () function: Convert an expression / other type of variable into an integer type (int) format: cint (expression) Parameters: Expression is any effective Expression / Other types of variable examples: <% f = "234" Response.write CINT (f) 2%> Result: 236 Function CINT () Convert Character "234" into an integer 234. If the expression is empty When it is invalid, the return value is 0; 3. Function: CreatObject () function: Create and return an ActiveX object. Format: CreatObject (OBNAME) parameter BNAME is an object's name example: <% set con = Server.createObject (" AdoDb.connection ")%> Results: 4. Function CSTR () function: Convert a expression / other type of variable into a string format: cstr (expression) parameter: expression is any valid expression / other Type Variable Example: <% S = 3 2 Response.write "The Res:" & CSTR (S)%> Result: Function CSTR () converts integer 5 into characters "5". 5. Function Date () Function: Returns the date format of the current system (SERVER): Date () parameter: no example <% DATE ()%> Result: 05/10/00 6. Function dateAdd () function: calculate a specified time and format : Dateadd (TimeInterval, Number, Date) Parameters: TimeInterval is the time unit (month, day ..); Number is the time interval value, Date is the time point. Example: <% currentdate = # 8/4/99 # newdate = dateadd ("M", 3, CurrentDate) response.write newdate%> <% currentdate = # 12: 34:45 PM # newdate = dateadd ("h", 3, currentdate) response.write newdate%> Results: 11/4/99 3:34:45 PM where "M" = "Month"; "D" = " "; if it is currentdate format," h "=" hour ";" s "=" second "; 7. Function datediff () function: calculate a specified time difference format: Datediff (TimeInterval, Date1, Date2 [, firstdayofweek [, firstdayofyear]]) Parameters: TimeInterval is a time unit; DATE1, DATE2 is a valid date expression, firstdayofweek, firstdayofyear is any option. example: <% fromdate = # 8/4/99 # Todate = # 1 / 1/2000 # Response.write "There" & _ Datediff ("D", fromDate, Todate) & _ "Days to Millenium from 8/4/99."%>
RESULTS: There Are 150 Days to Millenium from 8/4/99. 8. Function Day () Features: Returns an integer value, corresponding to a certain day format of the month: DAY (date) Parameters: Date is a valid date expression ; Example <% = Date (# 8/4/99 #)%> Results: 4 9. Function FormatCurrency () Function: Convert to Currency Format Format: Formatcurrency (Expression [, Digit [, LeadingDigit [, PAREN [, GroupDigit ]]]]) Parameters: Expression is a valid digital expression; DIGIT represents the number of digits after the decimal point; LeadingDigit, Paren, GroupDigit is any option. Example <% = formatcurrency (34.3456)%> Result 34.35 10. FunctionDateTime () Function: Formatting Date Expression / Variable Format: FormatorTime (Date [, NameFormat]) Parameters: Date is a valid date expression / variable; NameFormat is the specified date format constant name. Example <% = formtdatetime ("08/04 / 99 ", vblongdate)%> Results: Wednesday, August 04, 1999 Description: -------------------------------- ------------------------------------------------ Description Back Expression, this expression has been formatted as a date or time. Syntax formatdatetime (date [, namedformat]) The syntax of the formatDateTime function has the following parameters: Parameter Description Date must be selected. The date expression to be formatted. NamedFormat options. Indicates the value of the date / time format used, if omitted, use VBGeneLDate. Setting the nameDFormat parameter may have the following values: constant value description VbGeneLDate 0 Displays the date and / or time. If there is a date part, the part is displayed as a short date format. If there is a time part, the part is displayed as a long-time format. If all exist, all parts are displayed. VBlongDate 1 displays the date using the long-term format specified in your computer zone setting. VBShortDate 2 Displays the date using the short date format specified in the computer area settings. VBlongTime 3 Displays time using the time format specified in the computer area setting. VBShortTime 4 shows time using 24-hour format (HH: mm). Description The following example uses the formatdatetime function to format the expression into a long-term type and assign it to myDatetime: Function getCurrentDate "formatdatetime puts the date type as long-term type.
GetcurrentDate = formatdatetime (date, 1) end function -------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------- 11. Function ISNUMERIC () Function: Return to one Boolean value, determining whether the variable is a digital variable, or can convert other variables that can be converted into a number. Format: ISNUMERIC (Expression) Parameters: Expression is any variable. Example: <% i = "234" response.write isnumeric (i) %> Result: True. 12. Function isobject () function: Returns a Boolean value, determine if the variable is the variable of the object, format: isobject (expression) Parameters: Expression is any variable. Example: <% set con = Server. Creatobject ("adodb.connection") response.write isobject (con)%> TRUE 13. Function: lbound () function: Return to a population of an array. Format: lbound (arrayname [, Dimension]) Parameters: ArrayName is an array Variables, Dimension is any example: <% i = array ("1", "2", "3") Response.write lbound (i)%> Result: 014. Function LCase () function: Type variables Characters all transformed lowercase characters. Format: LCase (String) Parameters: string is a string variable example: <% str = "this is lcase!" Response.write Lcase (STR)%> Result: this is lcase! 15. Function LEFT () function: Intercepting a string front part; format: Left (string, length) parameter: String string, length intercepting the length. example: <% = left ("this is a test!", 6)% > Result: This i 16. Function LEN () Function: Returns the byte length format of the string length or variable: LEN (Stri Ng * varName) Parameters: String string; varname Any variable name example: <% strate = "this is a test!" Response.Write Left (strTest)%> Result: 15 17. Function Ltrim () function: Remove character Space in string. Format: LTRIM (String) Parameters: String string. Example: <% = LTRIM ("this is a test!") Result: this is a test! 18. Function MID () function: from string Intercept string. Format: MID (String, Start [, Length]) Parameters: String string, starting point of Start intercept, Length to intercept the length. Example: <% strTest = "this is a test, today is monday! "Response.write MID (STRTEST, 17, 5)%>: Today 19. Function Minute () Features: Returns a value, indicating a minute format: Minute (TIME) parameter: Time is the time variable example lt;% = minute # 12:23:34 #)%> Result: 23 20. Function MONTH () function: Return a value, indicating the month format: Month (Time) Parameters: TIME is the date variable example <% = month (# 08/09 / 99)%> Result: 9 [color =
# 1e90ff] 21. Function MONTHNAME () [/ color] function: Returns the string of the month (name). Format: MONTHNAME (Date [, ABB]) Parameters: Date is a date variable, abb = true, the abbreviation, Example: <% = MONTHNAME (# 4/5/99 #)%> April 22. Function Now () Function: Return to the current time and date of the system. Format: now () parameter: no example: <% = Now ()%> Results: 05/10/00 8:45:32 PM 23. Function: Replace () Function: Find in the string, replace the specified string. Format: Replace (Strtobesearched, Strsearchfor, Strreplacewith [, Start [, count [, compare]]]) Parameters: Strtobesearched is a string; strSearchfor is a sub-string that is found; StrReplaceWith is a sub-string used to replace .Start, Count, Compare is any option. example: <% strTest = "This is an apple." Response.write replace (Strtest, "Apple", "Orange")%> Result: This is an orange. 24. Function Right () Features: Intercepting a string partial format: Right (String, Length) Parameters: String string, length intercept length. Example: <% strate = "this is a test!" Response.write Right (strTest, 3)%> Result: ST! 25. Function RND () Function: Returns a random value format: RND [(Number)] Parameters: Number is any value. Example: <% randomize () response.write rnd ()%> Result: 0/1 Numeric, no randomize (), The random number is not generated. 26. Function Round () function: full value format: Round (Expression [, nuMright]) Parameters: Expression Digital expression; Numright Any Options. Example: <% i = 12.33654 Response.write runk (i)%> Response: 127. Function RTRIM () function: After the string is removed. Format: Rtrim (String) Parameters: String is a string example: <% response.write RTRIM ("this Is A Test! ")%> Results: This is a test! 28. Function Second () function: Return to an integer value. Format: Second (Time) Parameters: Time is a valid time expression; example lt;% = SECOND (# 12: 28: 30 #)%> Results: 30 29. Function strreverse () Features: Return the string with the original string arrangement. Format: Strreverse (String) Parameters: string is a string example <% = STRREVERSE ("this is a test!") Result:! Tset A SI SIHT 30. Function Time () Features: Returns the time value of the current system. Format: Time () parameter: No result: 9: 58: 28 am 31. Function Trim () function: Before deleting the string, the subsequent spaces. Format: Trim (String) Parameters: String string. Example: <% strTest = "this is a test!" Response.write Trim (strTest)%>
