Member Avatar for 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

  • 2 Contributors
  • 1 Reply
  • 73 Views
  • 4 Weeks Discussion Span
  • Latest Post Latest Post by srinu
Member Avatar for 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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.