JSF/MYSQL: How to update your database twice in one selection process?

[aoifeoz]

Hi,

I don't know if this can be done, I am new to all this, so I am asking just in case. Basically I have created a webapp using JSF and MySQL. When a user wants to select an option (using radiobutton because i only want one selection to be possible) I want it to update two columns in my database. Can this be done? I have it working for one but I need it to work for two. If I select one answer it updates the ansCat column, each ansCat has a corresponding sectionID therefore I need both to be updated can this be done inside the code? eg:

<h:selectOneRadio value="#{stuprof.stuprof.ansCat}" >
<f:selectItem
itemValue="True" itemLabel="True" />
(......maybe somewhere in here <f:.....???)

I have asked a similiar query about two values in a datatable and I didnt get a response so I am thinking it is not possible it would be great to know for sure, save me a lot of hassle.
Thanks