Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - I hate misteries
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

I hate misteries
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
simflex View Drop Down
Groupie
Groupie
Avatar

Joined: 10 November 2002
Location: United States
Status: Offline
Points: 63 		Post Options Post Options   Thanks (0) Thanks(0)   Quote simflex Quote  Post ReplyReply Direct Link To This Post Topic: I hate misteries
    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
Back to Top
Pegaso View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 13 February 2003
Location: Switzerland
Status: Offline
Points: 138 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Pegaso Quote  Post ReplyReply Direct Link To This Post Posted: 08 April 2003 at 8:11am
Do you have an error message? If yes please report it here
Back to Top
ultramods View Drop Down
Groupie
Groupie
Avatar

Joined: 08 January 2003
Location: Scotland
Status: Offline
Points: 146 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ultramods Quote  Post ReplyReply Direct Link To This Post 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.

 
Back to Top
simflex View Drop Down
Groupie
Groupie
Avatar

Joined: 10 November 2002
Location: United States
Status: Offline
Points: 63 		Post Options Post Options   Thanks (0) Thanks(0)   Quote simflex Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
ultramods View Drop Down
Groupie
Groupie
Avatar

Joined: 08 January 2003
Location: Scotland
Status: Offline
Points: 146 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ultramods Quote  Post ReplyReply Direct Link To This Post 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?



Edited by ultramods
Back to Top
simflex View Drop Down
Groupie
Groupie
Avatar

Joined: 10 November 2002
Location: United States
Status: Offline
Points: 63 		Post Options Post Options   Thanks (0) Thanks(0)   Quote simflex Quote  Post ReplyReply Direct Link To This Post Posted: 08 April 2003 at 9:11am

yes, that is correct,

thanks!
Back to Top
ultramods View Drop Down
Groupie
Groupie
Avatar

Joined: 08 January 2003
Location: Scotland
Status: Offline
Points: 146 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ultramods Quote  Post ReplyReply Direct Link To This Post Posted: 08 April 2003 at 9:18am

have you created a registration from for the developers are a log in section
Back to Top
simflex View Drop Down
Groupie
Groupie
Avatar

Joined: 10 November 2002
Location: United States
Status: Offline
Points: 63 		Post Options Post Options   Thanks (0) Thanks(0)   Quote simflex Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.