Play with it in a SQL GUI until you get it the way you want it, then
enclose it within <cfquery>...</cfquery> tags.
Most of these (Celko's) techniques are quite fast -- seems a little odd
at first, but it compensates for RDBMS's inherent weakness when
handling hierarchical data.
I suggest you include lotsa' comments to explain what & why.
HTH
Dick
On Jun 2, 2004, at 5:28 AM, Nicholas Watson wrote:
> How do you return a record set like this back to ColdFusion? Do you
> just use a cfquery tag? I tried the example, and it's much faster than
> what we are currently doing, but how do I handle it on the ColdFusion
> side?
>
> >This is SQL-Server specific:
> >
> >http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm
> >
> >If you want some general discussions on the topic google for
> >celko���and trees or hierarchical or nested sets
> >
> >HTH
> >
> >Dick
> >
> >
> >On Jun 1, 2004, at 11:22 PM, Paul Wilson wrote:
> >
> >>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
