cfselect issue trying to get results from a sql select statement

Expand Post »

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

Similar Threads

C# SQL 2005 Select Statement Help please in C#
ASP + sql - Select statement works intermittently in ASP
How to make this SQL SELECT statement work in ASP.NET in ASP.NET
VB Select Statement Query in Visual Basic 4 / 5 / 6
Hi,Need help on sql select statement structure in MS SQL

alwaysneedhelp

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Oct 2004

Permalink

Nov 29th, 2004

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

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#

Srinivas

srinu

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Aug 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ColdFusion Forum Timeline: where can i get free cf video training

Next Thread in ColdFusion Forum Timeline: Cannot get CF set up on server

DaniWeb Message

Cancel Changes

User Name
Password