CODEWITHSUNDEEP
coldfusion
Bradley Moore
Bradley Moore

Reputation: 748

Is there a way to escape and use ColdFusion query reserved words as column names in a query of query?

I'm working with a query that has a column named "Date."

The original query returns okay from the database. You can output the original query, paginate the original query, get a ValueList of the Date column, etc.

Query of Query

<cfquery  name= "Query" dbtype= "query">
select 
[Query].[Date]

from [Query] 

</cfquery>

Response from ColdFusion

Query Of Queries syntax error. Encountered "Date. Incorrect Select List,

Typically, I use descriptive names so I haven't run across this issue previously.

In this case, I'm working with a stored procedure that someone else wrote. I ended up modifying the stored procedure to use a more descriptive column name.

I have a service I use for transforming, searching and sorting queries with ColdFusion. I'm curious to know the answer to my original question, so that I can modify my service to either throw a better error or handle reserved words.

Is there a way to escape and use ColdFusion query reserved words as column names in a query of query?

Upvotes: 1

Views: 1658

Answers (2)

Sam Farmer
Sam Farmer

Reputation: 4118

The following code works fine for me:

<cfset query = queryNew("date")>

<cfdump var="#query#">

<cfquery  name= "Query" dbtype= "query">
select 
[Query].[Date]

from [Query] 

</cfquery>

<cfdump var="#query#">

Upvotes: 9

FreudianSlip
FreudianSlip

Reputation: 2920

In standard mysql you'd "escape" the fields by using the ` character.

So for example: 

select `query`.`date` from `query`

Try that and see if it works?

Upvotes: -2

Related Questions