I'm trying to run a query of queries like this
<cfquery name="qryPCTinfo" dbtype="query">
SELECT file,serialno,left(serialno,3) as thisPCT,
imatterno, left(imatterno,6) as thisImatterno, patentno,issue,status
FROM qryPatents
WHERE thisPCT = 'PCT' and thisImatterno =
'#variables.thisfamily#'
</cfquery>
in CF MX7 and it keeps failing with
Query Of Queries syntax error.
Encountered "left. Incorrect Select List, Incorrect select column,
I just went through the online docs for QoQ and there isn't much mention of
using functions in them. Is it possible?
If anybody could take a quick peek at the above and offer any suggestions I
would be grateful. Especially if I am overlooking something obvious.
Thanks.
-Nate
Nathan Smith McKee, Voorhees & Sease, P.L.C.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253119
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
