ACCESS parameter query, with VBSCRIPT (ASP) and C # (ASP. NET) Functions
ACCESS parameter query, with VBSCRIPT (ASP) and C # (ASP. NET) Functions
Recently, ACCESS is required for a WEB project for database development.
Many people on the Forum asked questions about ACCESS injection security.
Many people solve this pro
/*-------------------ASP Document reference set-----------------------* *
*--> Author: paramecium
*--> time: 2007-4.28---2007-4.30 (originally a manual written by oneself, now sent here)
*--> Contact: caolvchong@gmail.com
*--> Document Features:
1. Review the ASP, deepen the understanding of ASP structure and the experience of ASP
2. Can be used as an ASP reference, write their own, reference to more convenient
This is part five: the common functions
The following are the commonly used functions and their usage in VBScript.
1, getroproperty
Note: you use the getroproperty method to retrieve the current value of a test object property from a run-time object in your application.
In general, all objects can use this method to obtain the actual value of the runtime object.
Syntax: object. getroproperty (property, [propertydata])
For example, bu
Here are the functions and their uses that I've summarized in VBScript.
1,getroproperty
Description: Use the "Getroproperty method" to retrieve "current value of" a test object property from a Run-time object in your Application.
In general, all objects can use this method to get the actual value of the Run-time object.
Syntax: Object. Getroproperty (property, [Propertydata])
such as Buttonname=brows
/* ------------------- ASP document reference set -----------------------*/
* --> Author: Crawler
* --> Time: 2007-4.28---2007-4.30)
* --> Contact: caolvchong@gmail.com
* --> Document function:
1. I reviewed ASP and deepened my understanding of ASP structure and ASP experience.
2. It can be used for ASP reference and self-written for reference.
This is Part 5: Common VBScript functions in ASP/* -----------
VBScript process
A series of statements encapsulated in sub and End Sub statements
Does not have a return value
Available with parameters
Our subfunction.asp shows the use of sub, with the following code: Submysub (STR1, STR2) Response.Write (Str1Str2)End Submysub"Hello,", "world"Pagermysub ("Hello,", "world")%>VBScript functions
A
1. Numeric functions:
ABS (Num): returns the absolute value.SGN (Num): num> 0 1; num = 0 0; num Hex (Num): returns the hexadecimal value for direct representation: hxx maximum 8 bitsOct (Num): returns the octal value and indicates the maximum 8 bits of oxxSqr (Num): returns the square root num> 0INT (Num): integer int (99.8) = 99; int (-99.2) = 100Fix (Num): Get the integer fix (99.8) = 99; fix (-99.2) = 99Round (Num, n): rounded to the decimal pla
vbscript| function
1. Function Array ()
Function: Create an array variable
Format: Array (list)
Parameters: List of each numeric column in an array variable, separated by a comma
Example:
Result: I was given an array
2. Function CInt ()
Function: Converts an expression/other type of variable to an integer type (int)
Format: Cint (expression)
Parameter: expression is any valid expression/other type of variable
Example:
F = "234"
Response.Write
It's okay to use vbs to collect some or all of the data on other websites for analysis, and then write the data to the database or store it in a text file. Sometimes VBScript is used to move the cursor and input the data, for example, if you add remote desktops in batches, you may also use Vbscript to manage Windows servers. For example, if you set IIS, you may also need to make some timer reminder tools to
PHP, JScript, and VBScript functions and class syntax. 1) function example php: functioninc ($ val) {return $ val + 1;} is also a function, but no return value. Example of the jscript, javascript: functioninc (val) {returnval + 1;} process 1) function
Php: function inc ($ val)
{Return $ val + 1 ;}
The process is also a function, but there is no return value.Jscript, javascript:Function inc (val){Return val
No way. You need to write some asp files.
Code Depressed. Put a function table for future reference.
VBScript (ASP) common functions:
1. Numeric functions:
ABS (Num): returns the absolute value.SGN (Num): num> 0 1; num = 0 0; num Hex (Num): returns the hexadecimal value for direct representation: hxx maximum 8 bitsOct (Num): returns the octal value and
Quote:
VBScript functions extract text from HTML source code
Purpose: This function is used to display the summary of an article to avoid extracting incomplete HTML tags.
Shawl. Qiu2006-7-2
Linenum
'Display plain text content (only extract HTML text without extracting tags)
Function fplaintext (content)
If isnull (content) Then exit function
Set RE1 = new Regexp
Re1.global = true
Re1.ignorecase
vbscript| function | Interactive |vbscript| function | interaction
First, let's look at a piece of code like this:This is achieved when the click of the button, pop-up message box, show welcomewhichA sub defines a procedure that contains two parts:Button1 is the button name (obtained from the Name property in the OnClick is the event name, which is the Button1 onclick event where two parts are connected wit
1) function examplePhp: function inc ($ val){Return $ val + 1 ;}
The process is also a function, but there is no return value.Jscript, javascript:Function inc (val){Return val + 1 ;}The process is defined as above.VBScript:Function inc (val)Inc = val + 1End functionProcedureSub inc2 (byref val)Val = val + 1End sub2) Class ExamplePhp:Class parent {Var property;Function parent (){}Function method (){}}
/* Inherit */Class child extends parent {var property = new value;}
Jscript or javascript:Class
1 Examples of functionsPhp:function Inc ($val){return $val 1;}A procedure is also a function, except that there is no return value.JScript, javascript:Function Inc (VAL){return val 1;}The definition of the process is ibid.VBScript:Function Inc (VAL)inc = Val 1End FunctionProcedureSub Inc2 (ByRef val)val = val 1End Sub2 Examples of classesPhp:Class Parent {var property;function parent () {}Function method () {}}* * Continue * *Class Child extends Parent {var property= new value;}JScript or javasc
();
----------------------------------------------------------------------------
ASP VBScript Syntax
----------------------------------------------------------------------------
Copy Code code as follows:
Set parameter = command. CreateParameter (Name, Type, Direction, Size, Value)
Parameter ditto
Here's an example of all the News Tsing published
------------------------------------------------------
ET conn = Server.Crea
vbscript| function '----------------------------------------------------------
' Function name:length
' Function Desc: Returns the actual length of the string, one Chinese character counts 2 lengths
'---------------------------------------------------------
Public Function Length (sinput)
Dim Oregexp
' Establish regular expressions
Set oregexp = New RegExp
' Set mode
Oregexp.pattern = "[^\x00-\xff]"
' Sets whether to differentiate character case
Or
vbscript| function 1. function Array ()
Function: Create an array variable
Format: Array (list)
Parameters: List of each numeric column in an array variable, separated by a comma
Example:
Result: I was given an array
2. function CInt ()
Function: Converts an expression/other type of variable to an integer type (int)
Format: Cint (expression)
Parameter: expression is any valid expression/other type of variable
Example:
F = "234"
Response.Write CINT (f)
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.