Posted by Russ
2016-09-07

Hi Tom, This is the most amazing tool - and has enabled me to look much cleverer than I really am! :-)

I have created an address database of around 8,000 members. One of the fields in the database is "District". There are 18 different districts.

I want to enable my sales guy in each District to see only address records for his District. I could create 18 different instances of the app in different folders on my web server - but that makes updating/keeping current more onerous than I would like.

My problem would be solved if I could pass a MySQL *select* statement via the url to select a range of records based on District.

Is this possible?

Keep up the GREAT work.

Russ
Posted by Tom
2016-09-09

>My problem would be solved if I could pass a MySQL *select* statement via the url to select a range of records based on District.

You can specify search criteria in url like this:
index.php?_sc=(table-name)/&sp:def:(field-name)=(value)
For example, suppose the table name is "address", the field name is "district", and the value of the district to search is "area1", then url will be
index.php?_sc=address/&sp:def:district=area1