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