sql

Hydrowizard wrote:
> Thanks to Dan Brauck's advice I have been doing a lot of sql work recently. As
> far as a can gather it isn't that tough, just select whatever from whatever and
> then order or group it use an inner or outer join (the outer one isn't
> supported by coldfusion) and if in doubt use a query of queries. The only
> tricky part would be stored proceedures? Does that come under "sql"
> specifically? Thanks for answering my $$%%ing stupid question!!
>

ColdFusion supports outer joins in SQL just fine. The SQL parser used
in query-of-queries does not yet support it. *Here's hoping it will
soon.* But for SQL sent to fully featured database management systems
it supports it just fine. In as much as it just plain does not care
what is in the SQL because CF does nothing with it other then pass it on
to whatever is going to be parsing it.

Stored Procedures are largely SQL, but as they are more capable
procedural constructs they can go beyond SQL as well. What this is and
how it is utilized is up to the database management system the stored
procedure is being built in. From CF's point of view the developer just
needs to know the name of the procedure, what - if any - parameters to
pass in and what results are returned. Some database management systems
can create results that CF can not handle but that is fairly limited.