[SOLVED] How to have a list of Database field listed for a User

Hi,
I tried to be as generic as possible in the subject ...
My need is to be able to display a "bank statement" like table with :
- a Date
- a Description
- an amount

I tried with the query field but it only allow me to select one column , thus displays values in one line separated with ","

Any idea on how I can have somehting done with one of the Joomla addon ?

I checked the Blog Addon but it is not working ( installed latest version of core and addon not compatible )
Thx !

CB Query Field or a custom plugin is your only solutions. CB Query Field doesn't have a column or row limit. You can display as many as you want. You'll need to configure it as follows to have multi-row and multi-column usage.

Output: Multiple Rows
Header: Row: Footer:
As I do not know your database structure the above is just an example to get started. Please read the parameter descriptions carefully for further usage.

Hello Kyle !
Thanks for your hepl and reply.
I searched and do not find where I can configure the header, row and footer.
to give you more info , here is my SQL :

SELECT stDate,stdescrip,StAmount,userID
FROM `mybank_transactions`
LIMIT 0 , 30

An additional question is how can I only select rows related to my current user ? ( referenced by the UsedID ). I know how to grab it in PHP : $cbUser->getField('id', null, 'csv', 'none', 'list' ) or $user->name directly... but how can I have it as parameter in my sql statement ?
I have checked and I have all the latest version of all module, plugin etc...
Thx !!!

I searched and do not find where I can configure the header, row and footer.

It's under Parameters > Display of your Query fieldtype.

An additional question is how can I only select rows related to my current user ? ( referenced by the UsedID ). I know how to grab it in PHP : $cbUser->getField('id', null, 'csv', 'none', 'list' ) or $user->name directly... but how can I have it as parameter in my sql statement ?

The query supports substitutions so you'd just substitute it in. Example as follows based off the query you've provided.

that's what I though but under display as drop-down list I have :

-separated with Coma ( no new field appears )
-unnumbered list "ul" ( CSS clas of the list field appears)
-ordered list "ol" ( CSS clas of the list field appears)
I don't have the 3 "panes" like you have ?

[ Edit ]
BTW, using Parameter which works great for SQL, looks that there is an isue in PHP cdeo from CB ?

Strict Standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method cbQueryFieldClass::escapeSQL() should not be called statically in /home/XXXXXXXXX/public_html/libraries/CBLib/CB/Legacy/CBuser.php on line 1041

Thx

You need to create a field of the type Query. If you don't have the fieldtype available then CB Query Field isn't installed. If CB Query Field is installed then ensure it's up to date according to the chart below.

www.joomlapolis.com/cb-20-addon-status