xdr不会不知道吧？就是简化的xml-data啦。现在示范一个如何实现这样的查询
select o.orderid, o.orderdate from orders o, customers c,
where o.customerid = c.customerid and c.companyname = ?
code:
dim sconn
sconn = provider=sqloledb; data source=(local); initial catalog=northwind; user id=sa;password=;
dim adoconn
set adoconn = server.createobject(adodb.connection)
adoconn.connectionstring = sconn
adoconn.cursorlocation = 3 'aduseclient
adoconn.open
dim adocmd
set adocmd = createobject(adodb.command)
set adocmd.activeconnection = adoconn
adocmd.commandtext = customer[@companyname=tortuga restaurante]
adocmd.dialect = {ec2a4293-e898-11d2-b1b7-00c04f680c56}
adocmd.properties(mapping schema) = orders.xml
adocmd.properties(base path) = c:inetpubwwwrootpba
adocmd.properties(output stream) = response
response.write
adocmd.execute , , 1024 'adexecutestream
response.write
%>
result:
http://www.bkjia.com/phpjc/631202.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/631202.htmltecharticlexdr不会不知道吧？就是简化的xml-data啦。现在示范一个如何实现这样的查询 select o.orderid, o.orderdate from orders o, customers c, where o.customerid = c.c...