| pdeguise 2006-03-25, 3:04 pm |
| Hi,
I've got a series of CGI scripts that form a generic framework for accessing PostgreSQL databases.
One of my outstanding requirements is being able to "drill down" in an input form; i.e., say you have a "Company" drop-down menu and a "People" drop down menu; by selecting a company, the "People" drop down menu should be populated with only those people that work at the nominated company.
Now, I could do that in Javascript with relative ease, BUT, here's the rub:
(a) Given that the system supports row-level access restrictions on users, I can't have the source code for the page reveal in any data in the Javascript data structure;
(b) Because this is all dynamic data from any one of a large number of tables, I can't use server-sided java scripts either.
What I'd like to be able to somehow do is have the "onChange" attribute of the HTML code invoke a "sub-CGI" which populates the required field based on the database content.
Is this possible?
Cheers,
Preston. |