I have coldfusion form where I need to update the selected option. So everything is qworking except that is does not update the dataabse
My JS is here
function saveSel (){
if (document.all) {
document.getElementById('r
equirement
s').option
s[document
.getElemen
tById('req
uirements'
).selected
Index].tex
t = document.getElementById('E
ditDIV').v
alue;
// document.getElementById('E
ditDIV').v
alue='';
document.getElementById('E
ditDIV').s
tyle.displ
ay='none';
document.getElementById('m
ainEditor'
).style.di
splay='non
e';
} else {
document.getElementById('r
equirement
s').option
s[document
.getElemen
tById('req
uirements'
).selected
Index].tex
t = document.getElementById('E
ditDIV').v
alue;
// document.getElementById('E
ditDIV').v
alue='';
document.getElementById('E
ditDIV').s
tyle.displ
ay='none';
document.getElementById('m
ainEditor'
).style.di
splay='non
e';
}
<cfif (isDefined("form.EditDIV")
and isDefined("form.prereq2") and isDefined("form.hidden"))>
<cfdump var="#form#">
<cfparam name="form.EditDIV" default="">
<cfparam name="form.prereq2" default="">
<cfparam name="form.hidden" default="">
<cfparam name="requirements" default="">
<cfquery name="updateRequirements" datasource="HotBanana_Mana
ger">
Update trnAcademicProgramRequirem
ents
set requirement= '#HTMLEditFormat(form.Edit
DIV)#', req_prereq='#HTMLEditForma
t(form.pre
req2)#' , hidden='#HTMLEditFormat(fo
rm.hidden)
#'
where reqid = #form.requirements#
</cfquery>
</cfif>
}
And the button is here
<input type="button" name="save" id="save" value="Save" onclick="saveSel();" >
Start Free Trial