Underground II
Running “queries of queries”
Running “queries of queries”
CF5 allows you to run queries against recordsets stored in memory from a <CFQUERY> tag
Join the results of two queries together in memory (simulating sql stored procedure temp table functionality)
CF5 supports a minimal subset of the ANSI standard
Group By
Order By
Aggregate Functions (Count, Sum, Avg, Max, Min)
As
Boolean (Not, Like, IN, Between, AND, OR
DML (Outer Join syntax)
Previous slide
Next slide
Back to first slide
View graphic version
|
Home
|
Photos
|
Maps
|
CF Conf Central
|
Please send comments/questions to
[email protected]