Forums

Show Data from DB

Kernel 02 Feb, 2013
Hi, I would like put a table into my form so I can show the data from my db.
How can I do?
Tanks
GreyHead 07 Feb, 2013
Hi Kernel,

The simplest way is to use the Data Displayer option in the Db Multi-Record Loader action.

Bob
Kernel 07 Feb, 2013
there is an example?
GreyHead 22 Feb, 2013
Hi Kernel,

Add a DB Multi-Record Loader to your form On Load action e.g. jos_content

On the Basic tab select the Table and add a list of column names to the Fields box e.g id,title

On the Data Displayer tab Enable the Data Displayer; put the same list* of column names in the Display Fields box and set Enable Pagination to Bottom.

That's it really, all the other settings allow you change what is selected or how it is displayed.

Bob

* It doesn't have to be the same, you can leave the Basic box empty so that all the columns are loaded. If you list anything in the Fields box you must include all the columns that you want to display.
This topic is locked and no more replies can be posted.