Hi and Thanks in advance.
I am trying to something a little trickier than usual and have got stuck. My guess is on the syntax of the where clause in a read function. Any help would be great.
I have the where clause empty and the select type on first matching record. If I change either of these then I get no results at all. Again this leads me to the understanding its my where clause to have it look at an identifier for each row to tell it what to display. Am I at least on the right track?
If so I just don't know/understand the syntax I need to use. Help is appreciated.
I am trying to something a little trickier than usual and have got stuck. My guess is on the syntax of the where clause in a read function. Any help would be great.
- Have a table calling in data and displaying - no probs
- Table has a row called Action, to display the data from two table fields in a certain way within that row. I have made a new read function, created a form view and this in tern calls a fields view with the CC in it with the data being called and displayed in the table as desired. - This is where is goes wrong.
I have the where clause empty and the select type on first matching record. If I change either of these then I get no results at all. Again this leads me to the understanding its my where clause to have it look at an identifier for each row to tell it what to display. Am I at least on the right track?
If so I just don't know/understand the syntax I need to use. Help is appreciated.
It would help if you post a screenshot of your read data actions, and probably your table too.
This is the table:
This is the table read action:
This is the read action for the form/fields:
This is the table read action:
This is the read action for the form/fields:
What's in the {view:Operator_Records_Training_Form} ?
And that second read data action, how is it supposed to be related to the first one?
Ive made this way more complicated than it needs to be.
So, I want to display these three fields:
That are being called in this array, shown in the debug:
Here:
I know I can show one of the results at a time but I want to show 3 of those 4 (Not the hot_wear). I thought of doing a view and calling in a form and fields but cant make that work. Am I on the right track? Or something else?
So, I want to display these three fields:
That are being called in this array, shown in the debug:
Here:
I know I can show one of the results at a time but I want to show 3 of those 4 (Not the hot_wear). I thought of doing a view and calling in a form and fields but cant make that work. Am I on the right track? Or something else?
*sigh* show me the view please.
If you just want to DISPLAY the values then in your table view do the following:
Action:{var:Operator_Records_Table.row.Article.field1}<br>{var:Operator_Records_Table.row.Article.field2}<br>{var:Operator_Records_Table.row.Article.field3}
This topic is locked and no more replies can be posted.
