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:
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
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