快捷導(dǎo)航

ASP 精華源碼收集（五年總結(jié)）第13/20頁

更新時間：2008年10月20日 22:58:16 作者：

在5年的開發(fā)中，總結(jié)出來的一些源碼

ADO Recordset的屬性和方法的有效性
ADO Recordset的屬性和方法在不同的光標(biāo)類型下，有不同的表現(xiàn)，這里列出了其詳細(xì)情況列表
ADO Recordset屬性的有效性列表
屬性 ForwardOnly Dynamic Keyset Static
AbsolutePage 無效無效讀/寫讀/寫
AbsolutePosition 無效無效讀/寫讀/寫
ActiveConnection 讀/寫讀/寫讀/寫讀/寫
BOF 只讀只讀只讀只讀
Bookmark 無效無效讀/寫讀/寫
CacheSize 讀/寫讀/寫讀/寫讀/寫
CursorLocation 讀/寫讀/寫讀/寫讀/寫
CursorType 讀/寫讀/寫讀/寫讀/寫
EditMode 只讀只讀只讀只讀
EOF 只讀只讀只讀只讀
Filter 讀/寫讀/寫讀/寫讀/寫
LockType 讀/寫讀/寫讀/寫讀/寫
MarshalOptions 讀/寫讀/寫讀/寫讀/寫
MaxRecords 讀/寫讀/寫讀/寫讀/寫
PageCount 無效無效只讀只讀
PageSize 讀/寫讀/寫讀/寫讀/寫
RecordCount 無效無效只讀只讀
Source 讀/寫讀/寫讀/寫讀/寫
State 只讀只讀只讀只讀
Status 只讀只讀只讀只讀
在使用Microsoft OLE DB Provider for ODBC.1.0時候，屬性AbsolutePosition和AbsolutePage是只寫的
ADO Recordse方法的有效性列表
方法 ForwardOnly Dynamic Keyset Static
AddNew 是是是是
CancelBatch 是是是是
CancelUpdate 是是是是
Clone 否否是是
Close 是是是是
Delete 是是是是
GetRows 是是是是
Move 是是是是
MoveFirst 是是是是
MoveLast 否是是是
MoveNext 是是是是
MovePrevious 否是是是
NextRecordset * 是是是是
Open 是是是是
Requery 是是是是
Resync 否否是是
Supports 是是是是
Update 是是是是
UpdateBatch 是是是是
* Microsoft Access databases.不支持
轉(zhuǎn)換大寫中文數(shù)字
----------------------
轉(zhuǎn)換代碼如下：
function Transform()
{
var whole = document.all.num.value;
//分離整數(shù)與小數(shù)
var num;
var dig;
if(whole.indexOf(".") == -1)
{
num = whole;
dig = "";
}
else
{
num = whole.substr(0,whole.indexOf("."));
dig = whole.substr( whole.indexOf(".")+1, whole.length);
}
//轉(zhuǎn)換整數(shù)部分
var i=1;
var len = num.length;
var dw2 = new Array("","萬","億");//大單位
var dw1 = new Array("拾","佰","千");//小單位
var dw = new Array("","壹","貳","叁","肆","伍","陸","柒","捌","玖");//整數(shù)部分用
var dws = new Array("零","壹","貳","叁","肆","伍","陸","柒","捌","玖");//小數(shù)部分用
var k1=0;//計小單位
var k2=0;//計大單位
var str="";
for(i=1;i<=len;i++)
{
var n = num.charAt(len-i);
if(n=="0")
{
if(k1!=0)
str = str.substr( 1, str.length-1);
}
str = dw[Number(n)].concat(str);//加數(shù)字
if(len-i-1>=0)//在數(shù)字范圍內(nèi)
{
if(k1!=3)//加小單位
{
str = dw1[k1].concat(str);
k1++;
}
else//不加小單位，加大單位
{
k1=0;
var temp = str.charAt(0);
if(temp=="萬" temp=="億")//若大單位前沒有數(shù)字則舍去大單位
str = str.substr( 1, str.length-1);
str = dw2[k2].concat(str);
}
}
if(k1==3)//小單位到千則大單位進(jìn)一
{
k2++;
}
}
//轉(zhuǎn)換小數(shù)部分
var strdig="";
for(i=0;i<2;i++)
{
var n = dig.charAt(i);
strdig += dws[Number(n)];//加數(shù)字
}
str += " 點(diǎn) "+strdig;
document.all.text.value = str;
}
如何將數(shù)據(jù)庫中的二進(jìn)制流文件生成到硬盤上？
<%
dim conn, rs
set conn = server.createObject("adodb.connection")
conn.open "Provider=OraOLEDB.Oracle;Data Source=oracle.mydomain.com;User ID=scott;PASSWORD=tiger;Persist Security Info=True"
set rs = conn.execute("SELECT blobcolumn FROM blobtable WHERE id = 7")
'Write it to the browser
response.binaryWrite rs.fields("blobcolumn").value
'Write it to disk
dim stream
set stream = server.createObject("adodb.stream")
stream.type = adTypeBinary
stream.open
stream.write(rs.fields("blobcolumn").value)
stream.saveToFile folderAndFileName, adSaveCreateOverWrite
stream.close
%>
web打印的大全：
1、控制"縱打"、橫打”和“頁面的邊距。
（1）<script defer>
function SetPrintSettings() {
// -- advanced features
factory.printing.SetMarginMeasure(2) // measure margins in inches
factory.SetPageRange(false, 1, 3) // need pages from 1 to 3
factory.printing.printer = "HP DeskJet 870C"
factory.printing.copies = 2
factory.printing.collate = true
factory.printing.paperSize = "A4"
factory.printing.paperSource = "Manual feed"
// -- basic features
factory.printing.header = "This is MeadCo"
factory.printing.footer = "Advanced Printing by ScriptX"
factory.printing.portrait = false
factory.printing.leftMargin = 1.0
factory.printing.topMargin = 1.0
factory.printing.rightMargin = 1.0
factory.printing.bottomMargin = 1.0
}
</script>
（2）
<script language="javascript">
function printsetup(){
// 打印頁面設(shè)置
wb.execwb(8,1);
}
function printpreview(){
// 打印頁面預(yù)覽
wb.execwb(7,1);
}
function printit()
{
if (confirm('確定打印嗎？')) {
wb.execwb(6,6)
}
}
</script>
</head>
<body>
<OBJECT classid="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2"
height=0 id=wb name=wb width=0></OBJECT>
<input type=button name=button_print value="打印"
onclick="javascript:printit()">
<input type=button name=button_setup value="打印頁面設(shè)置"
onclick="javascript:printsetup();">
<input type=button name=button_show value="打印預(yù)覽"
onclick="javascript:printpreview();">
<input type=button name=button_fh value="關(guān)閉"
onclick="javascript:window.close();">