Hi,

I have worked through many forum answers regarding SQL variables in a secondary table query but I am unable to get my code to work.

Please could you check it out for me?

The page is here: (removed)

The example tables and data I am using works if the WHERE statement in the second table is set to the following:

SELECT * FROM go_tbl_test_roles WHERE role_id=2

(or the 2 is exchanged for any valid value in the second table go_tbl_test_roles)

But the variable expression WHERE role_id={$REQUEST:employee_id} returns no table at all.


Regards

Hello,

It seems you use "ARI Smart Content: DataTable Pack", but this topic is about "ARI Data Tables" extension (these are two different extensions). Currently "ARI Smart Content" doesn't support ability to use request variables in SQL query.

Regards,
ARI Soft

Hi,

Disappointing but if I purchase Ari Data Table extension, will I need to uninstall smart content or can they be used together?

Regards

They can work together.

Regards,
ARI Soft

Hi,
I am resurrecting this topic because whilst I have had success using the variables in the SQL Query for some years, I recently upgraded from Joomla 2.5.1 to version 5 and I can't get the same query to work.

The previous code was like this:

I create a link in the reference field (WW Ref) by adding this code in the format field for WW_Ref in the source table:

<a href="index.php?option=com_content&view=article&id=46&ww_ref={$value}">{$value}</a>

Then in the SQL Query for the table to filter, the code is:

SELECT ww_ref, service_id, service_name, DATE_FORMAT(visit_date,'%d/%m/%Y') AS visit_date, team_leader, comment,report
FROM go_tbl_ww_history
WHERE ww_ref={$REQUEST:ww_ref}

The page won't load with the following error:

If difficulties persist, please contact the website administrator and report the error below.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3


Both tables show fine if a temporarily change the WHERE statement to a static:

WHERE ww_ref=10030

(Where 10030 is a value in WW_Ref

Hello,

Could you contact us by email and provide a link to a page where the problem occurs and a temporary access to your J! backend so we can investigate the problem?

Regards,
ARI Soft