This is more of a coldfusion questions for another list. One way to do that, if I understand you correctly, is to create a page that simply uses #form.yourfield# in the query.
The action part of your form would point to another page that contains something like this: <CFQUERY name="myquery"> Select * from mytable where id = #form.yourfield# </CFQUERY> <CFOUTPUT query="myquery> #field1#, #field2# </CFOUTPUT> You could also use a cfdiv to display this newly created ajax and bind it to the cfselect making it load without a new page having to come up. HTH On 8/29/07, Paul Smith <[EMAIL PROTECTED]> wrote: > Using MYSQL 5.0, CF8 & Dreamweaver CS3 > > Ok so thanks to Brian my CFSelect box now contains DISTINCT data (cheers!) > > Now I need to display all records that contain the selection from that > CFSelect box > > what I don't know is how and where the CFSelect returns the data chosen and > also how to create a SQL to incorporate that selection to then display the > data I want. > > Like I said i'm a newbie and a thick one at that :( > > I do think once this bit is sorted I should be able to complete my little > project so any help is greatly appreciated. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2921 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
