Can cfselect do it?

[ws1267]

I use cfselect as chain-react select boxes, it work perfectly. But I have an instance I have to set BindOnload = true to all dropdowns, so user is able to start from any dropdowns, I tried but not much success to get it to work. The reason, it may not work in a chain-react manner, it has to be custmomized to cover every conditions.

For example, if the select boxes are Gender, Age, Location and Gender, Age, Location are columns from the same database table by selecting distinct record. The data may look like this:

id	Gender	Age	Location	Date
1	F	25	x	1/2/09
2	M	20	y	.
3	F	35	y	.
4	F	42	x	.
5	M	20	z	.
6	M	20	x	.

Gender dropdown should look like:

ALL

F

M

Age dropdown:

ALL

20

25

35

42

Location dropdown:

ALL

x

y

z

How do I set the dropdowns so user could start from any dropdowns and repopulate the rest two?

If user starts from Location and select z then

Age should select 20

Gender should select M

if user start from Age and select 20 then

Gender should be polulated

ALL

F

M

Location should be populated

ALL

x

y

z

Is this doable with or not with cfselect?

Thanks.

[ws1267]

did it without using cfselect. Simply use Select by parsing parameters via url to redraw the page. Not exactly as I expected. But works. Thanks.

[TLC-IT]

Now that you've succeeded, I'd like to see a more careful explanation of:  just what challenge you were faced with, what stumped you, and then how you finally solved it.

I think the "war story" would be quite useful to many.