adamu
|
| Posted: 02/03/2006, 11:48 AM |
|
im trying out codecharge 3 demo.. looks impressive but i cant figure this out through reading and looking at sample code.
I have 2 simple tables.. tech and projects.. one to many relationship in database. A tech can have many projects.. i created a grid page for techs and under techid i changed it to link control..i want it to reference toall projects base on techid...Href source i selected projects grid page static address which i created and parameter set it techid=techid..but when i click on any techid it shows all project data..not filtering base on techid...is there's anything thing or setting/programing i need to get this working?
thanks
|
|
|
 |
Rene S
|
| Posted: 02/04/2006, 3:18 AM |
|
Hi,
Your projects page, that grid or recordform should have in the "datasource" a "where" clause. In your case: where techid=techid. So you send a parameter and you setup a receive parameter on desired page. Hope I explained it.
Rene
|
|
|
|
adamu
|
| Posted: 02/08/2006, 2:26 PM |
|
Thanks!
that works
also have related question... i added security access to the project and i want tech to be able to thier own profile/acct and thier projects table only.
how to i implement this?.. just like in the portal sample..where member can update his/her acct only.
send tutorial link pls
|
|
|
|
Rene S
|
| Posted: 02/09/2006, 6:56 AM |
|
Hi,
easy way : use "security" in project settings (userID,groupID etc) and "security groups"
Then set grids/forms etc. to restricted and set the right user permissions.
Use example "taskmanager" it is described in there.
Good luck,
Rene
|
|
|
|
adamu
|
| Posted: 02/09/2006, 2:44 PM |
|
i have tech table, projects, users, etc
tech has many projects assigned and i want each tech to only able to edit only projects assigned to them and i want tech to be only able to edit their own user infor which is in user table. Implementing what you recommended didnt help... all techs were able to edit all projects when i grant access
|
|
|
|
Rene S
|
| Posted: 02/09/2006, 2:57 PM |
|
Hi,
I assume you have a user table with: userID, groupID, grouplevelID etc.
In project settings: field "User Id" field, use your ID field
In the grid/recordfom etc. use in datasource: yourID=UserID
set type to "session".
This works if you let your users login first. Then Codecharge starts a session (=parameter but not shown in url) based on your link between UserID and your ID set in security settings. This way only the logged in user can see records/rows etc. wich are his/hers.
(check this thread, should make it clear: http://forums.codecharge.com/posts.php?post_id=56175&s_...+parameter+type
Good luck,
Rene
|
|
|
|
|
