This topic is locked

how to apply filter to the list.

1/9/2008 4:13:36 AM
ASPRunnerPro 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/11/2008

Antonio,
use User can see and edit their own records only option on the Advance security settings dialog on the Visual Editor tab for this purpose.