Query of Query in MX

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" <[email hidden]> wrote in message
"]news:[email hidden]...

Quoted message said:

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 =

Quoted message said:

'NURS3521' AND Section = '100'

In CF MX, I get this error: <br><b>Query Of Queries syntax
error.</b><br> Encountered "Section" at

line 0, column 0. Incorrect

Quoted message said:

conditional expression, Expected one of
[like|null|between|in|comparison]

condition,

Quoted message said:

Thinking that QoQ might be interpreting Section as a
reserved word, I have

tried it as [Section]

Quoted message said:

and as "Section" Both of these produce other syntax
errors.

How can I fix this?
--

Cletus D. Lee clee.orgclee.orgOpen ↗
- Bellaire, TX USA -