cfselect issue trying to get results from a sql select statement

[alwaysneedhelp]

Anyone know how I can get sql results from three cfselect forms.

I'm trying to have the user select from three cfselect lists and draw results based on those choices.

I'd appreciate any help you can give.
Thanks

[srinu]

hi,

you can do this. for this to work you need to have where clause in your query to get the data based on the these 3 cfselect.

for eg.

select * from emp where field1=#select1# and field2=#select2# and field3=#select3#

:cool:

Srinivas