Issue with ColdFusion 2016 CFGrid update function -
this has worked fine many versions prior. after update coldfusion 2016, cfgrid produces error when trying update cell active status 2 3 item.
user updates cell , hits enter, refreshes grid , sees change not stored. cfdebug error ajax logger cfgridchanged undefined. suggestions on how make work in coldfusion 2016?
<cfgrid name="modify_pids"      height=525     autowidth="yes"     width=1040     vspace=10     selectmode="edit"     insert="no"     delete="no"             format="html"     selectonload = "no"     striperows = "yes"     selectcolor="cde6f3"     preservepageonsort="yes"     pagesize=100     sort=true     onchange="cfc:functions_pids.updatepid({cfgridaction},{cfgridrow},                        {cfgridchanged}, '#getcurruser.uid#')"     bind="cfc:functions_pids.getpids({cfgridpage},{cfgridpagesize},    {cfgridsortcolumn},{cfgridsortdirection}, '#mygridsortcolumn#', searchpid(),     searchdesc(), searchstat(), searchmoq(), searchcost(), searchunit(),     searchmodby(), searchmoddate() )">  <cfgridcolumn name="pid_id"         header="pid"         width=40         headeralign="center"         headerbold="yes"         select="no">     <cfgridcolumn name="description"         header="description"         width=150         headeralign="center"         headerbold="yes"         select="yes">      <cfgridcolumn name="active_status"         header="status<br>active=1,3<br>inactive=2"         width=35         headeralign="center"         headerbold="yes"         select="yes"         display="yes">        <cfgridcolumn name="moq"         header="moq"         width=20         headeralign="center"         headerbold="yes"         select="yes">       <cfgridcolumn name="cost"         header="cost"         width=40         headeralign="center"         headerbold="yes"         select="yes">       <cfgridcolumn name="unit"         header="unit"         width=40         headeralign="center"         headerbold="yes"         select="yes">      <cfgridcolumn name="modify"         header="modified by"         width=50         headeralign="center"         headerbold="no"         select="no">      <cfgridcolumn name="modify_date"         header="modified date"         width=60         headeralign="center"         headerbold="yes"         select="no"         type="date">      <cfgridcolumn name="pid_used"         header="inventory<br>instances"         width=50         headeralign="center"         headerbold="no"         select="no">          <cfgridcolumn name="inventory_sum"         header="inventory<br>total"         width=50         headeralign="center"         headerbold="no"         select="no">       </cfgrid>   the section functions_pids.cfc
<cffunction name="updatepid" access="remote" output="false">      <cfargument name="cfgridaction">     <cfargument name="cfgridrow">     <cfargument name="cfgridchanged">              <cfargument name="getcurruser"> <!--- pass in modified user id --->     <cfargument name="pid_id" required="no" type="string" default="" >      <cfset strctkey=structkeyarray(cfgridchanged) />     <cfset strctval=structfindkey(cfgridchanged, strctkey[1]) />     <cfset strctval=strctval[1] />      <cfif cfgridaction "d">    <cfelseif cfgridaction "u">       <cfquery name="update" datasource="#request.dbname#" username="#request.dbuser#" password="#request.dbpw#">       update pids       set #strctkey[1]# = '#strctval.value#',       modify = '#getcurruser#',       modify_date =  '#dateformat(createodbcdatetime( now()), "mm/dd/yyyy")#'       pid_id = '#cfgridrow.pid_id#'     </cfquery>    <cfelseif cfgridaction "i">     </cfif>    <cfreturn />  </cffunction>      
promoted comments
which update did apply when broke? know adobe released update couple of days ago - update 5. update includes changes cfgrid ajax functionality. bugs fixed in coldfusion (2016 release) update 5
bugs fixed in coldfusion (2016 release) update 5
bug id description component cf-4198947 cfgrid scripting options not work expected. ajax : ui components cf-4198855 cfquery requests result in following error message: access denied ("java.io.filepermission" "c:\coldfusion2016\cfusion\wwwroot\web-inf\classes\macromedia\sqlserverutil\userdefaults.properties" "read") database cf-4198854 piechart not displayed 1 item (100%). charting/graphing cf-4198761 on linux os, cfdocument not generate chart in pdf. document management : pdf generation cf-4198817 cfquery returns cached results when cachedafter date updated after date of original cached query date, still past date. database : cfquery cf-4198816 changes cached query results persisted cache. database : cfquery cf-4198764 when loading template first time, template displays cftoken, however, second refresh token disappears. core runtime : session management cf-4198589 method invocation through ajaxproxy fails if required arguments passed. ajax : plumbing cf-4198570 datefield attribute in cfinput not display value of attribute. cfform : html cf-4198559 elvis operator fails when used argument scope. core runtime cf-4198513 cache not updated expected. caching cf-4195407 cfinput type="datefield" generates invalid html code. cfform cf-4182090 when sandbox security enabled, unable connect sql server. security
Comments
Post a Comment