NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Thomas on April 22, 2008, 02:03:07 AM

Title: Range limiting - how ?
Post 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

Title: Re: Range limiting - how ?
Post by: Gregg Matteson on April 24, 2008, 05:15:52 AM

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

Title: Re: Range limiting - how ?
Post by: Thomas on April 27, 2008, 02:37:49 AM

Hi Gregg,
thanks.... slowly I got the whole picture.
Best regards, Thomas