I have a table with 1000 seatnumbers. Everytime the website is accessed a new seat should come up (starting with 1 up to 1000) . After the seat came up, it should be deleted from the table. I have used a stored procedure and I call it in ASP.
How should the SELECT statement look like in the stored proc.?
I have now this, which will show all 1000 seats at once:
Stored procedure:
SELECT [02seatno_mad1000].i1_seatno
FROM 02seatno_mad1000;
The ASP:
<% ' Connection String' Provide relative path to your StoredProc.mdb ' database Dim reservat_date Dim i1_seatno reservat_date = Date() ' Connection String ' Provide relative path to your StoredProc.mdb ' databaseDim connStr connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Netwings_db1.mdb") ' Connection Object Dim con Set con = Server.CreateObject("ADODB.Connection") Dim rs ' connecting to database con.Open connStr ' executing stored procedure Set rs = con.Execute ("exec call_seat_mad 'i1_seatno'") ' showing all records While Not rs.EOF Response.Write rs(0) & "" rs.MoveNext Wend ' closing connection and freeing resources con.Close Set rs = Nothing Set con = Nothing %>