Brook,
Check out this article on using recursion at the Defusion site:
http://www.defusion.com/articles/index.cfm?ArticleID=63
I've used this setup in my Amazon partner bookstore where I have
categories and subcategories. Works well. See
http://www.astutia.com/books/index.cfm for an example.
Chris Montgomery [EMAIL PROTECTED]
:: Web development/Consulting http://www.astutia.com ::
:: Allaire Consulting Partner/ NetObjects Reseller ::
:: 210-490-3249/888-745-7603 Fax 210-490-4692 ::
:: Find a Job in San Antonio http://www.sajobnet.com::
>-----Original Message-----
>From: Brook Davies [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, June 20, 2000 6:42 PM
>To: [EMAIL PROTECTED]
>Subject: Database Design Question
>
>
>I have listings that look like:
>
>1.0 foobars
> 1.1 foobars the revenge
> 1.1.2 foobars the revenge II
> 1.1.2.1 more foobar specials
>2.0 brown foobars
>3.0 green foobars
>
>etc..
>
>What is the best DB design in terms of performance for a
>classification
>system like this?
>
>Thanks,
>Brook Davies
>MaracasMedia Inc.
>
>---------------------------------------------------------------
>---------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
