Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

SQL Data Table do not work!
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: SQL Data Table do not work!
#9726
SQL Data Table do not work! 13 Years, 3 Months ago Karma: 0
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
Last Edit: 2011/01/01 18:26 By klaustillmann.
The topic has been locked.
 
#9738
Re:SQL Data Table do not work! 13 Years, 2 Months ago Karma: 746
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
The topic has been locked.
 
#9739
Re:SQL Data Table do not work! 13 Years, 2 Months ago Karma: 0
Thanks,

DIRECTPhp solved the problem!

Regards

Klaus
The topic has been locked.
 
Go to topPage: 1