rogue line prevented compilation; no error reported

[Chris Norloff]

Here's an interesting error we got that took a while to figure out. A file was being updated but was not displaying on the DEV server.

The problem was a rogue line, outside of the cfif statement -
<cfelseif client.clt_permit_type EQ "BR"> (see below)

That kept the file from being successfully compiled. CFMX used the previously existing .class file if one is there. If a .class file wasn't there, CFMX reported that it couldn't find the .cfm file.

'nother lesson learned,
Chris Norloff
CFMX 6.1 on WebSphere App Server v5.0.2.1, Solaris 8, Oracle 9i

<cfif NOT variables.isPeriodical>
<!--- Get annual fees, plus BR monthly and quarterly --->
<cfset request.queryname = "get_permitlist">
<cfquery name="get_permitlist" datasource="#request.DSN#">
SELECT p.permit_type as permit_type,
    p.fee_category as fee_category,
    p.fee_type_code as fee_type_code,
    c.code_desc as fee_description,
    p.fee_amt as fee_amt,
    p.fee_level as fee_level,
    p.aic as aic
FROM        p_permit_fee_ref p, p_code_ref c
    WHERE p.permit_type = '#client.clt_permit_type#'
  AND       p.end_date IS NULL
  AND p.fee_type_code = c.code_name
<cfif client.clt_permit_type EQ "PI">
  AND       p.fee_type_code <> 'IA'
<cfelseif client.clt_permit_type EQ "BR">
#PreserveSingleQuotes(variables.brtype)#
</cfif>
  AND       c.code_grp = 'FC'
                  <cfelseif client.clt_permit_type EQ "BR">
ORDER BY c.code_order,p.fee_level, p.fee_type_code
</cfquery>
</cfif>

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---