ColdFusion

cfselect issue trying to get results from a sql select statement

Please support our ColdFusion advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2004

Posts: 3

Reputation: alwaysneedhelp is an unknown quantity at this point

Solved Threads: 0

alwaysneedhelp alwaysneedhelp is offline

Offline

Newbie Poster

cfselect issue trying to get results from a sql select statement

Oct 30th, 2004

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

•

Join Date: Aug 2004

Posts: 3

Reputation: srinu is an unknown quantity at this point

Solved Threads: 0

srinu

Offline

Newbie Poster

Re: cfselect issue trying to get results from a sql select statement

Nov 29th, 2004

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#