NetTalk Central
NetTalk Web Server => Web Server - Ask For Help => Topic started by: zdpl0a on August 31, 2007, 02:18:23 PM
-
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
-
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
-
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
-
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
-
Bruce & Alan
Works like a champ !
Thanks,
Dave