[Pansophy] Problem with Projects/L2HE/CavPerfReport.cfm

[Mike Dickey]

Hi Megan & Valerie,

I was looking into the problem we have been having with Projects/L2HE/CavPerfReport and I think I may have found an issue in the Projects/L2HE/CavPerfGrid.cfm file at ~ line 26.

<cfset flds = #right(flds, len(flds) - find(".",flds))#>

This line was intended to remove the 'table' from 'table.field' notation.  To deal with the CLOBs, we introduced the 'dbms_lob.substr(...' oracle function to the 'GridFieldNames' string, which is processed by the line above.

I will see what I can do today, but I have a doctor appointment on Monday, and won't be back until Tuesday.

I wanted you to know what I found, in case I can't fix it today.

Mike Dickey
SRF Inventory Technician
Jefferson Lab
12000 Jefferson Ave
Newport News, VA 23606
(757) 269-7755

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20211029/c9c9150d/attachment-0001.html>