Recent content by pranavnegandhi

To put the above in words, I want to select all records in TaskHistory where the last record for a given task ID is not closed.

Thank you for your reply. That's not quite what I want though. This is a table of the history of changes made to a particular item. So the latest record in the table would indicate the current status, and I want the history of all items for which the current status is not closed. Table - Task...

The timetracker that I am building stores the history of the task in multiple rows. Here's a simplified view. Task ID | Assignor ID | Assignee ID | Description | Status 1 | 5 | 10 | I could not make this change. Please try at your end | assigned 1 | 10 | 2 | I made this change. Please check it...

Thanks for your reply. I understood what is wrong with my query. But I still don't get it how to get the right one. I'm going ahead with replacing employee id's at runtime with the username, but it would be good to know the solution to this problem.

To continue to keep your HTML files in the root and the css in one level deeper, you need to change your code to this - <link type="text/css" rel="stylesheet" href="css/layout.css">

I agree with neileg. Your database schema could use some normalisation. By taking the simplified view that you present in your post, I can come up with the following - RESPONDENT respondent id name QUESTION question id question ANSWER question id respondent id answer Populate the Answer...

I am building a simple task tracker to keep a record of tasks being passed back and forth between our team. The schema is fairly simple as illustrated in the image below. I want a recordset as follows out of this database (+/- few columns. But these are the most essential ones needed) -...