%@ LANGUAGE=JavaScript %> <% // Uma função que pode dar jeito alhures function obterConnection(BD){ var myConnection = Server.CreateObject("ADODB.Connection"); path = Server.MapPath("\\mipw\\db\\"+BD); myConnection.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" + path) return myConnection; } myConnection = obterConnection("NorthWind.mdb"); ID = Request.QueryString("numero"); instrucaoSQL= "SELECT * FROM Orders WHERE OrderID="+ID; myRecordSet = myConnection.Execute(instrucaoSQL); %>
Cliente | <%=myRecordSet.Fields("customerId").Value%> |
Colaborador | <%=myRecordSet.Fields("EmployeeId").Value%> |
Data | <%=myRecordSet.Fields("OrderDate").Value%> |
... |
Items da Encomenda:
Produto | Qtd |
---|---|
"+outroRS.Fields("ProductID").Value+" | "); Response.Write(""+outroRS("UnitPrice")+" | "); Response.Write("