Ya, I agree with you and I read your post after I had already replied. You
are correct, he would be doing MUCH, MUCH better to put all of this into one
table and have a native ID, and then another column with the book as a
secondary ID and then do the search like you where saying... for small
searches you might be able to make the example below work, but for entire
bible searches your not going to...
-----Original Message-----
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 7:42 AM
To: SQL
Subject: RE: Identical Table structures..
but then how would the tables be related, (IE wouldnt a cartessian join
result), and 66 ID's would have to be checked to find the correct value.
TONY: can you explain why the books are kept in separate tables???
-----Original Message-----
From: Bill Killillay [mailto:[EMAIL PROTECTED]]
Sent: 30 May 2001 12:39
To: SQL
Subject: RE: Identical Table structures..
In your search queries you need to assign a row alias...
i.e.
Select Genesis.book,
Genesis.id,
Exidus.book,
Exidus.id,
Etc...
>From
Where...
Hope that helps
-----Original Message-----
From: Tony Hicks [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 3:47 AM
To: SQL
Subject: Identical Table structures..
I come up with ingenious ways for CF to tell me the code won't work..
I have a Bible Database... 66 books = 66 tables, no problem, right? Wrong...
Each table has an Identical structure
ID, Chapter, Verse, Text
Is there a way to query all 66 tables through a search? When I did I got an
error because two or more fields had the same name... or can anyone think of
a quick fix? Making one change 66 times is alot of work!
Tony Hicks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
