Let's say I'm using the second (following) alternative:
CATEGORIES:
catID
parentCat
catName
SITES:
siteID
siteName
catID (FK)
and I want to display a tree of categories, based on a catID from sites
how can I SQL-SELECT recursivley, all the relevent catNAMES?
Sounds pretty messy...
Michael.
----- Original Message -----
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 23, 2001 9:13 PM
Subject: RE: Me Vs. Complexed Table Design
> > I didn't find secretagents' tutorial,
>
> That's because it's Secret <g>
>
> Actually, it's here
> http://www.secretagents.com/tools/freeviewlets/
> (You Still Have Time To Learn, Free Online Training)
>
> or here
> http://www.secretagents.com/tools/viewlets/
> (You Still Have Time To Learn, Professional Online Tutorials)
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **********************************************************************
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
