NetTalk Central
NetTalk Web Server => Web Server - Ask For Help => Topic started by: Thomas on April 22, 2008, 02:03:07 AM
-
In NetWebBrowse Settings - Filters I can have Range limiting. I have done this with "Single value" to a local variable with an initial value. But the browse is empty (ok, there are recs with that value in the table !). Any special settings that I might have overlooked ?
My goal: I habve a table with lots of recs and want to display only a few wich belong to a currently (session) logged in user. The above mentioned local var holds the ID of the logged in user. The next step will be the passing of the ID from the Login page to the WebBrowse.
But at first: how to range limiting a large TPS table to a single value (hte table has an appropriate key) ?
TIA, Thomas
-
Thomas.
in your login form - validate update
something like this...
GlobalErrors.Init !initialize GlobalErrors object
Access:Client.Init !initialize Access:Client object
Access:Client.Open()
Access:Client.UseFile()
clear(client)
Cli:Contact = upper(clip(Loc:Login))
Cli:Password = upper(clip(Loc:Password))
Get(Client,CLI:loginKey)
p_web.SetSessionValue('sesspassword',clip(Cli:Password))
p_web.SetSessionValue('sessgpid',CLI:GroupID)
p_web.SetSessionValue('sessClico',CLIP(CLI:ClientCompany))
p_web.SetSessionValue('seeclipuaid',CLI:ClientPUAID)
note their are probably more elegant ways to do this, but it works for me. The point is you are putting record contents into "session" variables so that you can use p_web.GetSessionValue in other procedures. No local variables. the filtering issue will probably take care of itself after you get this right.
HTH
Gregg
-
Hi Gregg,
thanks.... slowly I got the whole picture.
Best regards, Thomas