Well..I've gone and gotten myself into some trouble with a database design (mentioned it before) and Verity Searching.
It wasn't planned, but it's turned out that we need to do a Verity search on a database. There is one table of casinos, and several other tables of different casino games. A Poker Table, Blackjack table, Slots table etc. all containing the different types of Poker games, Blackjack games etc. that the site tracks. The problem, is that in the tblCasinos table, there are Memo fields, with comma delimited lists of Poker games, blackjack games, Slots games etc. So tblcasinos.poker might be = 34,45,1,10,3 Which would correspond to the tblpoker.pokerid in the Poker table. Now. I want to build a Verity search of this database, that will bring back TblCasinos.Casinoid keys if the person enters say Caribbean Style (a type of Poker game). I've sat and thought about it, messed around with a few SQL queries...but I'm really totally stuck as to how to go about this. Does anyone who has more experience with Verity have any ideas? And yes, there is NO need to tell me that having memo fields with comma delimited lists of values was not the best way to design the database :) -Gel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:142186 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54