Hi together and happy new year to all!!



I still have a problem with my sql request, and after 2 days of testing no further idea where the problem could be.
Working with joomla 1.5.22, latest Community Builder 1.3.1 installed.

My sql table works fine as far as I try filtering to the looged user with the following code:

FROM #__flight_log_all_id WHERE pilot_id = {$UserId}

However, if I change the variable {$UserID} to, let's say user "64", no problem.

Is there anything to do before I could use the {$UserId} within Ari Data table?

Could anybody help me, I'm realy frustrated...

By the way, here is the complete code for this Data table request:

______________________


{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn id="DATE" alias="Datum" width="20%" className="idg"}
{arisqltablecolumn id="PILOT" alias="Pilot" headerClassName="head"}
{arisqltablecolumn id="CO" alias="Begleiter" headerClassName="head"}
{arisqltablecolumn id="STA" alias="Startart" headerClassName="head"}
{arisqltablecolumn id="REG" alias="Kennzeichen" headerClassName="head"}
{arisqltablecolumn id="TYPE" alias="Typ" headerClassName="head"}
{arisqltablecolumn id="TOF" alias="Startzeit" headerClassName="head"}
{arisqltablecolumn id="LA" alias="Landezeit" headerClassName="head"}
{arisqltablecolumn id="FT" alias="Flugzeit" headerClassName="head"}
{arisqltablecolumn id="DEP" alias="Startort" headerClassName="head"}
{arisqltablecolumn id="DEST" alias="Landeort" headerClassName="head"}
{arisqltablecolumn id="REM" alias="Bemerkung" headerClassName="head"}
{/arisqltablecolumns}
{arisqltablequery}
SELECT Datum AS DATE,Pilot AS PILOT,Begleiter AS CO, Startart AS STA,Kennzeichen AS REG,Startzeit AS TOF,Landezeit AS LA,Flugzeit AS FT,Startort AS DEP, Landeort AS DEST, Bemerkung AS REM
FROM #__flight_log_all_id WHERE pilot_id = {$UserId} LIMIT 0 , 240
{/arisqltablequery}
{/arisqltable}

_________________________


Thanks a lot

Best regards


Klaus

Hello,

{$UserId} predefined variable is supported by ARI Data Tables extension not by "ARI JData Table" plugin from "ARI Smart Content" extension. If necessary to use variables into SQL query, DirectPHP plugin can be used that embed PHP code into an article.

Regards,
ARI Soft

Thanks,

DIRECTPhp solved the problem!

Regards

Klaus