Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alxtech
Yak Posting Veteran
66 Posts |
 Posted - 2006-02-16 : 16:50:26
|
| Hello Forum:this is a calendar application event that displays all events from a database sql2000, depending on the department and date.data is currently retrived and display propertly in a table as a list. exampleName: event titledate: event datedepartment: department namedescription: description of the eventif more than one event it will display in consecutive order by date.Name: event titledate: event datedepartment: department namedescription: description of the eventName: event titledate: event datedepartment: department namedescription: description of the eventProblem:I have to display these events in a calendar grid, each individual event inside its corresponding box(day of the month) for corresponding event. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-16 : 17:21:41
|
| Can you post some sample data and the desire result----------------------------------'KH'Time is always against us |
 |
|
|
alxtech
Yak Posting Veteran
66 Posts |
Posted - 2006-02-17 : 11:20:52
|
| This is the datareader that hold the query results from the database.set Recordset1 = Server.CreateObject("ADODB.Recordset")Recordset1.ActiveConnection = oConnRecordset1.Source = "SELECT EVENT_Title,Category,Location,phone,CAST(EVENT_DATE AS DATE),sysdate,Description FROM Table_Name WHERE CAST(EVENT_DATE AS DATE)>trunc(sysdate,'MONTH') AND CAST(EVENT_DATE AS DATE)<LAST_DAY(sysdate) AND CATEGORY = 'one' ORDER BY CAST(EVENT_DATE AS DATE)" Recordset1.Open()I need show all record in its corresponding box(day of month)in a calendar grid like the following:this is the desire result. in php i need it in asp[url]http://calendar.codewalkers.com/calendar.php[/url] |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
calendar grid