Professional Web Applications Themes

Query Of Queries syntax error - Coldfusion Database Access

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;...

  1. #1

    Default 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

  2. #2

    Default Re: Query Of Queries syntax error

    What database? Also, please provide some code.
    CF_Oracle Guest

  3. #3

    Default 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

Similar Threads

  1. Query of queries Error
    By Tulsa in forum Coldfusion Database Access
    Replies: 9
    Last Post: November 23rd, 12:03 AM
  2. Query of Queries syntax issue
    By T McDizzle in forum Coldfusion Database Access
    Replies: 2
    Last Post: June 27th, 06:24 PM
  3. Syntax error in UPDATE query
    By trey2233 in forum Coldfusion Database Access
    Replies: 9
    Last Post: July 1st, 01:20 PM
  4. Query of Queries runtime error
    By mike.bacso in forum Coldfusion Database Access
    Replies: 0
    Last Post: April 23rd, 06:27 PM
  5. Syntax error in Query Expression,
    By Raphael Gluck in forum ASP
    Replies: 1
    Last Post: October 13th, 12:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139