Forums

editable dropdown

ataylor14 24 Aug, 2016
Hello
I have followed the examples in
http://www.chronoengine.com/faqs/72-ccv5/5213-direct-list-editing.html
and
https://www.chronoengine.com/forums/posts/f12/t100769.html?hilit=dropdown&page=1
The relevant sections look as follows:

_SELECTOR_
data.id:ID
data.status:Status
etc
_EDIT_:Edit

And in Fields box:

data.status:<select name="data[{data.id}][status]"><option selected value="{data.status}">{data.status}</option><option value="STANDBY">Standby</option><option value="CONFIRMED">Confirmed</option><option value="CANCELLED">Cancelled</option></select>

However in the dropdown instead of having values for the field status I simply see the code {data.status} like this:

<select name="data[232][status]"><option selected="" value="{data.status}">{data.status}</option><option value="STANDBY">Standby</option><option value="CONFIRMED">Confirmed</option><option value="CANCELLED">Cancelled</option></select>

I looked at permissions, studied the examples but I cannot see where I am going wrong and why the value of that field is not picked up from the table.

Your help is appreciated.
Thank you
Amelia
ataylor14 24 Aug, 2016
Edit:

I have now discovered that Delete Cache does not always work and does not pick up the latest changes I made to the table in phpmyadmin.

Is there a limit to how many fields can be retrieved and displayed in Chronoconnectivity?
ataylor14 24 Aug, 2016
My suspicion is that there is an issue with permissions.
For this chronoconnectivity I only need the Admin View - in that I want to edit certain fields. How do I set the permissions?

Also what is the role of the "Owner id column" in the Permission tab?
GreyHead 25 Aug, 2016
Hi Amelia,

In reverse order:

How do I set the permissions? You need to set Public to allowed (as it is the root user - not public in the sense of 'guest'). Plus the other Groups - but note that the permissions cascade so if you set one group denied any child groups will be denied.

what is the role of the "Owner id column" I've never used it but I think that it is there so that you can identify a single 'owner' user and give them specific permissions. I don't believe that works on a row by row basis, there is only one owner per list.

Delete Cache does not always work I'm doubtful about that - I can't easily see how it would fail, though I guess that CC & CF might use different caches. Would that explain it?

Is there a limit to how many fields can be retrieved and displayed Only in the sense that at some point you will run out of memory and get an error message, there is no limit built in to the code.

I'm not sure about the Fields entry - do you see the data available if you enable the Debugger? You could also try <?phe eco $row['data']['status']; ?>

Bob
This topic is locked and no more replies can be posted.