I'm building a dynamic seating chart. We're storing everything in SQL Server 2000 and using Classic ASP/VBScript to connect.
What I need to know is this: How can I call certain records to certain parts of the page?
For example: I'm showing the entire seating chart and I also want to show whose sitting in which seat. How can I make a call on the page to pull just that particular seat ID?
So in row 1, let's say I have 5 desks. Seat ID's 1-5. I need to pull records 1-5 in the recordset. The recordset is pulling all of the rows, but I need to place the data in each particular desk.
I hope I explained that correctly.