Encountered "(. Incorrect Select Statement, Expecting a 'FROM', But Encountered '(' Instead, A Select Statement Should Have a 'FROM' Construct.

Posted June 30, 2006 at 12:08 PM

Tags: ColdFusion, SQL

I was testing some ColdFusion Query of Queries functionality when I got this error:

Query Of Queries syntax error.
Encountered "(. Incorrect Select Statement, Expecting a 'FROM', But Encountered '(' Instead, A Select Statement Should Have a 'FROM' Construct.

I know what was causing the error because I was testing to see if something worked, but it's not the most obvious error. I guess it's a syntax error (from a technical standpoint), but in my case, where I was testing to see if ISNULL() worked, I'm really using a function that is not available.

That being said, if you get the error above, it means you are using something in the SELECT statement that is not allowed. If you are coming over from SQL, make sure you are not trying to use any SQL functions that are not available in the ColdFusion Query of Queries. As a foot note, here are some common SQL functions that I use that are not available in the ColdFusion Query of Queries:

ISNULL()
LEN()
DATEADD()

Post Comment  |  Ask Ben  |  Other Searches  |  Print Page



Learning ColdFusion 9 - ColdFusion 9 tutorials, samples, examples, demos

Reader Comments

Mar 31, 2007 at 11:25 PM // reply »
7 Comments

Hrm...

In my case, I have an XML file which I'm converting into a query object. The resulting query has a column named date. I can select * just fine, but when I specify the date column it blows up. Leave that column out and it works just fine. I've tried bracketing the column name, quoting it bracketing AND quoting to no avail.

Anyone have any ideas?


Mar 31, 2007 at 11:43 PM // reply »
7 Comments

Okay...

In this case, the solution was ot both bracket AND alias the questionable column. So this works:

SELECT [date] AS thedate
FROM QofQ


Apr 1, 2007 at 9:37 AM // reply »
7,572 Comments

Exactly... in fact, the same thing would apply to a regular non-query-of-queries SQL statement.


Oct 3, 2007 at 10:53 AM // reply »
4 Comments

I've run into this error as well using the COUNT function. It only works when i have just the function in the SELECT list and use no alias which is worthless for my purposes.


Post Comment  |  Ask Ben

Recent Blog Comments
Mar 22, 2010 at 3:08 AM
Ask Ben: Selecting XML Attributes Given Other XML Attributes
Thanks for the response. I finally discovered that I was getting this error because I had cfsetting enablecfoutputonly="yes" in Application.cfc, and was neither setting it to false elsewhere nor brac ... read »
Mar 21, 2010 at 8:57 PM
The Bourne Ultimatum Starring Matt Damon And Julia Stiles
late to the party, but my observation is this: rewatch carefully for the platonic nature of the relationship between nicki and jason. she never flirts with him. he never comes on to her. they alway ... read »
Mar 21, 2010 at 7:40 PM
Is Simulating User-Input Events With jQuery Ever A Good Idea?
A couple of things. One you embed the initial state of of more-info in the CSS. IMHO, that behavior should be in jQuery: moreInfo.hide(); It shows that the behavior your toggling and closing is mor ... read »
Mar 21, 2010 at 3:59 PM
Exploring ColdFusion Component Runtime Class Properties And Serialization
@Elliott, according to Ben's experiment, serializeJSON() doesn't access the private data by default - it doesn't even access the getHair() method - so trying to clone a Girl.cfc via serializeJSON/des ... read »
Mar 21, 2010 at 3:49 PM
Ask Ben: Javascript String Replace Method
I'm confused a bit by what you are asking, but if had this sentence: The color, red, is in the style statement; style: red;. and wanted to remove all or change all of the commas, colons, and semi-c ... read »
Mar 21, 2010 at 3:13 PM
Ask Ben: Javascript String Replace Method
I am trying to make a java program to count the number of times that these punctuation marks occur in a body of text: , : ; . ! - ' " ? / \ I am using this piece to ferret out the commas: numcommas ... read »
Mar 21, 2010 at 11:13 AM
A New Wrist Pain
@chiropractor suwanee, Spoken like someone trying to sell something. Other than for minor, temporary relief from some back pain, chiropractic treatment is nothing but placebo effect and quackery. ... read »
Mar 21, 2010 at 6:32 AM
ColdFusion CFPOP - My First Look
Apologies... The field name in the db for C. is "BounceCode" It stores the code / message which is returned in the email. Sorry for the confusion. ... read »