
January 13th, 2004, 09:47 PM
|
|
Junior Member
|
|
Join Date: Jan 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Query database data and display it in a table at the specified columns
Hi,
I'm using ASP Javascript, dreamweaver, SQL.
I'm doing something like a booking chart. Does anybody knows how to I query data and display it in the right column in a table (at the right day and time)?
I've created all the necessary connections. I thought of creating a recordset utilizing the advance option, SQL statement for every columns in the table like this:
SELECT Department, Staff
FROM dbo.Booking
WHERE Dy= 1 Mth ='February' AND Yr= 2004 AND StartHour= 0900
I think this should work, but it would mean I wld need to create 589 recordsets for every column.
Can someone suggest any other efficient methos to me?
Thanks a lot a lot in advance!
Viki
|