I am attempting to write an ASP application which will display a person's 
Time Card data in a tabular format.  The idea is to allow supervisors to 
add/modify/delete any tasks for a particular developer as needed and also 
enable the developer to input the amount of time spent working on the 
project and a description of what he/she did for that day.  Developers may 
have more than one project to work on for one particular day, so we need 
to be able to display anywhere from 0 to 3 different tasks for any day.

I currently have the following as the main table structure which I have to 
work with...
Day        TimeCardCode    Hrs   Description
Sun
Mon
Tues
Wed
Thur
Fri
Sat

The TimeCardCode is a number assigned for each task and the Day is saved 
off as an integer from 0-6 in the database.  I have very little problem 
with being able to display each day's activities if there is only one item 
per day.  The biggest problem is if someone has more than one task on any 
particular day.  I'm not sure how I would go about writing the table not 
knowing whether or not there are more items for a day.  Does anyone know 
how to work out this problem?  If you need more info, please ask.

Chris  

PS. Here is how I envision a day with more than one task...

<tr>
   <td>Monday</td>
   <td>9930402949 <br>
       9938584738</td>
   <td>4<br>
       4</td>
   <td>Fixed infinite loop <br>
       Created new table in database</td>
</tr>

If there's an easier way to do this, please let me know.

I have written a whole scheduling application that does what you want.
If you have interest in purchasing it call me at 704 366 6321.

Ed@E...

-----Original Message-----
From: Christopher Cote [mailto:cotec@s...]
Sent: Monday, December 30, 2002 5:44 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Need help with Time Card-like page


I am attempting to write an ASP application which will display a person's
Time Card data in a tabular format.  The idea is to allow supervisors to
add/modify/delete any tasks for a particular developer as needed and also
enable the developer to input the amount of time spent working on the
project and a description of what he/she did for that day.  Developers may
have more than one project to work on for one particular day, so we need
to be able to display anywhere from 0 to 3 different tasks for any day.

I currently have the following as the main table structure which I have to
work with...
Day        TimeCardCode    Hrs   Description
Sun
Mon
Tues
Wed
Thur
Fri
Sat

The TimeCardCode is a number assigned for each task and the Day is saved
off as an integer from 0-6 in the database.  I have very little problem
with being able to display each day's activities if there is only one item
per day.  The biggest problem is if someone has more than one task on any
particular day.  I'm not sure how I would go about writing the table not
knowing whether or not there are more items for a day.  Does anyone know
how to work out this problem?  If you need more info, please ask.

Chris

PS. Here is how I envision a day with more than one task...

<tr>
   <td>Monday</td>
   <td>9930402949 <br>
       9938584738</td>
   <td>4<br>
       4</td>
   <td>Fixed infinite loop <br>
       Created new table in database</td>
</tr>

If there's an easier way to do this, please let me know.

I don't need a full scheduling program.  I have just about everything 
figured out except for how to write the day's tasks without repeating the 
day or the week.  For example, as in my example, I don't want to have:

<tr>
   <td>Monday</td>
   <td>9930402949</td>
   <td>4</td>
   <td>Fixed infinite Loop</td>
</tr>
<tr>
   <td>Monday</td>
   <td>9938584738</td>
   <td>4</td>
   <td>Created new table in database</td>
</tr>

What I want is to make sure that Monday appears only in the first row.

Chris