Speaking of which,
Anyone got a BibleDB? I DO have my own, but I'm sure there are better ones..
----- Original Message -----
From: Daniel Lancelot <[EMAIL PROTECTED]>
To: SQL <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 3:16 AM
Subject: RE: Identical Table structures..
> 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
