First, let's look at the Recordset object as returned using the following SQL query, executed against the Northwind sample data base in Microsoft SQL Server 2000.
SELECT ProductID,ProductName,UnitPrice
FROM Products
WHERE CategoryID = 7
The resultant Recordset object contains all the produces in the database shown in the following table.
| ProductID | ProductName | UnitPrice |
|---|---|---|
| 7 | Uncle Bob's Organic Dried Pears | 30.0000 |
| 14 | Tofu | 23.2500 |
| 28 | Rössle Sauerkraut | 45.6000 |
| 51 | Manjimup Dried Apples | 53.0000 |
| 74 | Longlife Tofu | 10.0000 |
If you are interested in getting these results yourself, try the following JScript example: