limit user to edit only his record(s)

Classic Servoy
1

I’m new to servoy so a’m sorry if the question is on the wrong place or already asked… (I did search :wink:

In short;
user should only be able to edit records who are ‘owned by him’

Longer story;
I store CV’s into a database and I want to make sure user can not see or edit other peoples data; In the old fashioned way (php/mysql) I use a login-screen (phpsecurepages) and after logging on I get an recordID which I use to collect the right data;

Which way I should search for a solution? Is it posible to create a login-screen and store an ID in the variable? Pass this var as parameter to a form; and use a query in stead of a table as basus for this form? (I prefere not to use globals)

btw I’m working with Servoy R2 2.2b2-build 318 on Java 1.5.0_02-b09.
thanks in advance,

–
Jeroen J.J. Eck
freelancer.nu

ps. thanks for the introduction in Maarssen

2

Hi Jeroen, I spoke to you today in Maarssen. :)

Use the addFoundsetFilterParam for that (under the controller of each form)
do this once, and you never have to worry about, that the user sees other data than that you have set with this function!

Hope it helps

3

HJK:
addFoundsetFilterParam

Thanks; I’ll RTFM to find out how to use this …

–
jjj