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

Popular posts from this blog

ZeroMQ on Windows, with Qt Creator -

unity3d - Unity SceneManager.LoadScene quits application -

python - Error while using APScheduler: 'NoneType' object has no attribute 'now' -