Display Customer Name & ID on Page After Login

[zdpl0a]

Hi All,

My login works fine.  As part of the login I read the customer contact file to verify the ID and Password and then read the customer's master control record.

I am using three frames - heading - then a left and right - just like eample 31 (hint)

My Problem:   When The login is complete - "I want to display the Customer Info (Name, Address, logged in contact) on the first page after the login. "

 I have the info stored in the session q...  Everything else I'm doing is fine, - reports, email just want to get rid of the browse I have sitting there with all the customers I am using for testing (and customers can not us it that way.) I'll also need to us the customer # and contact # for filters.

Thanks,

Dave

[zdpl0a]

Hi All,

I got most of the problem below fixed, but the filter....

Can someone please help me with the syntax...  It is a compound statement

I store the customerNumer during the login process - which reads CUS1:CustomerNum

XTP:Status = 'C" < found in the record in the browse box.

CUS1:CustomerNum = XTP:CustomerNum - Both are longs

Both must be true to allow the row to display in a browse box.

After loading LocCompanyNum

XTP:Status = 'C'  AND Loc:CompanyNum = XTPCustomerNum

I've tried multiple formats... The secod half of the statement - the company number test always fails.

Thanks,

Dave

[Alan Telford]

Hi Dave,

Most likely the value of loc:companynum is zero as a new thread is started for every page you view on nettalk.
So try this:

loc:companynum = p_web.getsessionvalue('XXXX') !XXXX is the name you used to store it when logging in.
XTP:Status = 'C'  AND Loc:CompanyNum = XTPCustomerNum

When the customer logs in, you will need to store the sessionvalue
i.e. p_web.setsessionvalue('XXXX', yourvalue)

Cheers,
Alan

[Bruce]

Hi Dave,

use sessionValues in your filter.

ie Instead of

'XTP:Status = 'C'  AND Loc:CompanyNum = XTPCustomerNum'
put

'XTP:Status = ''C''  AND  XTPCustomerNum' = ' & p_web.GetSessionValue('whatever')

(notice also the 2 single quotes on both sides of the C)

Cheers
Bruce

[zdpl0a]

Bruce & Alan

Works like a champ !

Thanks,

Dave