[thelist] ASP equivalent to CFML question

[Jonathan_A_McPherson at rl.gov]

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

The article's example case is quite similar to what you are trying to
achieve.

Jonathan.

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


i don't think any of the other server-side languages have this
functionality.
(at least not ASP or PHP)


> > What does the [<cfoutput group="column">] CF Tag do?
> > Does it work with a returned record set or with the SQL itself?
>
> hi anthony
>
> it works on the output, i.e. on the returned record set
>
[snip]

> now let's print it out, using the GROUP= parameter to group the depts
>
>   <cfoutput query=empquery group=dept>
>       Dept: #dept#
>         <cfoutput>
>              #employee#
>         </cfoutput>
>   </cfoutput>
>
> the results look like this
>
>       Dept: 17
>              lars
>       Dept: 32
>              fred
>              jane
>              john
>              todd
>       Dept: 41
>              bill
>              jens
>       Dept: 53
>              mary
>
[/snip]
>
> rudy