<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Georgia;
panose-1:2 4 5 2 5 4 5 2 3 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
span.EmailStyle27
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Bobby,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I appreciate the information and the encouragement. <o:p></o:p></p>
<p class="MsoNormal">It has been on my radar for awhile now and Megan and Matt are working on updating all of our Data Mining code where so much of that stuff is being used.<o:p></o:p></p>
<p class="MsoNormal">And I appreciate letting us know what you use for the replacement. I have been researching best practices and learning what I can to make the move.<o:p></o:p></p>
<p class="MsoNormal">Funny, I was just reading the deprecated-features page to see what priorities we need to put in place.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank You again for the information. Hopefully, we can reach out if we get stuck.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:#1F497D">Valerie Bookwalter</span><span style="font-size:12.0pt;color:#1F497D;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:#1F497D">Jefferson Lab, ACC<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:#1F497D">SRF Operations<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:#1F497D">SRFOPS Software Systems Group<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:#1F497D">1-757-269-5802 (OFFICE – currently working offsite)<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="mso-ligatures:none">From:</span></b><span style="mso-ligatures:none"> Bobby Lawrence <robertl@jlab.org>
<br>
<b>Sent:</b> Tuesday, October 10, 2023 10:54 AM<br>
<b>To:</b> Mike Dickey <mdickey@jlab.org><br>
<b>Cc:</b> Valerie Bookwalter <bookwalt@jlab.org>; Dana Cochran <cochran@jlab.org><br>
<b>Subject:</b> RE: CFGrid - Strange Error Message<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">FYI – <br>
I know you may not want to hear it, but its probably for the best that you guys stop using CFGRID (and most of the CF UI tags). I know your codebase is littered with it, but its really more of a headache than anything else and basically ties you to Adobe ColdFusion,
meaning that you can’t ever move to another CFML implementation (like the free, open source one that is so popular: Lucee).
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Being tied to Adobe ColdFusion means you are at the mercy of Adobe and have to pay whatever licensing fee’s they demand. For CF2021, Adobe changed the licensing which ended up drastically increasing the cost for a lot of companies and
it caused a lot of complaints in the developer community (<a href="https://community.adobe.com/t5/coldfusion-discussions/coldfusion-2021-licensing-gone-mad/td-p/13186354">https://community.adobe.com/t5/coldfusion-discussions/coldfusion-2021-licensing-gone-mad/td-p/13186354</a>).
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">In addition, Adobe is constantly deprecating their UI tags (<a href="https://helpx.adobe.com/coldfusion/deprecated-features.html">https://helpx.adobe.com/coldfusion/deprecated-features.html</a>) and even though CFGRID isn’t deprecated yet,
it could be in the future. If/when this happens, none of your CFGRID code will work on the newer ColdFusion version so you wont be able to upgrade. Then you’ll be stuck on the old, unsupported version (something Cybersecurity may not like) until you fix
all your code.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I would implore you guys to start moving away from the CF UI tags and start using JQuery. You may have a little more work to do up front because you have to write a bit more Javascript, but this will make you better developers in the end.<o:p></o:p></p>
<p class="MsoNormal">Here is a link to a site which gives you examples of how to replace your CF UI tag with a JQuery equivalent:<br>
<a href="https://github.com/cfjedimaster/ColdFusion-UI-the-Right-Way">https://github.com/cfjedimaster/ColdFusion-UI-the-Right-Way</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This one in particular shows you how to use JQuery datatables instead of CFGRID:<o:p></o:p></p>
<p class="MsoNormal"><a href="https://github.com/cfjedimaster/ColdFusion-UI-the-Right-Way/blob/master/chapters/cfgrid/index.md">https://github.com/cfjedimaster/ColdFusion-UI-the-Right-Way/blob/master/chapters/cfgrid/index.md</a>
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-left:.5in"><b><span style="mso-ligatures:none">From:</span></b><span style="mso-ligatures:none"> Bobby Lawrence
<br>
<b>Sent:</b> Monday, October 09, 2023 4:52 PM<br>
<b>To:</b> Mike Dickey <<a href="mailto:mdickey@JLAB.ORG">mdickey@JLAB.ORG</a>><br>
<b>Cc:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Subject:</b> RE: CFGrid - Strange Error Message<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Ok – so I have no idea why, but the problem was the “order by” clause of your “Grade” query in VendorQA.cfc<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">For whatever reason, when the column names in that clause were prefixed by the ‘table name’ (really the query name), this ended up adding more columns to the in-memory query result, which then resulted in this strange
error. <o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">I changed that clause from:<br>
<b>Order by P_SNs.Acronym, P_SNs.PONumber, P_SNs.VendorName, P_SNs.partnumber</b><br>
to:<br>
<b>Order by Acronym, PONumber, VendorName, partnumber</b> <o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">And the error disappeared.<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">I’m sure there is a CF bug somewhere that is causing all of this, but without a repeatable test case, we can’t really complain to Adobe.<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Looks like all this query-of-queries business is caused by the fact that you cannot query between your databases. Have you guys looked into database links?<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-left:1.0in"><b><span style="mso-ligatures:none">From:</span></b><span style="mso-ligatures:none"> Mike Dickey <<a href="mailto:mdickey@jlab.org">mdickey@jlab.org</a>>
<br>
<b>Sent:</b> Monday, October 09, 2023 2:01 PM<br>
<b>To:</b> Bobby Lawrence <<a href="mailto:robertl@jlab.org">robertl@jlab.org</a>><br>
<b>Cc:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Subject:</b> RE: CFGrid - Strange Error Message<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:1.0in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:14.0pt;font-family:Consolas;color:#1F497D">Hi Bobby,<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:14.0pt;font-family:Consolas;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:14.0pt;font-family:Consolas;color:#1F497D">Also, I have been using “L2PRD” for testing. I should return 39 records in Dev.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:14.0pt;font-family:Consolas;color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:12.0pt;font-family:Consolas;color:black;mso-ligatures:none">Mike Dickey<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:12.0pt;font-family:Consolas;color:black;mso-ligatures:none">SRF Inventory Technician<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:12.0pt;font-family:Consolas;color:black;mso-ligatures:none">Jefferson Lab<br>
12000 Jefferson Ave<br>
Newport News, VA 23606<br>
(757) 269-7755</span><span style="font-size:12.0pt;font-family:Consolas;color:#1F497D;mso-ligatures:none"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:14.0pt;font-family:Consolas;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-left:1.0in"><b><span style="mso-ligatures:none">From:</span></b><span style="mso-ligatures:none"> Bobby Lawrence <<a href="mailto:robertl@jlab.org">robertl@jlab.org</a>>
<br>
<b>Sent:</b> Monday, October 9, 2023 1:34 PM<br>
<b>To:</b> Mike Dickey <<a href="mailto:mdickey@jlab.org">mdickey@jlab.org</a>><br>
<b>Cc:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Subject:</b> RE: CFGrid - Strange Error Message<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:1.0in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:1.0in">What is the error you are seeing? Can you point me to a page where its happening?<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-left:1.5in"><b><span style="mso-ligatures:none">From:</span></b><span style="mso-ligatures:none"> Mike Dickey <<a href="mailto:mdickey@jlab.org">mdickey@jlab.org</a>>
<br>
<b>Sent:</b> Monday, October 09, 2023 12:51 PM<br>
<b>To:</b> Bobby Lawrence <<a href="mailto:robertl@jlab.org">robertl@jlab.org</a>><br>
<b>Cc:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Subject:</b> RE: CFGrid - Strange Error Message<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:1.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:1.5in"><span style="font-size:14.0pt;font-family:Consolas;color:#1F497D">Hi Bobby,<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.5in"><span style="font-size:14.0pt;font-family:Consolas;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:1.5in"><span style="font-size:14.0pt;font-family:Consolas;color:#1F497D">Nope, same error.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.5in"><span style="font-size:14.0pt;font-family:Consolas;color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal" style="margin-left:1.5in"><span style="font-size:12.0pt;font-family:Consolas;color:black;mso-ligatures:none">Mike Dickey<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.5in"><span style="font-size:12.0pt;font-family:Consolas;color:black;mso-ligatures:none">SRF Inventory Technician<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.5in"><span style="font-size:12.0pt;font-family:Consolas;color:black;mso-ligatures:none">Jefferson Lab<br>
12000 Jefferson Ave<br>
Newport News, VA 23606<br>
(757) 269-7755</span><span style="font-size:12.0pt;font-family:Consolas;color:#1F497D;mso-ligatures:none"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:1.5in"><span style="font-size:14.0pt;font-family:Consolas;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-left:1.5in"><b><span style="mso-ligatures:none">From:</span></b><span style="mso-ligatures:none"> Bobby Lawrence <<a href="mailto:robertl@jlab.org">robertl@jlab.org</a>>
<br>
<b>Sent:</b> Monday, October 9, 2023 11:44 AM<br>
<b>To:</b> Mike Dickey <<a href="mailto:mdickey@jlab.org">mdickey@jlab.org</a>><br>
<b>Cc:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Subject:</b> RE: CFGrid - Strange Error Message<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:1.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:1.5in">Ok – should be applied. Give it a test<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.5in"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-left:2.0in"><b><span style="mso-ligatures:none">From:</span></b><span style="mso-ligatures:none"> Mike Dickey <<a href="mailto:mdickey@jlab.org">mdickey@jlab.org</a>>
<br>
<b>Sent:</b> Monday, October 09, 2023 11:33 AM<br>
<b>To:</b> Bobby Lawrence <<a href="mailto:robertl@jlab.org">robertl@jlab.org</a>><br>
<b>Cc:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Subject:</b> RE: CFGrid - Strange Error Message<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:2.0in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:14.0pt;font-family:Consolas;color:#1F497D">Awesome, will do.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:14.0pt;font-family:Consolas;color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:12.0pt;font-family:Consolas;color:black;mso-ligatures:none">Mike Dickey<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:12.0pt;font-family:Consolas;color:black;mso-ligatures:none">SRF Inventory Technician<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:12.0pt;font-family:Consolas;color:black;mso-ligatures:none">Jefferson Lab<br>
12000 Jefferson Ave<br>
Newport News, VA 23606<br>
(757) 269-7755</span><span style="font-size:12.0pt;font-family:Consolas;color:#1F497D;mso-ligatures:none"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:14.0pt;font-family:Consolas;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-left:2.0in"><b><span style="mso-ligatures:none">From:</span></b><span style="mso-ligatures:none"> Bobby Lawrence <<a href="mailto:robertl@jlab.org">robertl@jlab.org</a>>
<br>
<b>Sent:</b> Monday, October 9, 2023 11:31 AM<br>
<b>To:</b> Mike Dickey <<a href="mailto:mdickey@jlab.org">mdickey@jlab.org</a>><br>
<b>Cc:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Subject:</b> RE: CFGrid - Strange Error Message<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:2.0in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:2.0in">We actually had this same problem last year and got the hot fix. I’ll apply it to pansophydev and you can test…<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:2.0in"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-left:2.0in"><b><span style="mso-ligatures:none">From:</span></b><span style="mso-ligatures:none"> Mike Dickey <<a href="mailto:mdickey@jlab.org">mdickey@jlab.org</a>>
<br>
<b>Sent:</b> Monday, October 09, 2023 11:23 AM<br>
<b>To:</b> Bobby Lawrence <<a href="mailto:robertl@jlab.org">robertl@jlab.org</a>><br>
<b>Cc:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Subject:</b> CFGrid - Strange Error Message<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:2.0in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:14.0pt;font-family:Consolas">Hi Bobby,<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:14.0pt;font-family:Consolas">We got a strange error message using a CFGrid with a QoQ.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:14.0pt;font-family:Consolas">After doing some Google searching, Valerie & I think we may have found a fix from Adobe.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:14.0pt;font-family:Consolas"><a href="https://community.adobe.com/t5/coldfusion-discussions/coldfusion-2021-release-and-coldfusion-2018-release-september-updates/m-p/12385986/page/2#M189855">https://community.adobe.com/t5/coldfusion-discussions/coldfusion-2021-release-and-coldfusion-2018-release-september-updates/m-p/12385986/page/2#M189855</a><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:14.0pt;font-family:Consolas">Would you contact
<a href="mailto:cfsup@adobe.com">cfsup@adobe.com</a> to see if you can get the fix and install it.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:14.0pt;font-family:Consolas">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:12.0pt;font-family:Consolas;color:black;mso-ligatures:none">Mike Dickey<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:12.0pt;font-family:Consolas;color:black;mso-ligatures:none">SRF Inventory Technician<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:2.0in"><span style="font-size:12.0pt;font-family:Consolas;color:black;mso-ligatures:none">Jefferson Lab<br>
12000 Jefferson Ave<br>
Newport News, VA 23606<br>
(757) 269-7755</span><span style="font-size:12.0pt;font-family:Consolas;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:2.5in"><o:p> </o:p></p>
</div>
</body>
</html>