2008年7月8日
<H2>Date/Time Functions</H2>
<TABLE class=ex cellSpacing=0 width="100%" border=1>
<TBODY>
<TR>
<TH align=left width="32%">Function</TH>
<TH align=left width="68%">Description</TH></TR>
<TR>
<TD vAlign=top>CDate</TD>
<TD vAlign=top>Converts a valid date and time expression to the variant of subtype Date</TD></TR>
<TR>
<TD vAlign=top>Date</TD>
<TD vAlign=top>Returns the current system date</TD></TR>
<TR>
<TD vAlign=top>DateAdd</TD>
<TD vAlign=top>Returns a date to which a specified time interval has been added</TD></TR>
<TR>
<TD vAlign=top>DateDiff</TD>
<TD vAlign=top>Returns the number of intervals between two dates</TD></TR>
<TR>
<TD vAlign=top>DatePart</TD>
<TD vAlign=top>Returns the specified part of a given date</TD></TR>
<TR>
<TD vAlign=top>DateSerial</TD>
<TD vAlign=top>Returns the date for a specified year, month, and day</TD></TR>
<TR>
<TD vAlign=top>DateValue</TD>
<TD vAlign=top>Returns a date</TD></TR>
<TR>
<TD vAlign=top>Day</TD>
<TD vAlign=top>Returns a number that represents the day of the month (between 1 and 31, inclusive)</TD></TR>
<TR>
<TD vAlign=top>FormatDateTime</TD>
<TD vAlign=top>Returns an expression formatted as a date or time</TD></TR>
<TR>
<TD vAlign=top>Hour</TD>
<TD vAlign=top>Returns a number that represents the hour of the day (between 0 and 23, inclusive)</TD></TR>
<TR>
<TD vAlign=top>IsDate</TD>
<TD vAlign=top>Returns a Boolean value that indicates if the evaluated expression can be converted to a date</TD></TR>
<TR>
<TD vAlign=top>Minute</TD>
<TD vAlign=top>Returns a number that represents the minute of the hour (between 0 and 59, inclusive)</TD></TR>
<TR>
<TD vAlign=top>Month</TD>
<TD vAlign=top>Returns a number that represents the month of the year (between 1 and 12, inclusive)</TD></TR>
<TR>
<TD vAlign=top>MonthName</TD>
<TD vAlign=top>Returns the name of a specified month</TD></TR>
<TR>
<TD vAlign=top>Now</TD>
<TD vAlign=top>Returns the current system date and time</TD></TR>
<TR>
<TD vAlign=top>Second</TD>
<TD vAlign=top>Returns a number that represents the second of the minute (between 0 and 59, inclusive)</TD></TR>
<TR>
<TD vAlign=top>Time</TD>
<TD vAlign=top>Returns the current system time</TD></TR>
<TR>
<TD vAlign=top>Timer</TD>
<TD vAlign=top>Returns the number of seconds since 12:00 AM</TD></TR>
<TR>
<TD vAlign=top>TimeSerial</TD>
<TD vAlign=top>Returns the time for a specific hour, minute, and second</TD></TR>
<TR>
<TD vAlign=top>TimeValue</TD>
<TD vAlign=top>Returns a time</TD></TR>
<TR>
<TD vAlign=top>Weekday</TD>
<TD vAlign=top>Returns a number that represents the day of the week (between 1 and 7, inclusive)</TD></TR>
<TR>
<TD vAlign=top>WeekdayName</TD>
<TD vAlign=top>Returns the weekday name of a specified day of the week</TD></TR>
<TR>
<TD vAlign=top>Year</TD>
<TD vAlign=top>Returns a number that represents the year</TD></TR></TBODY></TABLE><BR>
<TABLE width="100%" border=0>
<TBODY>
<TR>
<TD align=left width="70%">
<H2>Conversion Functions</H2></TD>
<TD align=right width="30%">Top</TD></TR></TBODY></TABLE>
<TABLE class=ex cellSpacing=0 width="100%" border=1>
<TBODY>
<TR>
<TH align=left width="32%">Function</TH>
<TH align=left width="68%">Description</TH></TR>
<TR>
<TD vAlign=top>Asc</TD>
<TD vAlign=top>Converts the first letter in a string to ANSI code</TD></TR>
<TR>
<TD vAlign=top>CBool</TD>
<TD vAlign=top>Converts an expression to a variant of subtype Boolean</TD></TR>
<TR>
<TD vAlign=top>CByte</TD>
<TD vAlign=top>Converts an expression to a variant of subtype Byte</TD></TR>
<TR>
<TD vAlign=top>CCur</TD>
<TD vAlign=top>Converts an expression to a variant of subtype Currency</TD></TR>
<TR>
<TD vAlign=top>CDate</TD>
<TD vAlign=top>Converts a valid date and time expression to the variant of subtype Date</TD></TR>
<TR>
<TD vAlign=top>CDbl</TD>
<TD vAlign=top>Converts an expression to a variant of subtype Double</TD></TR>
<TR>
<TD vAlign=top>Chr</TD>
<TD vAlign=top>Converts the specified ANSI code to a character</TD></TR>
<TR>
<TD vAlign=top>CInt</TD>
<TD vAlign=top>Converts an expression to a variant of subtype Integer</TD></TR>
<TR>
<TD vAlign=top>CLng</TD>
<TD vAlign=top>Converts an expression to a variant of subtype Long</TD></TR>
<TR>
<TD vAlign=top>CSng</TD>
<TD vAlign=top>Converts an expression to a variant of subtype Single</TD></TR>
<TR>
<TD vAlign=top>CStr</TD>
<TD vAlign=top>Converts an expression to a variant of subtype String</TD></TR>
<TR>
<TD vAlign=top>Hex</TD>
<TD vAlign=top>Returns the hexadecimal value of a specified number</TD></TR>
<TR>
<TD vAlign=top>Oct</TD>
<TD vAlign=top>Returns the octal value of a specified number</TD></TR></TBODY></TABLE><BR>
<TABLE width="100%" border=0>
<TBODY>
<TR>
<TD align=left width="70%">
<H2>Format Functions</H2></TD>
<TD align=right width="30%">Top</TD></TR></TBODY></TABLE>
<TABLE class=ex cellSpacing=0 width="100%" border=1>
<TBODY>
<TR>
<TH align=left width="32%">Function</TH>
<TH align=left width="68%">Description</TH></TR>
<TR>
<TD vAlign=top>FormatCurrency</TD>
<TD vAlign=top>Returns an expression formatted as a currency value</TD></TR>
<TR>
<TD vAlign=top>FormatDateTime</TD>
<TD vAlign=top>Returns an expression formatted as a date or time</TD></TR>
<TR>
<TD vAlign=top>FormatNumber</TD>
<TD vAlign=top>Returns an expression formatted as a number</TD></TR>
<TR>
<TD vAlign=top>FormatPercent</TD>
<TD vAlign=top>Returns an expression formatted as a percentage</TD></TR></TBODY></TABLE><BR>
<TABLE width="100%" border=0>
<TBODY>
<TR>
<TD align=left width="70%">
<H2>Math Functions</H2></TD>
<TD align=right width="30%">Top</TD></TR></TBODY></TABLE>
<TABLE class=ex cellSpacing=0 width="100%" border=1>
<TBODY>
<TR>
<TH align=left width="32%">Function</TH>
<TH align=left width="68%">Description</TH></TR>
<TR>
<TD vAlign=top>Abs</TD>
<TD vAlign=top>Returns the absolute value of a specified number</TD></TR>
<TR>
<TD vAlign=top>Atn</TD>
<TD vAlign=top>Returns the arctangent of a specified number</TD></TR>
<TR>
<TD vAlign=top>Cos</TD>
<TD vAlign=top>Returns the cosine of a specified number (angle)</TD></TR>
<TR>
<TD vAlign=top>Exp</TD>
<TD vAlign=top>Returns <EM>e</EM> raised to a power</TD></TR>
<TR>
<TD vAlign=top>Hex</TD>
<TD vAlign=top>Returns the hexadecimal value of a specified number</TD></TR>
<TR>
<TD vAlign=top>Int</TD>
<TD vAlign=top>Returns the integer part of a specified number</TD></TR>
<TR>
<TD vAlign=top>Fix</TD>
<TD vAlign=top>Returns the integer part of a specified number</TD></TR>
<TR>
<TD vAlign=top>Log</TD>
<TD vAlign=top>Returns the natural logarithm of a specified number</TD></TR>
<TR>
<TD vAlign=top>Oct</TD>
<TD vAlign=top>Returns the octal value of a specified number</TD></TR>
<TR>
<TD vAlign=top>Rnd</TD>
<TD vAlign=top>Returns a random number less than 1 but greater or equal to 0</TD></TR>
<TR>
<TD vAlign=top>Sgn</TD>
<TD vAlign=top>Returns an integer that indicates the sign of a specified number</TD></TR>
<TR>
<TD vAlign=top>Sin</TD>
<TD vAlign=top>Returns the sine of a specified number (angle)</TD></TR>
<TR>
<TD vAlign=top>Sqr</TD>
<TD vAlign=top>Returns the square root of a specified number</TD></TR>
<TR>
<TD vAlign=top>Tan</TD>
<TD vAlign=top>Returns the tangent of a specified number (angle)</TD></TR></TBODY></TABLE><BR>
<TABLE width="100%" border=0>
<TBODY>
<TR>
<TD align=left width="70%">
<H2>Array Functions</H2></TD>
<TD align=right width="30%">Top</TD></TR></TBODY></TABLE>
<TABLE class=ex cellSpacing=0 width="100%" border=1>
<TBODY>
<TR>
<TH align=left width="32%">Function</TH>
<TH align=left width="68%">Description</TH></TR>
<TR>
<TD vAlign=top>Array</TD>
<TD vAlign=top>Returns a variant containing an array</TD></TR>
<TR>
<TD vAlign=top>Filter</TD>
<TD vAlign=top>Returns a zero-based array that contains a subset of a string array based on a filter criteria</TD></TR>
<TR>
<TD vAlign=top>IsArray</TD>
<TD vAlign=top>Returns a Boolean value that indicates whether a specified variable is an array</TD></TR>
<TR>
<TD vAlign=top>Join</TD>
<TD vAlign=top>Returns a string that consists of a number of substrings in an array</TD></TR>
<TR>
<TD vAlign=top>LBound</TD>
<TD vAlign=top>Returns the smallest subscript for the indicated dimension of an array</TD></TR>
<TR>
<TD vAlign=top>Split</TD>
<TD vAlign=top>Returns a zero-based, one-dimensional array that contains a specified number of substrings</TD></TR>
<TR>
<TD vAlign=top>UBound</TD>
<TD vAlign=top>Returns the largest subscript for the indicated dimension of an array</TD></TR></TBODY></TABLE><BR>
<TABLE width="100%" border=0>
<TBODY>
<TR>
<TD align=left width="70%">
<H2>String Functions</H2></TD>
<TD align=right width="30%">Top</TD></TR></TBODY></TABLE>
<TABLE class=ex cellSpacing=0 width="100%" border=1>
<TBODY>
<TR>
<TH align=left width="32%">Function</TH>
<TH align=left width="68%">Description</TH></TR>
<TR>
<TD vAlign=top>InStr</TD>
<TD vAlign=top>Returns the position of the first occurrence of one string within another. The search begins at the first character of the string</TD></TR>
<TR>
<TD vAlign=top>InStrRev</TD>
<TD vAlign=top>Returns the position of the first occurrence of one string within another. The search begins at the last character of the string</TD></TR>
<TR>
<TD vAlign=top>LCase</TD>
<TD vAlign=top>Converts a specified string to lowercase</TD></TR>
<TR>
<TD vAlign=top>Left</TD>
<TD vAlign=top>Returns a specified number of characters from the left side of a string</TD></TR>
<TR>
<TD vAlign=top>Len</TD>
<TD vAlign=top>Returns the number of characters in a string</TD></TR>
<TR>
<TD vAlign=top>LTrim</TD>
<TD vAlign=top>Removes spaces on the left side of a string</TD></TR>
<TR>
<TD vAlign=top>RTrim</TD>
<TD vAlign=top>Removes spaces on the right side of a string</TD></TR>
<TR>
<TD vAlign=top>Trim</TD>
<TD vAlign=top>Removes spaces on both the left and the right side of a string</TD></TR>
<TR>
<TD vAlign=top>Mid</TD>
<TD vAlign=top>Returns a specified number of characters from a string</TD></TR>
<TR>
<TD vAlign=top>Replace</TD>
<TD vAlign=top>Replaces a specified part of a string with another string a specified number of times</TD></TR>
<TR>
<TD vAlign=top>Right</TD>
<TD vAlign=top>Returns a specified number of characters from the right side of a string</TD></TR>
<TR>
<TD vAlign=top>Space</TD>
<TD vAlign=top>Returns a string that consists of a specified number of spaces</TD></TR>
<TR>
<TD vAlign=top>StrComp</TD>
<TD vAlign=top>Compares two strings and returns a value that represents the result of the comparison</TD></TR>
<TR>
<TD vAlign=top>String</TD>
<TD vAlign=top>Returns a string that contains a repeating character of a specified length</TD></TR>
<TR>
<TD vAlign=top>StrReverse</TD>
<TD vAlign=top>Reverses a string</TD></TR>
<TR>
<TD vAlign=top>UCase</TD>
<TD vAlign=top>Converts a specified string to uppercase</TD></TR></TBODY></TABLE><BR>
<TABLE width="100%" border=0>
<TBODY>
<TR>
<TD align=left width="70%">
<H2>Other Functions</H2></TD>
<TD align=right width="30%">Top</TD></TR></TBODY></TABLE>
<TABLE class=ex cellSpacing=0 width="100%" border=1>
<TBODY>
<TR>
<TH align=left width="32%">Function</TH>
<TH align=left width="68%">Description</TH></TR>
<TR>
<TD vAlign=top>CreateObject</TD>
<TD vAlign=top>Creates an object of a specified type</TD></TR>
<TR>
<TD vAlign=top>Eval</TD>
<TD vAlign=top>Evaluates an expression and returns the result</TD></TR>
<TR>
<TD vAlign=top>GetLocale</TD>
<TD vAlign=top>Returns the current locale ID</TD></TR>
<TR>
<TD vAlign=top>GetObject</TD>
<TD vAlign=top>Returns a reference to an automation object from a file</TD></TR>
<TR>
<TD vAlign=top>GetRef</TD>
<TD vAlign=top>Allows you to connect a VBScript procedure to a DHTML event on your pages</TD></TR>
<TR>
<TD vAlign=top>InputBox</TD>
<TD vAlign=top>Displays a dialog box, where the user can write some input and/or click on a button, and returns the contents</TD></TR>
<TR>
<TD vAlign=top>IsEmpty</TD>
<TD vAlign=top>Returns a Boolean value that indicates whether a specified variable has been initialized or not</TD></TR>
<TR>
<TD vAlign=top>IsNull</TD>
<TD vAlign=top>Returns a Boolean value that indicates whether a specified expression contains no valid data (Null)</TD></TR>
<TR>
<TD vAlign=top>IsNumeric</TD>
<TD vAlign=top>Returns a Boolean value that indicates whether a specified expression can be evaluated as a number</TD></TR>
<TR>
<TD vAlign=top>IsObject</TD>
<TD vAlign=top>Returns a Boolean value that indicates whether the specified expression is an automation object</TD></TR>
<TR>
<TD vAlign=top>LoadPicture</TD>
<TD vAlign=top>Returns a picture object. Available only on 32-bit platforms</TD></TR>
<TR>
<TD vAlign=top>MsgBox</TD>
<TD vAlign=top>Displays a message box, waits for the user to click a button, and returns a value that indicates which button the user clicked</TD></TR>
<TR>
<TD vAlign=top>RGB</TD>
<TD vAlign=top>Returns a number that represents an RGB color value</TD></TR>
<TR>
<TD vAlign=top>Round</TD>
<TD vAlign=top>Rounds a number</TD></TR>
<TR>
<TD vAlign=top>ScriptEngine</TD>
<TD vAlign=top>Returns the scripting language in use</TD></TR>
<TR>
<TD vAlign=top>ScriptEngineBuildVersion</TD>
<TD vAlign=top>Returns the build version number of the scripting engine in use</TD></TR>
<TR>
<TD vAlign=top>ScriptEngineMajorVersion</TD>
<TD vAlign=top>Returns the major version number of the scripting engine in use</TD></TR>
<TR>
<TD vAlign=top>ScriptEngineMinorVersion</TD>
<TD vAlign=top>Returns the minor version number of the scripting engine in use</TD></TR>
<TR>
<TD vAlign=top>SetLocale</TD>
<TD vAlign=top>Sets the locale ID and returns the previous locale ID</TD></TR>
<TR>
<TD vAlign=top>TypeName</TD>
<TD vAlign=top>Returns the subtype of a specified variable</TD></TR>
<TR>
<TD vAlign=top>VarType</TD>
<TD vAlign=top>Returns a value that indicates the subtype of a specified variable</TD></TR></TBODY></TABLE><BR>
<H2>VBScript Keywords</H2>
<TABLE class=ex cellSpacing=0 width="100%" border=1>
<TBODY>
<TR>
<TH align=left width="32%">Keyword</TH>
<TH align=left width="68%">Description</TH></TR>
<TR>
<TD vAlign=top>empty</TD>
<TD vAlign=top>
<P>Used to indicate an uninitialized variable value. A variable value is uninitialized when it is first created and no value is assigned to it, or when a variable value is explicitly set to empty.</P>
<P>Example:<BR>dim x 'the variable x is uninitialized!<BR>x="ff" 'the variable x is NOT uninitialized anymore<BR>x=empty 'the variable x is uninitialized!</P>
<P><STRONG>Note:</STRONG> This is not the same as Null!!</P></TD></TR>
<TR>
<TD vAlign=top>isEmpty</TD>
<TD vAlign=top>
<P>Used to test if a variable is uninitialized.</P>
<P>Example: If (isEmpty(x)) 'is x uninitialized?</P></TD></TR>
<TR>
<TD vAlign=top>nothing</TD>
<TD vAlign=top>Used to indicate an uninitialized object value, or to disassociate an object variable from an object to release system resources.
<P>Example: set myObject=nothing</P></TD></TR>
<TR>
<TD vAlign=top>is nothing</TD>
<TD vAlign=top>Used to test if a value is an initialized object.
<P>Example: If (myObject Is Nothing) 'is it unset?</P>
<P><STRONG>Note:</STRONG> If you compare a value to Nothing, you will not get the right result! Example: If (myObject = Nothing) 'always false!</P></TD></TR>
<TR>
<TD vAlign=top>null</TD>
<TD vAlign=top>Used to indicate that a variable contains no valid data.
<P>One way to think of Null is that someone has explicitly set the value to "invalid", unlike Empty where the value is "not set".</P>
<P><STRONG>Note:</STRONG> This is not the same as Empty or Nothing!!</P>
<P>Example: x=Null 'x contains no valid data</P></TD></TR>
<TR>
<TD vAlign=top>isNull</TD>
<TD vAlign=top>Used to test if a value contains invalid data.
<P>Example: if (isNull(x)) 'is x invalid?</P></TD></TR>
<TR>
<TD vAlign=top>true</TD>
<TD vAlign=top>Used to indicate a Boolean condition that is correct (true has a value of -1)</TD></TR>
<TR>
<TD vAlign=top>false</TD>
<TD vAlign=top>Used to indicate a Boolean condition that is not correct (false has a value of 0)</TD></TR></TBODY></TABLE>
<P> </P>
2007年3月14日
一、傻瓜式
在给DIV一个 TOP-PADDING 的值，值设置多少要自己去试。
二、单行内容的居中
只考虑单行是最简单的，无论是否给容器固定高度，只要给容器设置 line-height 和 height，并使两值相等，再加上 over-flow: hidden 就可以了
.middle-demo-1{
height: 4em;
line-height: 4em;
overflow: hidden;
}
优点：
1. 同时支持块级和内联极元素
2. 支持所有浏览器
缺点：
1. 只能显示一行
2. IE中不支持<img>等的居中
三、多行内容居中，且容器高度可变
也很简单，给出一致的 padding-bottom 和 padding-top 就行
.middle-demo-2{
padding-top: 24px;
padding-bottom: 24px;
}
优点：
1. 同时支持块级和内联极元素
2. 支持非文本内容
3. 支持所有浏览器
缺点：
容器不能固定高度
|
2007年3月5日
一般我们看到的比如新闻列表，为了使文字不回行，控制字数，会通过程序让多余的字符显示省略号，我们只使用CSS可以达到同样的效果，虽然不完美。
li { width:50px; white-space:nowrap; text-overflow:ellipsis; overflow: hidden; }
首先是一个容器，可以是div,li,td等等，先定义宽度，“white-space:nowrap”是强制在一行内显示所有文本，不回行。“text-overflow:ellipsis”就是关键了。
text-overflow是CSS3新增的属性，IE6以上版本支持。它可以带2个参数：clip [不显示省略标记（...），而是简单的裁切]，ellipsis[当对象内文本溢出时显示省略标记（...）]。所以，这个方法是不支持Firefox的。因此，我们还要加上一句overflow: hidden，让多余文字在ff中隐藏。
此方法对我们网站很是管用,由于录入框支持扩展区和基本区双区输入,所以从其他网站复制过来的扩展区文本可以正常现实,但是在长度计算上总是出现问题!用这个方法就可以解决了,但是普及上就...
新的东西固然好，但是兼容上就存在问题了~
2007年1月16日
<div style="width:600px;height:400px;" id="div1">
<asp:GridView ID="GridView1" runat="server" Height="300px" Width="200px">
</asp:GridView>
</div>
<script language="javascript" type="text/javascript">
document.getElementById("div1").contentEditable = true;
document.execCommand('2D-Position', true, true);
</script>
2007年1月15日
Access创建表：create table test
(name char(4),
isvisited yesno, --布尔类型
primary key(name))
------------------------------------------------------
修改一个字段为自动编号：
ALTER TABLE tableName ALTER COLUMN [AutoNumberFieldName] COUNTER (1, 1)
------------------------------------------------------
Access字段类型：文本 nvarchar(n)
备注 ntext
数字(长整型) int
数字(整型) smallint
数字(单精度) real
数字(双精度) float
数字(字节) tinyint
货币 money
日期 smalldatetime
布尔 bit
---------------------------------------------------------
ALTER TABLE table [ * ]
ALTER [ COLUMN ] column { SET DEFAULT value | DROP DEFAULT }
如：alter table t_domain alter column abc set default 0
这条语句在Access的Sql查询视图中是执行不了的
2007年1月12日
2007年1月8日
2006年11月29日
2006年11月27日
2006年11月9日
2006年11月7日
2006年11月3日
2006年10月20日