DOH! I had a typo in the code
that's standard procedure for me. 10% of my time is spent hunting
typographical errors
anyway, here ya go....
<!---checking them agains a list of users associated with the current
project --->
<!--- if they are found in the list, select them --->
<cfselect name="user_id" size="5" multiple="Yes">
<cfloop query="getallusers">
<option value="#user_id#"<cfif listfind(valuelist(proj_users.user_id),
user_id, ",")> selected</cfif>#fname# #lname#</option>
</cfloop>
</cfselect>
----- Original Message -----
From: "Ewok" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 23, 2003 5:46 PM
Subject: Re: Multiple Select Box
> <!---I have a tool that you can add multiple users to a project via a
> multiple select box
> First I get all user_ids associated with the project i want--->
>
> <!--- get all users associated with current project --->
> <cfquery name="proj_users" datasource="#request.maindsn#">
> select user_id
> from tbl_projects
> where proj_id = #val(form.project_id)#
> </cfquery>
>
>
> <!---And from a table of ALL users that are available to choose from I get
> ALL entries--->
>
> <!--- get ALL users to populate the select box --->
> <cfquery name="getallusers" datasource="#request.maindsn#">
> select fname, lname, user_id
> from tbl_proj_users
> order by lname
> </cfquery>
>
>
> <!--- then loop over ALL availabel users to populate the select box --->
> <!---checking them agains a list of users associated with the current
> project --->
> <!--- if they are found in the list, select them --->
> <cfselect name="user_id" size="5" multiple="Yes">
> <cfloop query="getallusers">
> <option value="#user_id#"cfif listfind(valuelist(proj_users.user_id),
> user_id, ",")> selected</cfif>#fname# #lname#</option>
> </cfloop>
> </cfselect>
>
>
> Hope it helps, goodluck
>
> ----- Original Message -----
> From: "Michael Ross" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, January 23, 2003 1:59 PM
> Subject: Multiple Select Box
>
>
> > You know if you have a form that someone is editing data, and you can
make
> a select box have a record selected. How do you do it where you want a
> multiple select box to have a lot of them selected? This is really
killing
> me..... Any idea's would be great
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
