|
Can not get data to show 12 Years, 9 Months ago
|
Karma: 0
|
|
Hi,
I am using ARI Data Tables with Joomla 2.5 to show data via the folowing query:
SELECT
j17_comprofiler.cb_mv,
j17_comprofiler.cb_voortitel,
j17_comprofiler.cb_voorletters,
j17_comprofiler.firstname,
j17_comprofiler.middlename,
j17_comprofiler.lastname,
j17_comprofiler.cb_achtertitel,
j17_comprofiler.cb_bedrijf,
j17_comprofiler.cb_functie,
j17_comprofiler.cb_bedrijftelefoon,
j17_comprofiler.cb_bezoekadresplaats,
j17_users.email
FROM j17_comprofiler
INNER JOIN j17_users ON j17_comprofiler.id = j17_users.id
WHERE j17_comprofiler.cb_advocaat2 =1 AND j17_comprofiler.approved =1 AND j17_users.block =0
(I connect to the Joomla database.)
I keep getting: No data available.
Any ideas please?
Tom
|
|
|
|
|
|
|
Re:Can not get data to show 12 Years, 9 Months ago
|
Karma: 760
|
Hello,
Use the next SQL query and set "SQL -> Debug mode" parameter to "Yes":
| Code: |
SELECT
P.cb_mv,
P.cb_voortitel,
P.cb_voorletters,
P.firstname,
P.middlename,
P.lastname,
P.cb_achtertitel,
P.cb_bedrijf,
P.cb_functie,
P.cb_bedrijftelefoon,
P.cb_bezoekadresplaats,
U.email
FROM
#__comprofiler P INNER JOIN #__users U
ON P.id = U.id
WHERE
P.cb_advocaat2 =1
AND
P.approved =1
AND
U.block =0
|
Regards,
ARI Soft |
|
|
|
|
|
|
|
|
|
Last Edit: 2012/03/01 10:49 By admin.
|
|
|
Re:Can not get data to show 12 Years, 9 Months ago
|
Karma: 760
|
|
Try now please. The problem occurred because the module was loaded into an article (by "Modules Anywhere" plugin) and into a module position.
Regards,
ARI Soft
|
|
|
|
|
|
|
Re:Can not get data to show 12 Years, 9 Months ago
|
Karma: 0
|
|
Thanks, that did it!!!
And so fast...
Tom
|
|
|
|
|
|
|
