Classic ASP Discussion - I hate misteries

Print Page | Close Window

I hate misteries

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=1684
Printed Date: 29 March 2026 at 5:17am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: I hate misteries

Posted By: simflex
Subject: I hate misteries
Date Posted: 08 April 2003 at 7:55am

I have written a program that tracks the projects that a developer is working on.
Almost all is working except one snippet of the code.
This is the code that displays projects belonging to a particular developer.
So when you log into the system, you see a screen that says:
"View all projects"
"View Active Projects"
"View My Projects"
"View My projects displays only projects belonging to one particular developer.

On the database, there is a field called "assignedTo".
This field contains names of developers assigned a project.
For instance, assignedTo = 'John Doe'
and a field called section that contains various depts.
eg section = 'IT'

Here is my code:( I am using session variable).
SQL = "SELECT * FROM project WHERE Section = 'IT' AND assignedTo = '" & Session("assignedTo") & "' "

Then at the top of the page, I have a code that reads:
Projects belonging to: <%=Session("assignedTo")%>
The names are not getting displayed and the projects are not getting displayed.
Please tell me what I am doing wrong.
Thanks in advance

Replies:

Posted By: Pegaso
Date Posted: 08 April 2003 at 8:11am

Do you have an error message? If yes please report it here

-------------

Posted By: ultramods
Date Posted: 08 April 2003 at 8:15am

Are you initialising <%=Session("assignedTo")%> as a particular developer when they log in. I think that could be the problem.

Also could you display more of your code please.

Posted By: simflex
Date Posted: 08 April 2003 at 8:42am

ultramods, you are right, the problem is that I am not initializing <%=Session("assignedTo")%> as a particular developer.

That field captures the names of everyone logging into the system.

So I did not want the program reading "Projects belonging to: anyone who logged in.

I just want it to capture only those who are assigned the field assignedTo in the project table.

Posted By: ultramods
Date Posted: 08 April 2003 at 8:52am

To reiterate you want to know how to display a developers name and View their current projects, is that correct?

Posted By: simflex
Date Posted: 08 April 2003 at 9:11am

yes, that is correct,

thanks!

Posted By: ultramods
Date Posted: 08 April 2003 at 9:18am

have you created a registration from for the developers are a log in section

Posted By: simflex
Date Posted: 08 April 2003 at 9:30am

I have created a registration for developers to log in.

In this form, there is a field from the database called fullname.

I just changed it to assignedTo.

This captures their names, eg. John Doe.

I also have a field on a table called project and this field is also called assignedTo.

Posted By: ultramods
Date Posted: 08 April 2003 at 9:58am

If you have done that, then all you have to do is set Session("assignedTo") = username when a developer logs in.