The first one.
I want to select CATCHMENT' from the drop down, then select the group of returned LOCATIONS and then display a concetated string of data (related to the LOCATION) from five other fields in a display area.
Jas
At 11:16 AM 21/05/2004, you wrote:
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
16/101 Locomotive Workshop | Australian Technology Park | Eveleigh | NSW 1430
T: +61 2 8374 5050 | F: +61 2 8374 5060 | E: [EMAIL PROTECTED]
--------------------------------------------------------------------------------------
LONDON/MANCHESTER/SYDNEY
www.readingroom.com.au
Ranked 5th in UK - Digital Media, Design High Flyers (Design Week 2004)
Most Respected Agency 2003 Top 10 [New Media Age]
Winner Charity and Voluntary Sector - raceforlife.org (NMA Effectiveness Awards 2004)
Best Tax Site � taxfac.co.uk (Butterworths Tolley Awards 2003)
Best UK Design Agency (Webspace Awards 2002)
Best B2C eCommerce Site� thetrainline.com (Webspace Awards 2002)
The information transmitted is intended only for the person or entity to which it is addressed
and may contain confidential and/or privileged material. Any review, re-transmission,
dissemination or other use of, or taking of any action in reliance upon, this information by
persons or entities other than the intended recipient is prohibited.
If you are not the intended recipient please notify us by telephone immediately
on 02 8374 5050 or return it to us via e-mail. Please then delete it from your system.
---
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
