Heh... Although I know there's NO need to tell you this, avoiding comma delimited lists would prevent the need to poke people with your poker pickle. :-P
That being said, the obligatory pickle-poking may not be as bad as you think... give this query a poke... err... I mean peek... select casinoid from tblCasinos where ',' + poker + ',' like '%,#pokerid#,%' ike -- player poking pickle-o-phile > 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 s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:4:190117 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54