Suppose I have two list box called UM and AM. UM holds the some information like a,b,d,e,g. AM also holds some fixed information like c,f,h,i,j. Note that, the information of AM will be come from another drop down list which holds group1,group2,... etc.; when I select like group1 then AM display like c,f,h,i,j .

User can add or delete any data from the AM list box. If now, I am add a,e,g in to the AM. When I press the button called Save Change then Only the data of AM will update.What's wrong in my code.

Please answer to me as early as possible.




[CODE]
query.cfm
--------------

<cfparam name="url.Id" default="0">
<cfparam name="url.result" default="">
<cfquery name="save" datasource="CMPM">
Update Module
Set ModuleName='<cfoutput>#url.result#</cfoutput>'
Where CustomerId=#url.Id#
</cfquery>
--------------------------

Mahfuz