How to delete a specific column from a query ColdFusion 11

user_12148653 0
Viewed 612

I want to delete a specific column from a query. I have already tried it with queryDeleteColumn however I get the error message:

Variable QUERYDELETECOLUMN is undefined".

Here is a code snippet (ColdFusion 11.0.18):

<cfquery name="qData" datasource="datasource">
    SELECT
        *
    FROM
        table
</cfquery>
<cfset qData = QueryDeleteColumn(qData,"columnName")
coldfusion-11 coldfusion sql
1 Answers

The function queryDeleteColumn was added in ColdFusion 2018. So it wont be available in ColdFusion 11.

You can do a query of query on the initial result like the following.

<cfquery name="qData" datasource="datasource">
    SELECT
        *
    FROM
        table
</cfquery>

<cfif listFindNoCase(test.columnList, 'columnName')>
    <cfquery name="qData" dbtype="query">
        SELECT
          #listDeleteAt(test.columnList, listFindNoCase(test.columnList, 'columnName'))#
        FROM qData
    </cfquery>
</cfif>
user_14795350
Related