This topic is locked

Display table in a calendar format

7/11/2006 2:58:55 PM
ASPRunnerPro General questions
D
deeg author

I want to generate a calendar based on a table that allows me to edit records.
I want to group on the date field so that all requests for that day show up in a calendar format and be able to edit the record by selecting an entry. Is this possible with ASP Runner? I am a newbie to ASP.
Here are the fields: (there will be multiple listings for the same date and I want to be able to display them grouped by date and edit records. Thanks in advance...
Grouped by: Date

July 10 July 11
Req ID ReqID

Location Location

Person Person

Time Time
ReqID

Location

Person

Time

J
Jane 7/12/2006

Hi,
ASPRunner can do all of this except presenting data in calendar format. This is something that you need to build manually.

D
deeg author 7/17/2006

Hi,

ASPRunner can do all of this except presenting data in calendar format. This is something that you need to build manually.


Can you tell me HOW to group using ASPRunner Professional? I have seen the SORT feature, but nothing on Grouping. I am a newbie, so I need a little more help. Thanks in advance...

J
Jane 7/17/2006

Hi,
you can edit your SQL query on the Edit SQL query tab in the following way:

select field1,

field2

from table1

group by field2



But ASPRunner has limited support of group by queries.
We plan to add full support of group by query in one of the next ASPRunner version.