Jason
I was in the process of writing an answer to your post when I thought that I'd better clarify a couple of facts about your application.
Looking at the example that you give for the queries/tables, are you:
1. Writing a query to retrieve a recordset containing one column called "CATCHMENT" with no additional primary key. Then populating a combobox with that recordset.
I'm assuming that you then want to react to someone selecting an option from the combobox that you want to filter by. Meaning that you want to pass back the "CATCHMENT" value in a call to the CFC so that you can run a second query to retrieve a filtered set of data that returns the "LOCATIONS" for that criteria and populate a listbox.
OR
2. Running one query, retrieving all records from the two columns "CATCHMENT" & "LOCATIONS", fetch that from the CFC via remoting and populate a combobox with each unique "CATCHMENT" value, then populate a listbox with all the "LOCATIONS" values for the current values selected in the combobox.
Andrew
Jason Davey wrote:
Hi,
The combobox and listbox issue I have I know is simple but doing my head in...
- simple MySQL db with columns 'CATCHMENT' (this goes into combobox = sorted)
- column 'LOCATIONS' (several locations to one CATCHMENT) - this to go in the listbox depending on which CATCHMENT is selected.
I know my .cfc is wrong - can you steer me to a simple eg.
Regards Jason
-- Andrew Muller Senior Macromedia Certified Instructor - ColdFusion, Flash Macromedia Certified Developer - ColdFusion, Flash NSW CFUG Manager
Daemon Internet Consultants - http://www.daemon.com.au/training 17 Roslyn Gardens Elizabeth Bay NSW 2011 AUSTRALIA T:61 2 9380 4162 F:61 2 9380 4204
Daemon: Serious Web Development
MXDU: The AsiaPac Macromedia Devcon http://www.mxdu.com/
--- You are currently subscribed to fugli as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
