Topic on Project:Support desk

passing variable dynamically to external data extention

1

83.103.62.77 (talkcontribs)

Hi,

I'm using external data extention because I need to get data from a mysql table.

I use this code:

{{#get_db_data: db=database|from=table |limit=50 |order by=alias ASC |data=c1=column }}

I would like to add a where clause like this:

{{#get_db_data: db=database|from=table|where=alias like '%{{{1}}}%' |limit=50 |order by=alias ASC |data=c1=column }}

I would like to pass the variable ID with an input box (the input box extention does not work). Is that possibile?