Is there some known problem with queries of queries in CF 5?
I have this query:
<CFQUERY NAME="getSchemas" DBTYPE="query">
SELECT schema, tableType, count (*) AS nbTables
FROM getTables
GROUP BY schema, tableType
ORDER BY schema
</CFQUERY>
It is supposed to count tables by table type and Schema.
The getSchemas query itself is ordered by schema, tabletype
However, the second query is giving this:
schema = WMSYS, type = VIEW, nb = 8
schema = WKSYS, type = VIEW, nb = 3
schema = WK_TEST, type = VIEW, nb = 3
schema = XDB, type = VIEW, nb = 2
schema = WK_TEST, type = VIEW, nb = 3
schema = WKSYS, type = VIEW, nb = 1
schema = WMSYS, type = VIEW, nb = 19
schema = WKSYS, type = VIEW, nb = 44
schema = WMSYS, type = VIEW, nb = 22
schema = WKSYS, type = VIEW, nb = 7
schema = WMSYS, type = VIEW, nb = 15
schema = EXFSYS, type = VIEW, nb = 3
schema = MDSYS, type = VIEW, nb = 17
schema = DMSYS, type = VIEW, nb = 3
schema = EXFSYS, type = VIEW, nb = 18
schema = OE, type = VIEW, nb = 6
schema = OLAPSYS, type = VIEW, nb = 15
schema = MDSYS, type = VIEW, nb = 13
showing that first the ORDER BY schema is not done, secondly, the GROUP BY didn't work either
--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
