ASP essence source code collection (five-year summary) page 13/20

The effectiveness of properties and methods of ADO Recordset
The properties and methods of ADO Recordset have different performances under different cursor types. Here is a list of its detailed information.
ADO Recordset property validity list
Properties ForwardOnly Dynamic Keyset Static
AbsolutePage Invalid Invalid Read/Write Read/Write
AbsolutePosition Invalid Invalid Read/Write Read/Write
ActiveConnection Read/Write Read/Write Read/Write Read/Write
BOF Read-only Read-only Read-only Read-only
Bookmark Invalid Invalid Read/Write Read/Write
CacheSize Read/Write Read/Write Read/Write Read/Write
CursorLocation Read/Write Read/Write Read/Write Read/Write
CursorType Read/Write Read/Write Read/Write Read/Write
EditMode Read-only Read-only Read-only Read-only
EOF Read-only Read-only Read-only Read-only
Filter Read/Write Read/Write Read/Write Read/Write
LockType Read/Write Read/Write Read/Write Read/Write
MarshalOptions Read/Write Read/Write Read/Write Read/Write
MaxRecords Read/Write Read/Write Read/Write Read/Write
PageCount Invalid Invalid Read-only Read-only
PageSize Read/Write Read/Write Read/Write Read/Write
RecordCount Invalid Invalid Read-only Read-only
Source Read/Write Read/Write Read/Write Read/Write
State Read-only Read-only Read-only Read-only
Status Read-only Read-only Read-only Read-only
When using Microsoft OLE DB Provider for ODBC.1.0, the properties AbsolutePosition and AbsolutePage are written only
ADO Recordse method validity list
Method ForwardOnly Dynamic Keyset Static
AddNew Yes Yes Yes Yes
CancelBatch Yes Yes Yes Yes
CancelUpdate Yes Yes Yes Yes
Clone No No Yes Yes
Close Yes Yes Yes Yes
Delete Yes Yes Yes
GetRows Yes Yes Yes Yes
Move Yes Yes Yes Yes
MoveFirst Yes Yes Yes Yes
MoveLast No Yes Yes Yes
MoveNext Yes Yes Yes Yes
MovePrevious No Yes Yes Yes
NextRecordset * Yes Yes Yes
Open Yes Yes Yes Yes
Requery Yes Yes Yes Yes
Resync No No Yes Yes
Supports Yes Yes Yes Yes
Update Yes Yes Yes Yes
UpdateBatch Yes Yes Yes Yes
* Microsoft Access databases. Not supported
Convert capital Chinese numbers
----------------------
The conversion code is as follows:
function Transform()
{
var whole = ;
//Separate integers and decimals
var num;
var dig;
if((".") == -1)
{
num = whole;
dig = "";
}
else
{
num = (0,("."));
dig = ( (".")+1, );
}
//Convert integer part
var i=1;
var len = ;
var dw2 = new Array("","million","million");//Large unit
var dw1 = new Array("Se","Bai","Qian");//Small unit
var dw = new Array("","one","one","one","one","one","one","one","one","one"one");//All products"one");//All products"one号");
var dws = new Array("zero","one","two","three","si","wu","lu","seven","ba","nine");// Use the decimal part
var k1=0;//Count small units
var k2=0;//The unit counts large
var str="";
for(i=1;i<=len;i++)
{
var n = (len-i);
if(n=="0")
{
if(k1!=0)
str = ( 1, -1);
}
str = dw[Number(n)].concat(str);//Add number
if(len-i-1>=0)//In the numerical range
{
if(k1!=3)//Add small units
{
str = dw1[k1].concat(str);
k1++;
}
else//No small unit, increase unit
{
k1=0;
var temp = (0);
if(temp=="10,000" temp=="10,000")//If there is no number before the large unit, then the large unit will be abandoned
str = ( 1, -1);
str = dw2[k2].concat(str);
}
}
if(k1==3)//Small unit to thousand large unit to one
{
k2++;
}
}
//Convert the fractional part
var strdig="";
for(i=0;i<2;i++)
{
var n = (i);
strdig += dws[Number(n)];//Add number
}
str += " dot "+strdig;
= str;
}
How to generate binary stream files in database to hard disk?
<%
dim conn, rs
set conn = ("")
"Provider=;Data Source=;User ID=scott;PASSWORD=tiger;Persist Security Info=True"
set rs = ("SELECT blobcolumn FROM blobtable WHERE id = 7")
'Write it to the browser
("blobcolumn").value
'Write it to disk
dim stream
set stream = ("")
= adTypeBinary

(("blobcolumn").value)
folderAndFileName, adSaveCreateOverWrite

%>
A complete collection of web printing:
1. Control the margins of "vertical hit", horizontal hit" and "pages.
（1）<script defer>
function SetPrintSettings() {
// -- advanced features
(2) // measure margins in inches
(false, 1, 3) // need pages from 1 to 3
= "HP DeskJet 870C"
= 2
= true
= "A4"
= "Manual feed"
// -- basic features
= "This is MeadCo"
= "Advanced Printing by ScriptX"
= false
= 1.0
= 1.0
= 1.0
= 1.0
}
</script>
（2）
<script language="javascript">
function printsetup(){
// Print page settings
(8,1);
}
function printpreview(){
// Print page preview
(7,1);
}
function printit()
{
if (confirm('Are you sure to print?')) {
(6,6)
}
}
</script>
</head>
<body>
<OBJECT class
height=0 id=wb name=wb width=0></OBJECT>
<input type=button name=button_print value="Print"
onclick="javascript:printit()">
<input type=button name=button_setup value="Print page settings"
onclick="javascript:printsetup();">
<input type=button name=button_show value="Print preview"
onclick="javascript:printpreview();">
<input type=button name=button_fh value="Close"
onclick="javascript:();">