buzz
Posts: 11
|
| Posted: 07/30/2009, 1:41 PM |
|
I am currently have the following problem.
I have a table called contact_list that holds the following fields:
ID
First_Name
Last_Name
Email
List:One
List:Two
The user can add a field that would result in a new column, in theroy they could add a number of colums. What I need to do is have a grid that finds the List:xxx columns and then links to an editable grid that will allow for a checkbox for the user to indicate if this is to be used in this list. I just need to find out how to have the datasource of the checkbox to change depending on the list the user picks.
I have tried an SQL statement that uses the following:
select *, `{listname}` as lname from contact
This shows in the Query Builder as working but for some reason I cannot get the
grid to allow the checkbox on there to show is a person has been checked.
Please help
Vince
|
 |
 |
buzz
Posts: 11
|
| Posted: 07/30/2009, 2:00 PM |
|
Fixed it....
All I had to do was the following
add a Parameter to the Custom Update called listname and get the url value for this and then enter this "SQL UPDATE contact SET `{listname}`='{CheckBox1}' WHERE ID = {ID}"
|
|
|
|
|
