Skip to content

Fixinator 5.0.1 saying dbtype attribute of cfquery was removed in Coldfusion 11 #20

@wandmdave

Description

@wandmdave

I was checking out the new goals feature of fixinator on some old code I've been assigned to clean up using the following command:
box fixinator path=mypath goals=compatibility engines=adobe@2023

Among the results that it returns is the result below:
[HIGH] Adobe ColdFusion Compatibility finding on line 95 of programReport.cfm high confidence
The dbtype attribute of the cfquery tag was removed in ColdFusion 11
/reporting/programReport.cfm:95
95: <cfquery name="Program_Objectives" dbtype="query">

Here is the code in question:
line 95:

<cfquery name="Program_Objectives" dbtype="query">
            	select * from getResults
                where OBJECTIVEID = '#getObjectives.objectiveID#' and Program = '#getProgram.program#' 
</cfquery>

getResults is the name of a previous query.

When I look up cfquery in the coldfusion reference page (https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-p-q/cfquery.html) it still lists dbtype as an available attribute. The history mentions all other acceptable values being removed except "query" but not dbtype itself.

Apologies if I'm missing something silly. I'm pretty new to Coldfusion and Fixinator.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions