Not the ideal design, change it to this:
Books --- BookAuthors --- Authors
|
|- BookCategories --- Categories
|
|- BookLanguages --- Languages
All relationships are one to many (one on the left and right, many in the
center). Will make your life much easier.
--- Ben
-----Original Message-----
From: Hamid Hossain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 11:52 AM
To: CF-Talk
Subject: come on Forta !
Hi folks,
I'v just ordered Ben Forta's new book. I am woundering
if I will find a way to solve this problem. I have the
following database tables:
------- many -- Authors
| (Table)
|
|
|
Books - many --------- many -- Categories
(Table) | (Table)
|
|
|
------- many -- Languages
(Table)
As you can see, Three tables are linked to (Books)
table in many to many relations. I want to output a
list of all books with all (Authors), (Categories) and
(Languages) of each single book.
Could you please help me with the best way doing that.
In another way, Can I do it with a single query?!.
Any CF code will be appreciated.
Regards,
Hamid Hossain
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
