Ok, here it is:
fusion_table
id | owner | sub_object | type | sort | status
department_table
id | title | description | content | status | TEMPLATE
product_table
id | title | description | content | status | TEMPLATE .... various other
columns
content_table
id | title | description | content | status | TEMPLATE
The fusion table combines the id values from the other three tables, in the
two columns OWNER and SUB_OBJECT. All owners can have multiple sub_objects
and sub_objects can become owners. The type field is one of three values
department, product, or content
So if I have id's
1 = department
2 = department
3 = product
4 = product
5 = content
and my fusion table looks like this:
owner | sub_object | type
1 2 department
2 3 product
2 4 product
2 5 content
Owner 1 has the sub_object 2 (sub_department) owner 2 has the sub objects
3,4 (products) and 5(content item).
So if I have a link loading up ID=4 the product and want to view it's
records, "go.cfm?owner=4" I want to write a query that will get the
template out of the appropriate table ...
I do not want to do a
<cfif type Is "product">
run this query
<cfelseif type Is "department">
run this query
<cfelse>
run this query
</cfif>
I would like to run a query that will "Join or Union" the tables to get the
TEMPLATE so I can tell which template to use. I would rather not duplicate
the data and keep the template attached to each item.
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder
> can you give more detail? from just this amount, it sounds like a join
may be in the making. are all the tables related via the relationship
table?
>
> christopher olive
> cto, vp of web development, vp it security
> atnet solutions, inc.
> 410.931.4092
> http://www.atnetsolutions.com
>
>
> -----Original Message-----
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 18, 2002 11:00 AM
> To: CF-Talk
> Subject: Re: UNION vs JOIN
>
>
> I am combining the results of three tables that are very similar in their
> setup and the fourth table holds all the relationships.
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
> > they do different things, really. what are you trying to accomplish?
> >
> > christopher olive
> > cto, vp of web development, vp it security
> > atnet solutions, inc.
> > 410.931.4092
> > http://www.atnetsolutions.com
> >
> >
> > -----Original Message-----
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, April 18, 2002 10:18 AM
> > To: CF-Talk
> > Subject: OT: UNION vs JOIN
> >
> >
> > Is there a significant difference in performance using a UNION on four
> > tables versus a JOIN on four tables?
> >
> > Thanks
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector v2.0 - Commerce Builder
> >
> >
> >
>
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
