> bit disconcerting
there was a massive thread recently about singular/plural table names
>i have a Session.person_id
well, if another join doesnt work for you then you could do a subselect:
WHERE
tasks.status_id = 1
<CFIF Session.company_id neq 0>
<!--- this is the bit i need help with --->
AND project_id IN (select project_id from person_project where
person_id =
#session.person_id#)
</CFIF>
-----Original Message-----
From: Chris Kavanagh [mailto:[EMAIL PROTECTED]
Sent: 04 April 2005 17:29
To: CF-Talk
Subject: Re: OT rookie: link table
>> people.person_id
> hahahahahhahahhahhhahhhhahaha.....ahhhhh. sigh.
>
> sorry Chris, back to the topic.
<:| uh?
I love it when I'm funny but it's a bit disconcerting when I don't know
why.
>> it only gets TASKS that belong to the PROJECT that the PERSON
> is cleared for
>
> Im not sure how you are defining "cleared for", but it should just be a
> couple more Inner Joins?
Well i have a Session.person_id. I should be able to compare that
somehow with the table people_project (which is a combination of
person_id and project_id), and thereby find out which project(_id)(s)
match which the logged in person(_id), right?
Thanks!
CK.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201388
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
