First things first. Trying to retreive from a table with a different prefix than my joomla install but the tables are in the same DB. MySQL ver. 5.5
Following the instructions for first basic connection but not sure what to put in where on step #3
For "table column names" is that what I want the column names to be or what the DB column names are?
I don't see any particular box with the name "List View Fields. I see Columns List, Sortables etc and one near the bottom named Fields.
Then under Columns List for example, there's an example but I don't understand that.
I've seen Table.field as syntax example for sql but have never got it to work in phpmyadmin query area. So I don't know if the dot is a different syntax or phpmyadmin doesn't like it or what.
Anyway, I've tried several different formats in the Columns list, sortables and Fields boxes and none of them seem to get my data. Might get array in every row or might get some of what I entered in a box in every row, might get blank rows. I don't know if "Model" means the name of the chronoconectivity Model or if it should be my Table Name as in sql syntax. I have figured out that whatever comes after the colon ends up being the column header names but that's about it. When I put my chronoconnectivity Model name in place of Model in the sample under Column box, no change. I have a table with header rows named and all other rows blank.
I have gone through and set all permissions for super-user as allowed. I named everything in lower case letter with no underscores or special characters. The DB table I'm trying to retreive data from is called wt_names and some fields/columns are n_id, n_name.
Thanks, John
Following the instructions for first basic connection but not sure what to put in where on step #3
Navigate to the "Admin list settings" tab and enter few table columns names in the "List View Fields" box.
For "table column names" is that what I want the column names to be or what the DB column names are?
I don't see any particular box with the name "List View Fields. I see Columns List, Sortables etc and one near the bottom named Fields.
Then under Columns List for example, there's an example but I don't understand that.
Multi line list of fields to be processed, e.g:Model.field:Title
I've seen Table.field as syntax example for sql but have never got it to work in phpmyadmin query area. So I don't know if the dot is a different syntax or phpmyadmin doesn't like it or what.
Anyway, I've tried several different formats in the Columns list, sortables and Fields boxes and none of them seem to get my data. Might get array in every row or might get some of what I entered in a box in every row, might get blank rows. I don't know if "Model" means the name of the chronoconectivity Model or if it should be my Table Name as in sql syntax. I have figured out that whatever comes after the colon ends up being the column header names but that's about it. When I put my chronoconnectivity Model name in place of Model in the sample under Column box, no change. I have a table with header rows named and all other rows blank.
I have gone through and set all permissions for super-user as allowed. I named everything in lower case letter with no underscores or special characters. The DB table I'm trying to retreive data from is called wt_names and some fields/columns are n_id, n_name.
Thanks, John
Hi John,
You associate a table for each model, each table has some columns, so when you need to list one of your columns, you have to use:
Regards,
Max
You associate a table for each model, each table has some columns, so when you need to list one of your columns, you have to use:
Model.column_nameRegards,
Max
This topic is locked and no more replies can be posted.
