Ask a Question related to Coldfusion Database Access, Design and Development.
-
Spaniard1981 #1
Query Of Queries syntax error
Hello I am running a Query of Queries and I'm getting the following error:
Query Of Queries syntax error.
Encountered "Section" at line 0, column 0. Incorrect Select List
Can anyone help me understand what this means?:confused;
Spaniard1981 Guest
-
Query of Queries syntax issue
I have query 1 which has a list of names and query 2 which has ratings for the names. Every rating from query 2 has a name in query 1, but not... -
Query Of Queries runtime error in CFMX 7
Hi, I am migrating from CF 5 to MX 7. All the queries are working fine in the old version. However when I try the same code in MX7 I get errors.... -
Query of queries Error
I am putting query results into a new query to sort them, rather than using arrays. I can insert into a new query using queryNew just fine and even... -
Query of Queries runtime error
this also happened to me, on a different account. For me it happened on ORDER BY #url.o# #url.s# I have a <cfparam name='url.o'... -
Syntax error in Query Expression,
Hi everyone I have a page on my site in which i wish to display links to brochures, and i have stored an index of these links in my database. ... -
CF_Oracle #2 Re: Query Of Queries syntax error
What database? Also, please provide some code.
CF_Oracle Guest
-
mxstu #3 Re: Query Of Queries syntax error
"Section" is a reserved word in a Q of Q, so you need to escape it (i.e.
enclose the name in square brackets)
<cfquery name="qOfQTest" dbtype="query">
SELECT MAX([Section]) AS MaxSection
FROM yourQuery
</cfquery>
See [url]http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/express4.htm[/url] for
more information.
As CF_Oracle mentioned, providing code makes it easier for people to assist
you :)
mxstu Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
