Search values from selection list

There is a colum called "instituicao" in my table. This colum has several rows with 35 diferent values.

I want to select one of theese 35 values from a selection list, and show all the entries of my table with this value.

Is it possible to make it with chronoconnectivity?

ChronoForms and ChronoConnectivity are wonderful components!!! I will write a review soon!

Hi Julio,

Thanks! you will need to have the select list created statically or dynamically at some form, make it a simple Chronoforms one and then a submit button and make the action URL a ChronoConnectivity page and configure the WHERE statement to get the value posted from the select and all should be ok!

let me know if you have troubles!

Cheers

Max

Thanks!!! It appears to be very simple.

I'm quite newbie...
How do I configure the WHERE statement to get the value posted from the select?
What should I write in WHERE statement?

Hi Julio,

it should be something like this :

WHERE id="<?php echo JRequest::getVar('select_field_name'); ?>"

I assumed that id is the primary key for the table!😉

Cheers

Max

Really thanks!!!
I was trying to do it, but then...

Please see my bug report at http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=13&t=10935

After solving the bug!

It worked perfectly well!

I'll never be tired to say: "what wonderful components!!"
Excenlent suport!

Thanks Julio!