Greetings,
This is my first post although I have been reading this forum for several months. It has been very helpful.
I am currently trying to find a way to display multiple Select box list on the same form, with independent data from the same SQL table.
Example:
The table I am working with has the following columns:
usergrpid
prtcpid
username
Select Box 1 (we will call Writers) - query a table usrgrpprtcp for all where a specific user group id is specified.
SELECT * FROM usrgrpprtcp WHERE usrgrpid ='0000000156';
The select box data bindings are:
location = record, value=prtcpid display=username
Select Box 2 (we will call Editors)
SELECT * FROM usrgrpprtcp WHERE usrgrpid ='0000000210';
Another list of a different user groups from the same table.
Being new to WebMaker, I am not sure what options are available to me in order for me to achieve this. Do I create new controller somewhere?
If anyone can provide me some insight, assistance or direct me to some instructions elsewhere, I woudl greatly appreciate it.
Thank you,
John
This is my first post although I have been reading this forum for several months. It has been very helpful.
I am currently trying to find a way to display multiple Select box list on the same form, with independent data from the same SQL table.
Example:
The table I am working with has the following columns:
usergrpid
prtcpid
username
Select Box 1 (we will call Writers) - query a table usrgrpprtcp for all where a specific user group id is specified.
SELECT * FROM usrgrpprtcp WHERE usrgrpid ='0000000156';
The select box data bindings are:
location = record, value=prtcpid display=username
Select Box 2 (we will call Editors)
SELECT * FROM usrgrpprtcp WHERE usrgrpid ='0000000210';
Another list of a different user groups from the same table.
Being new to WebMaker, I am not sure what options are available to me in order for me to achieve this. Do I create new controller somewhere?
If anyone can provide me some insight, assistance or direct me to some instructions elsewhere, I woudl greatly appreciate it.
Thank you,
John