This topic is locked
[SOLVED]

 filter list

1/9/2008 4:12:05 AM
PHPRunner General questions
T
totti_60 author

Hi
I have a table order where i put information for each order that custmer issue to me.

I want to give to my custmers the chance to follow this information, but the custmer has to see and edit only the information regard him, so I created a session variable at the login step, it records the name of the cusmter, so that i can filter the list of tabel order with the order regard only that custmer.

I tried to modify the select with clause "where custmer=Session("log_custmer")", but it doesn't work it say me cannot retrieve coloumn info.

Could you pls tell me the correct sintax i have to use to do that ?????

Thank you in advance for your kind attention.

Antonio

J
Jane 1/9/2008

Antonio,
I recommend you to use User can see and edir their own records only security option on the Advanced security settings dialog on the Security tab.