87,907
社区成员
发帖
与我相关
我的任务
分享
set rs=server.CreateObject ("adodb.recordset")
sql = "select * from table"
rs.open sql,conn,1,1
前台客户端定义一个RS
var rsDst = new ActiveXObject("ADODB.Recordset");
with(rs)
{
//设置rs的类型
cursortype=1;
locktype=3;
//添加列
fields.append("id",adBigInt);
fields.append("name",adBSTR);//===========变量搞错了,前面试的时候没改过来
}
<html>
<head>
<meta http-equiv="http-content" content="text/html;charset=gb2312"/>
<title>XML数据岛测试</title>
</head>
<body>
<!----------------这个数据岛你可以使用recordset对象来生成如同下面的格式--------------------->
<xml id='ds'>
<rows>
<row><id>2</id><name>name2</name></row>
<row><id>1</id><name>name1</name></row>
<row><id>3</id><name>name3</name></row>
</rows>
</xml>
<script>
//数据类型定义,这个我也搞不清楚类型
//在网上和书上都没找到客户端的recordset对于的类型
//只好按adovbs.inc中的类型试试,这两个满足要求,可以添加入列中的类型
var adBSTR = 8;//字符类型
var adBigInt = 20;//数字类型
var dsrs=ds.recordset;//获取数据岛中的recordset
var rs=new ActiveXObject("adodb.recordset");
with(rs)
{
//设置rs的类型
cursortype=1;
locktype=3;
//添加列
fields.append("id",adBigInt);
fields.append("name",adVariant);
}
rs.Open();
while(!dsrs.eof)
{
rs.AddNew();
rs(0)=dsrs(0)
rs(1)=dsrs(1);
rs.Update();
dsrs.movenext();
}
rs.sort="id";//排序
rs.MoveFirst();
alert(rs(0)+"|"+rs(1));
rs=null;
</script>
</body>
</html>
page1
page2
//设置打印 <object id="factory" style="display:none" viewastext classid="clsid:1663ed61-23eb-11d2-b92f-008048fdd814" codebase="http://www.meadroid.com/scriptx/ScriptX.cab#Version=5,60,0,360" >object> <script language=javascript> function window.onload() { // -- advanced features factory.printing.SetMarginMeasure(2) // measure margins in inches factory.printing.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 = "居左显示&b居中显示&b居右显示页码,第&p页/共&P页" factory.printing.footer = "(自定义页脚)" factory.printing.portrait = false factory.printing.leftMargin = 0.75 factory.printing.topMargin = 1.5 factory.printing.rightMargin = 0.75 factory.printing.bottomMargin = 1.5 } function Print(frame) { factory.printing.Print(true, frame) // print with prompt }