XDR doesn't know, does it? is a simplified xml-data. Now demonstrate how to implement such a query
SELECT O.orderid, o.orderdate from Orders O, Customers C,
WHERE O.customerid = C.customerid and C.companyname =?
Code:
<%@ Language=vbscript%>
<%
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,, 1024x768 ' adExecuteStream
Response.Write " "
%>
Result:
http://www.bkjia.com/PHPjc/631202.html www.bkjia.com true http://www.bkjia.com/PHPjc/631202.html techarticle XDR doesn't know, does it? is a simplified xml-data. Now demonstrate how to implement such a query for SELECT O.orderid, o.orderdate from Orders O, Customers c, WHERE O.customerid = c.c ...
