Query of Query in MX

Cletus Lee

I have a query of a query that runs fine in CF 5.0.

<cfquery dbtype="query" name="Qloop"> SELECT Term, Course,
[Section], EvalWhat ,Total FROM StudAnsCt WHERE Term =
#TERM# AND Course = '#trim(StudentCount.Course)#' AND
Section = '#StudentCount.section#' </cfquery>

It resolves to: SELECT Term, Course, [Section], EvalWhat
,Total FROM StudAnsCt WHERE Term = 20041 AND Course =
'NURS3521' AND Section = '100'

In CF MX, I get this error: Query Of Queries syntax
error. Encountered "Section" at line 0, column 0.
Incorrect conditional expression, Expected one of
[like|null|between|in|comparison] condition,

Thinking that QoQ might be interpreting Section as a
reserved word, I have tried it as [Section] and as "Section"
Both of these produce other syntax errors.

How can I fix this?
--

Cletus D. Lee http://www.clee.org (http://www.clee.org/)
- Bellaire, TX USA -

Bill

First you need to adjust the deraileur. Then replace the
front chanring so you have a 52/39/26 That should do it

"Cletus Lee" <Newsgrp@clee.org> wrote in message
news:MPG.1b4c8e08f4aff2e19899f8@News.Individual.NET...
> I have a query of a query that runs fine in CF 5.0.
>
> <cfquery dbtype="query" name="Qloop"> SELECT Term, Course,
> [Section], EvalWhat ,Total FROM StudAnsCt WHERE Term =
> #TERM# AND Course = '#trim(StudentCount.Course)#' AND
> Section = '#StudentCount.section#' </cfquery>
>
> It resolves to: SELECT Term, Course, [Section], EvalWhat
> ,Total FROM StudAnsCt WHERE Term
= 20041 AND Course =
> 'NURS3521' AND Section = '100'
>
> In CF MX, I get this error: Query Of Queries syntax
> error. Encountered "Section" at
line 0, column 0. Incorrect
> conditional expression, Expected one of
> [like|null|between|in|comparison]
condition,
>
> Thinking that QoQ might be interpreting Section as a
> reserved word, I have
tried it as [Section]
> and as "Section" Both of these produce other syntax
> errors.
>
> How can I fix this?
> --
>
> Cletus D. Lee http://www.clee.org (http://www.clee.org/)
> - Bellaire, TX USA -