umm - Why are you using separate tables for each book???
It would probably save you a lot of work in the long run if you merge the
tables into one large table... (I take it this is SQL server not access???)
although this would be one huge table...
You probably could use aliases for searching, but unless the ID's are DB
unique (GUIDs etc) than how would you identify which book the result had
been found in???
No - actually come to think of it I still don't think you could do it, as
you'd somehow need to join the tables - and as they are not actually
related, you'd generate a cartessian join (and I think on the amount of data
your talking here, you'd crash your SQL box very quickly (every record would
be related to every other record so you'd get total no. verses ^ total no.
verses records - not pleasant!)
It probably is possible to loop through every book using a cursor, and to
dynamically generate a tempoary table with the results, but it would be
*!SLOW!*
I'd recomend merging the tables, and Free Text Indexing the resulting table
on the text field...
(Obviously the resulting table would then need a bookID as well...)
HTH
Dan.
-----Original Message-----
From: Tony Hicks [mailto:[EMAIL PROTECTED]]
Sent: 30 May 2001 08:47
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
