CF Upgrade Issue while binding dropdown value to a bind in cfgrid

Question

We are upgrading our CF Server 10 to latest CF 2018. And i am facing bind issue between dropdown selected value and cfgrid bind.

There is dropdown just above the cfgrid that is set empty at first and has values listed of a query, and just below is a grid that binds the dropdown selection value to the query that is fetched.

At first as empty is selected it would not fetch records and grid would be empty. Also the bind URL is correctly formed.

http://127.0.0.1:8501/app/dummy.cfm?&DbFunc=getRecords&SrcID=&newSrcID=&flt_nm=&flt_iv=&flt_ct=&flt_sc=&flt_in=&pageSize=174&_cf_ajaxproxytoken=6D89B1BFAE8D17997E5A&_cf_clientid=1AFC4F973849FBAE6EAAA465492A0E0B&_cf_rc=0&_cf_nodebug=true&_cf_nocache=true&returnFormat=json&_dc=1549690631545&start=0&limit=174&page=1&sortCol=&sortDir=ASC

But next when i select the dropdownto a new value the URL is formed in this way.

http://127.0.0.1:8501/app/dummy.cfm?&&DbFunc=getRecords&SrcID=Test&SrcID=&&newSrcID=Test&&flt_nm=&&flt_iv=&&flt_ct=&&flt_sc=&&flt_in=&pageSize=174&_cf_ajaxproxytoken=6D89B1BFAE8D17997E5A&_cf_clientid=1AFC4F973849FBAE6EAAA465492A0E0B&_cf_rc=0&_cf_nodebug=true&_cf_nocache=true&returnFormat=json&_dc=1549690634739&start=0&limit=174&page=1&sortCol=&sortDir=ASC

As you can see the SrcID is getting appended twice for first time empty and next adding the selected value. I am receiving this as a comma separated value on my next page which is incorrect. the query params are getting added as a separate instead of overwiting the old params.

The SrcID param is defined at top and next is the dropdown and directly at the bottom is the cfgrid where it is used in bind. Thanks in advance

Dave Watts · Answer

You're probably not going to like my answer too much, but I would recommend avoiding the use of CFGRID and other UI stuff that CF has included over the years. Adobe doesn't really keep that stuff up to date, and it generally doesn't work as well as just doing it yourself. CFGRID and CFFORM UI components are really only good for situations where you simply don't know how to do JavaScript UIs yourself.

But maybe that's you (and that's ok, it's not intended as an insult). In the short term, you could file this as a bug, and in the longer term, learn more about JavaScript and UI libraries (not necessarily jQuery, but things like React or Vue or Angular).

Dave Watts, Eidolon LLC

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded