Problem in update database

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

the form submission will only carry the selections from the 2nd list box, so maybe nothing is selected......?

Add <cfdump var="#form#"><cfabort> to the top of the query page to confirm that the problem is in your form code. I suspect that the values you think are being posted are actually not. It could be a form or Javascript problem. I'm assuming you must be using Javascript to get the forms to respond to one another.