home *** CD-ROM | disk | FTP | other *** search
/ Mastering Internet Develo…oft ActiveX Technologies / Mastering Internet Development with ActiveX (1996)(Microsoft).iso / labs / webfinal / scripts / odetails.idc < prev    next >
Encoding:
Text File  |  1996-07-16  |  342 b   |  8 lines
  1. Datasource: WebMainSt
  2. Template: ODetails.htx
  3. SQLStatement:
  4. +SELECT Products.ProductID, Products.ProductName, [Order Details].OrderID, Quantity, [Order Details].UnitPrice, 
  5. + quantity * [Order Details].unitprice as subtotal
  6. + FROM Products, [Order Details] 
  7. + WHERE Products.ProductID = [Order Details].ProductID
  8. + AND OrderID=%orderid%