Buy Now
Sign in

Search values from selection list

JulioCastro , September 01 2008, 23:34
J
JulioCastro 16
September 01 2008, 23:34 #12417
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!
admin 28
September 02 2008, 11:55 #12427
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
Max
If your main question got answered then please mark the answer using the button!
Did you try the new ChronoForms7 ? if yes then please send us your comments!!
J
JulioCastro 16
September 02 2008, 14:23 #12449
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?
admin 28
September 02 2008, 16:06 #12453
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
Max
If your main question got answered then please mark the answer using the button!
Did you try the new ChronoForms7 ? if yes then please send us your comments!!
J
JulioCastro 16
September 03 2008, 00:34 #12482
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
J
JulioCastro 16
September 03 2008, 04:55 #12494
After solving the bug!

It worked perfectly well!

I'll never be tired to say: "what wonderful components!!"
Excenlent suport!
admin 28
September 03 2008, 08:47 #12502
Thanks Julio!
Max
If your main question got answered then please mark the answer using the button!
Did you try the new ChronoForms7 ? if yes then please send us your comments!!