Hi there
I am developing a website for a professional services firm (a small law firm).
One thing the firm wants is the following:
They want to display details of partners and staff and also indicate specialist
areas that staff work in.
In summary I am using the following code:
First the query to get the various practice areas
<cfquery name="qGetPracticeAreas" datasource="#request.db_dsn#"
username="#request.db_login#" password="#request.db_pwd#"> select * from
tbl_practiceareas order by practicearea </cfquery>
<cfparam name="form.practicearea" default="0">
<select name="practicearea" size="4" multiple="multiple"> <option value="0"
selected="selected">Please Select <cfoutput query="qgetpracticeareas">
<option value="#practiceid#" <cfif form.practicearea Is
practiceid>selected</cfif>>
#practicearea# </cfoutput>
</select>
This should allow me to make the selection(s) as appropriate and then save the
data, along with details of the person etc.
I will probably save the selected practice areas in one field probably as a
string.
Now the big question.
I may want to modify the details for a staff member at some stage down the
track.
I would want to display all options which are available, but I would also want
to show those practiceareas which the person already has selected.
I'm stumped on this one at present so any feedback tips on how to do would be
greatfully appreciated.
Regards & thanks in advance
Peter
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261591
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
