DatabaseJoin (DATA - where)

raimis

Member
Hi, dont work if databasejoin Render as "autocomplete"
my element {wt_income_list___booking_id} = 6, and i try
in where enter:
WHERE {thistable}.parent_id = '{wt_income_list___booking_id}' - No records found
WHERE {thistable}.parent_id = {wt_income_list___booking_id} - get error
WHERE {thistable}.parent_id = '6' - found my record
try get variable from url. My url have &BookingID=6
WHERE {thistable}.parent_id = '{BookingID}' - No records found

if Render as "Drop-down" work only with variable from url....
WHERE {thistable}.parent_id = '{BookingID}' - found my record
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top