NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Johan van Zyl on May 18, 2014, 10:22:23 AM

Title: NetWebForm - filter on Drop
Post by: Johan van Zyl on May 18, 2014, 10:22:23 AM

First a Country is selected via a Drop from Country Table
Then I would like to select a  Province from Province table filtered on CountrySysID
neither of these filters work
‘pro:countrysysid = ' & p_web.GSV(‘cou:countrysysid')
 'pro:countrysysid = <39>' & p_web.GSV('cou:countrysysid') & '<39>'

Drop Filter web33.app does not seem to apply here.

Title: Re: NetWebForm - filter on Drop
Post by: Bruce on May 18, 2014, 10:55:20 PM

a) Is cou:countrysysid a string or a number?

b) is Province added as a field in the Reset Field List of the Country field?

c) if you tick on "send order/filter to debugview" - what filter appears _after_ you select the country?

cheers
Bruce

Title: Re: NetWebForm - filter on Drop
Post by: Johan van Zyl on May 19, 2014, 09:11:33 AM

RESOLVED!
The Form is for people table

 filter must be:
 'pro:countrysysid = <39>' & p_web.GSV('peo:countrysysid') & '<39>'
and had to reset!


sysid's always INTEGER

CREATE TABLE geo.countries(
   countrysysid serial PRIMARY KEY,
  countrycode varchar(10) UNIQUE,
  countrycodeshort  varchar(10) UNIQUE,
   countrydescr citext UNIQUE,
  dailingcode citext,
...
CREATE TABLE geo.provinces(
   provincesysid serial PRIMARY KEY,
  countrysysid integer REFERENCES countries ON DELETE RESTRICT,
  provincecode citext UNIQUE,
   provincedescr citext,
   capitalcity citext,

Click on Drop for Provinces and select South Africa - when I click on Provinces only South African Provinces must be selectable.


I cannot find send order/filter to debugview under LookUp Settings of the Drop,
...

[attachment deleted by admin]