Sample Recordset for Examining Data
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.
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 | Rssle 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: