How to get DropDownList input parameters

Hi!

I'm using Forms buider to create a Search Template. The aim of the template is to do a search in a table (table_prueba) by name or by NIF (both are diferent parameters of the table; att_NIF and att_name). The search must work like this: The user must write either his NIF or his name in a TextField, after it, to define the search criteria, the user must chose a value in a DropDownList between NIF and name, and depending on the input value of DropDownList the search will be done by name or nif. The DropDownList is defined with two possible values, Name and NIF. The problem is that I don't know how to take the input value of the DropDownList...The query of my template should be something like that:

select r_object_id from table_prueba where (att_name='$TextField$' and DropDownList value = 'Name') or (att_NIF='$TextField$' and DropDownList value = 'NIF')

What should I put in the DropDownList value???

Thanks in advance!

Find more posts tagged with

Comments

DCTM_Guru

Have you tried putting the name of the dropdown control - just like you did for '$TextField'?

jmeabe

Yes, I have tried with this query:

select r_object_id from la_prueba where (la_atr_prueba='$TextField1$' and '$DropdownList1'='Prueba') or (la_atr_prueba_dni='$TextField1$' and '$DropdownList1'='DNI')

But when I sync terms, the whole template is changed to this:

What am I doing wrong??

DCTM_Guru

I'm not following what it was beforehand and what it should be.

jmeabe

The problem is solved, thanks for your attention!

DCTM_Guru

Can you post your solution so that other who have similar problems know what to look for?