[thelist] ASP equivalent to CFML question

Jonathan_A_McPherson at rl.gov Jonathan_A_McPherson at rl.gov
Fri May 17 10:20:01 CDT 2002


It's more powerful because it allows you to build an *arbitrary* level of
hierarchical recordsets using *arbitrarily* complex sub-queries. Neither are
possible in CF, AFAIK.

In CF, you are somewhat limited with how many levels down you can go (I'm
not sure what the limit is -- any CF experts know?), and your query is
limited to what you can express with a single SELECT. Essentially, CF is
working behind the scenes to make a simple SELECT look like a hierarchical
recordset. In ASP, you're getting a "true" hierarchy with the ability to
branch off in sub-queries in ways that are difficult or impossible to
express with straight JOINS or GROUPS.


-----Original Message-----
From: nagrom [mailto:morgan at morgankelsey.com]
Sent: Friday, May 17, 2002 7:23 AM
To: thelist at lists.evolt.org
Subject: Re: [thelist] ASP equivalent to CFML question


> The key feature of the <cfoutput group="column"> is that it allows you to
> create a kind of hierarchical recordset. You can do something similar to
> this using data shaping in ASP. Your query will look different and it's a
> bit more work than in CF, but it's actually more powerful (IMO). Check out
> the 4guys article:
> http://www.4guysfromrolla.com/webtech/092599-1.shtml
> Jonathan.

its acheiving the same thing as CFs grouped attribute....
i don't see more power here, only more code and complicated queries.

what's more powerful about it?


More information about the thelist mailing list