Database join element where close based on field value

[chakib]

Hi,

I have a form with database join element which is filtred using where close to show only user related data.
I need to add seconde where close to show only row that match with an element field in the form, i used this code but it shows nothing
WHERE {thistable}.created_by = {$my->id}
and {thistable}.adress = {call___adresse}

Any solution please?

 

[troester]

Strings must be quoted. Try
{thistable}.adress = '{call___adresse}'
or
{thistable}.adress = '{call___adresse_raw}'

 

[chakib]

I used strings, but i show nothing, may be because i use google map element for geocoding.
In the first list i use googlemaps element to geocode position and get contact city and populate city field wich is read only, i do the same in call form to get user position and popolate city with geocoding.
But even if same city database join element or cascading dropdown doesnt show contact in the same city.
I dont know why??