Hang on a bit, because I'm actively working on getting a kind of tutorial in order that will show how to use the Database Query Component (
www.gmitc.biz/
) with community builder. I actually have it working now at
www.chessprogrammers.com/dbq/3.htm
The form you see there is actually generated by DBQ. DBQ is filling up those combo drop downs. If you just click submit you'll see the whole membership, with avatars.
I've got DBQuery installed and the basic tutorial working.
Can you show me how you defined the query to connect to CB?
I've tried this:
[code:1]SELECT
`avatar` AS $<foto>,
`firstname` AS $<voornaam>,
`lastname` AS $<achternaam>,
`cb_bedrijfsnaam` AS $<bedrijf>
FROM jos_comprofiler
WHERE `active` = 1[/code:1]
but it doesn't produce any results
