SPECTRA: Embed an object within itself...

2000-05-17 Thread Sean M. O'Brien
Hello all, I asked this question at my CFUG meeting tonight and no one knew the answer. I am creating a product catalog for a web site using Allaire Spectra. I create a product object and an option object. So that each option can have it's own SKU, price, etc. What I want to do is then

RE: SPECTRA: Embed an object within itself...

2000-05-17 Thread Sean M. O'Brien
To: [EMAIL PROTECTED] Subject: SPECTRA: Embed an object within itself... Hello all, I asked this question at my CFUG meeting tonight and no one knew the answer. I am creating a product catalog for a web site using Allaire Spectra. I create a product object and an option object. So that each

Re: SPECTRA: Embed an object within itself...

2000-05-17 Thread Judah McAuley
We don't use Spectra at the moment (wish I had a spare $15,000 laying around...), but I can tell you the way that we tackled that problem. We defined a table of option types (color, size, fabric, etc) and a table of option values with foreign keys to the option types (color, red; color,