> Could you just use LIMIT 100 (or some number) to limit the number of search > results?
I thought of that - but then they'd only ever see the top or bottom 100 and the thing they're looking for is number 101.... I'm thinking of something that will force them into further detail for the drill down: Your search for "red" returned 25,745 results. Are you looking for: _ mystery? _ fantasy? _ romance? _ biography? _ reference? _ children's book? ....or something like that to help narrow it down (assuming I've got those classifications in the database). Not 100% what I'm going to do yet. We certainly don't want somebody typing "the" into the "title is like" field and seeing 250,00 results, do we? Maybe there's a trick I can do with paging... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
