Ok
If you want to do it like that, you could do something like this
<select>
<option></option>
<cfoutput query="yourQuery" group="GroupID">
<!--- get all the products for the group --->
<cfset tempList = "">
<cfset thisGroup = GroupID>
<cfoutput><cfset tempList = ListAppend(tempList,ProductID)></cfoutput>
<!--- Output the group --->
<option value="#tempList#">Group #thisGroup#</option>
</cfoutput>
</select>
this would give you something like this
<select>
<option></option>
<option value="1,2,3,4">Group 1</option>
<option value="5,6,7">Group 2</option>
<option value="8,9,10,12">Group 3</option>
</select>
is that what your trying to do?
Regards
Steve Onnis
Domain Concept Designs
+61 422 337 685
+61 3 9444 7504
http://www.domainconceptdesigns.com <http://www.domainconceptdesigns.com>
("If you think it can't be done, you haven't asked me!") - Steve Onnis
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Jeremy
Watson
Sent: Friday, January 03, 2003 5:01 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: forms and Lists
Yeah that helped.
Now in Group3 where there are more then one value I want it to pass all
three values through the one select stament. i.e.<option
value="Product3,Product4,Product5 etc">#thisGroup#</option>
OR from what you did it would do it this way...right? Which is what I
don't want to happen.
<option value="Product3">#thisGroup#</option>
<option value="Product4">#thisGroup#</option>
<option value="Product5">#thisGroup#</option>
There has got to be a better way to pass the variables...let me think
about this cause I'm sure there is a more practical way of programming
it.
J.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Toby
Tremayne
Sent: Friday, 3 January 2003 3:46 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: forms and Lists
-----BEGIN PGP SIGNED MESSAGE-----
Hash: MD5
one way would be an associative array - a structure. Let's say you have
a bunch of product groups
group1
group2
group3
group4
all of the groups have only one product in them, except for group3, so
our structure would look like this:
- --------------------------------------------------
stGroups | |
| group1 | product1 |
|----------------------------------------
| group2 | product2 |
|----------------------------------------
| group3 | product3,product4,product5 |
|----------------------------------------
| group4 | product6 |
- --------------------------------------------------
to create your select list you do something like this:
<select name="group" size="1">
<cfloop collection="#stGroups#" item="thisGroup">
<option value="#thisGroup#">#thisGroup#</option>
</cfloop>
and in your receiving page you could extract the data from the structure
like so:
<cflock scope="session" type="readonly" timeout="15">
<cfset customerChoice = session.stGroups[form.group]> </cflock>
that help?
Tboy
Friday, January 3, 2003, 4:30:06 PM, you wrote:
JW> Mmm...That makes a bit more sense...
JW> So let me get this straight....I have a value in a drop down list.
JW> It fires of the value when submitted. Depending on what is submitted
JW> it will then call the list which is stored somewhere else and
JW> execute the next part....I had thought of using an array just didn't
JW> know the best way of doing this...
JW> Thanks again!
JW> jeremy
JW> -----Original Message-----
JW> From: [EMAIL PROTECTED]
JW> [mailto:[EMAIL PROTECTED]] On Behalf Of Toby
JW> Tremayne
JW> Sent: Friday, 3 January 2003 3:21 PM
JW> To: CFAussie Mailing List
JW> Subject: [cfaussie] RE: forms and Lists
JW> -----BEGIN PGP SIGNED MESSAGE-----
JW> Hash: MD5
JW> just a thought, but if the user doesn't need to see them then do
JW> they need to be there? Are they only generated during the load of
JW> this page or are these lists within lists stored somewhere else? If
JW> they're stored somewhere else, I'd advise at the very least that you
JW> create a structure or array within memory (session scope perhaps)
JW> and bung the list in there, so you can link to the entire list
JW> according to the choice the user makes.
JW> Toby
JW> Friday, January 3, 2003, 4:08:54 PM, you wrote:
JW>> Yes sorta,
JW>> But I would like the lower levels to be hidden from the user but
JW>> still pass the values. Make sense...? Believe it or not there is a
JW>> method to my madness I just need to figure out the method.
JW>> i.e.
JW>> Level 1
JW>> Level 1.1 (hidden)
JW>> Level 1.2 (hidden)
JW>> etc etc etc
JW>> I need to think of a better way of sending multiple variables via a
JW>> form....then do an action after that for each sub variable
JW>> sent.....
JW>> oh boy...I think I need to rethink this...
JW>> J.
JW>> -----Original Message-----
JW>> From: [EMAIL PROTECTED]
JW>> [mailto:[EMAIL PROTECTED]] On Behalf Of Steve
JW>> Onnis
JW>> Sent: Friday, 3 January 2003 2:52 PM
JW>> To: CFAussie Mailing List
JW>> Subject: [cfaussie] RE: forms and Lists
JW>> Is it like you want to display the tree in the select box?
JW>> like
JW>> level 1
JW>> level 1.1
JW>> level 1.2
JW>> level 2
JW>> level 2.1
JW>> level 2.2
JW>> level 2.3
JW>> level 2.4
JW>> level 2.5
JW>> like that?
JW>> Regards
JW>> Steve Onnis
JW>> Domain Concept Designs
JW>> +61 422 337 685
JW>> +61 3 9431 4249
JW>> <http://www.domainconceptdesigns.com/>
JW>> http://www.domainconceptdesigns.com
JW>> <mailto:[EMAIL PROTECTED]>
JW>> [EMAIL PROTECTED]
JW>> <http://www.domainconceptdesigns.com/images/blank.gif>
JW>> <http://www.cfcentral.com.au/> http://www.cfcentral.com.au
JW>> <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
JW>> <http://www.domainconceptdesigns.com/email_signatures/mail_dcd_logo
JW>> .
JW>> jpg>
JW>> <http://www.domainconceptdesigns.com/email_signatures/bolt.gif>
JW>> ("If you think it can't be done, you haven't asked me!") - Steve
JW>> Onnis
JW>> -----Original Message-----
JW>> From: [EMAIL PROTECTED]
JW>> [mailto:[EMAIL PROTECTED]]On Behalf Of Jeremy
JW>> Watson
JW>> Sent: Friday, January 03, 2003 3:47 PM
JW>> To: CFAussie Mailing List
JW>> Subject: [cfaussie] RE: forms and Lists
JW>> I've lost me too....what the hell was I trying to say....let me
JW>> rethink this and I'll get back to you...I want to have multiple
JW>> values I think.
JW>> -----Original Message-----
JW>> From: [EMAIL PROTECTED]
JW>> [mailto:[EMAIL PROTECTED]] On Behalf Of Steve
JW>> Onnis
JW>> Sent: Friday, 3 January 2003 2:43 PM
JW>> To: CFAussie Mailing List
JW>> Subject: [cfaussie] RE: forms and Lists
JW>> You have lost me
JW>> Regards
JW>> Steve Onnis
JW>> Domain Concept Designs
JW>> +61 422 337 685
JW>> +61 3 9431 4249
JW>> <http://www.domainconceptdesigns.com/>
JW>> http://www.domainconceptdesigns.com
JW>> <mailto:[EMAIL PROTECTED]>
JW>> [EMAIL PROTECTED]
JW>> <http://www.domainconceptdesigns.com/images/blank.gif>
JW>> <http://www.cfcentral.com.au/> http://www.cfcentral.com.au
JW>> <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
JW>> <http://www.domainconceptdesigns.com/email_signatures/mail_dcd_logo
JW>> .
JW>> jpg>
JW>> <http://www.domainconceptdesigns.com/email_signatures/bolt.gif>
JW>> ("If you think it can't be done, you haven't asked me!") - Steve
JW>> Onnis
JW>> -----Original Message-----
JW>> From: [EMAIL PROTECTED]
JW>> [mailto:[EMAIL PROTECTED]]On Behalf Of Jeremy
JW>> Watson
JW>> Sent: Friday, January 03, 2003 10:55 AM
JW>> To: CFAussie Mailing List
JW>> Subject: [cfaussie] forms and Lists
JW>> Hey,
JW>> I have an idea and I'm not sure how to go about it. Or even if it
JW>> is
JW>> possible.
JW>> 1. I have a form and a drop down list containing a list. 2. now in
JW>> this group there could be a number of variables within it.
JW>> Example:
JW>> Var 1
JW>> Var 2
JW>> Var 3
JW>> --------
JW>> Var 4 (Group) (with a single value)
JW>> Now when Var 4 is passed there is a list within it
JW>> Example:
JW>> Var 4
JW>> var 1
JW>> var 2
JW>> var 3
JW>> I'm thinking of using array to list function but has anyone come
JW>> across doing such a wild and crazy coding.
JW>> Regards,
JW>> Jeremy Watson
JW>> ColdFusion Web Developer
JW>> BLA
JW>> Bob Littler Agencies Pty Ltd
JW>> 45 Aquarium Avenue
JW>> Hemmant, Queensland 4174
JW>> Phone: 07 3890 0122
JW>> Fax: 07 3890 5388
JW>> www.bla.com.au <http://www.bla.com.au/> www.humminbird.com.au
JW>> <http://www.humminbird.com.au/> www.minnkota.com.au
JW>> <http://www.minnkota.com.au/>
JW>> ****************************************************************
JW>> This e-mail, together with any attachments, is intended for the
JW>> named recipient(s) only. If you have received this message in
JW>> error,
JW>> you are asked to inform the sender as quickly as possible and
JW>> delete
JW>> this message and any copies of this message from your computer
JW>> system network.
JW>> Any form of disclosure, modification, distribution and/or
JW>> publication of this e-mail message is prohibited. Unless otherwise
JW>> stated, this e-mail represents only the views of the sender and not
JW>> the views of the Bob Littler Agencies Pty Ltd
JW>> ****************************************************************
JW>> ---
JW>> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
JW>> To
JW>> unsubscribe send a blank email to
JW>> [EMAIL PROTECTED]
JW>> MX Downunder AsiaPac DevCon - http://mxdu.com/
JW>> ---
JW>> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To
JW>> unsubscribe send a blank email to
JW>> [EMAIL PROTECTED]
JW>> MX Downunder AsiaPac DevCon - http://mxdu.com/
JW>> ---
JW>> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
JW>> To
JW>> unsubscribe send a blank email to
JW>> [EMAIL PROTECTED]
JW>> MX Downunder AsiaPac DevCon - http://mxdu.com/
JW>> ---
JW>> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To
JW>> unsubscribe send a blank email to
JW>> [EMAIL PROTECTED]
JW>> MX Downunder AsiaPac DevCon - http://mxdu.com/
JW>> ---
JW>> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To
JW>> unsubscribe send a blank email to
JW>> [EMAIL PROTECTED]
JW>> MX Downunder AsiaPac DevCon - http://mxdu.com/
JW> ---------------------------------------
JW> Life is poetry -
JW> write it in your own words.
JW> ---------------------------------------
JW> Toby Tremayne
JW> Technical Team Lead
JW> Code Poet and Zen Master of the Heavy Sleep
JW> Toll Solutions
JW> 154 Moray St
JW> Sth Melbourne
JW> VIC 3205
JW> +61 3 9697 2317
JW> 0416 048 090
JW> ICQ: 13107913
JW> -----BEGIN PGP SIGNATURE-----
JW> Version: 2.6
JW> iQCVAwUAPhUdrEYhrxxXvPlFAQEyHQQAg88q1RzN9dCeoDldiE29SXCG4kvoPukz
JW> vA5b6VShBfJUS6RUG9NORf2xnU1OF8B1Qqj/vWWs15I2xBPRJt5qw5kmEhIdiDpB
JW> 5BItFm9pbNZOhPvcrTjoFS6tNVFbvDi/1BKQ73/EoJZe/6cRQ6uWXhhOBH7IYCwH
JW> I4e7HFQpQZU=
JW> =ZQfb
JW> -----END PGP SIGNATURE-----
JW> ---
JW> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To
JW> unsubscribe send a blank email to
JW> [EMAIL PROTECTED]
JW> MX Downunder AsiaPac DevCon - http://mxdu.com/
JW> ---
JW> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To
JW> unsubscribe send a blank email to
JW> [EMAIL PROTECTED]
JW> MX Downunder AsiaPac DevCon - http://mxdu.com/
---------------------------------------
Life is poetry -
write it in your own words.
---------------------------------------
Toby Tremayne
Technical Team Lead
Code Poet and Zen Master of the Heavy Sleep
Toll Solutions
154 Moray St
Sth Melbourne
VIC 3205
+61 3 9697 2317
0416 048 090
ICQ: 13107913
-----BEGIN PGP SIGNATURE-----
Version: 2.6
iQCVAwUAPhUjkkYhrxxXvPlFAQEXpQP9GO02Hj8Dx7euP45IEboXZC43tkCM9Ih6
xUm5uQEyZs5bWXd6hkbAn9Z9pyVhKusOROqdlnf7B9P9l+IHlBtxyihWpJRbojTh
ZtBo9fP7QTP4md4LtOjK3s/lRjdNb3T9mC6fJ0+tonM3nR+U4oQT0UU1zD6ibUnY
T1Xkkcc5QBs=
=uy7W
-----END PGP SIGNATURE-----
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To
unsubscribe send a blank email to
[EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/