Hi, Following is generic search tool for MS SQL Server -based database. Tested against SQL 7 and 2000. Should work for SQL 6.5 as well but would be good and fun to see testing result with 6.5.
Assumptions for using the tool: the searchable database is a non-operational or non-transactional database if a large number of users are going to use the tool; many frequently searched columns should be indexed. Only requirements to make it work for you: 1. Make a directory called DONLI under your CF / CFMX CustomTags installation and copy 3 modules there 2. Place 4 or fewer cf framework files in your search application, of which, set some configuration parameters for your application: Minimal configuration * enter your datasource point to the database to be searched. Standard configuration: * enter your datasource point to the database to be searched; * table(s) to be excluded; * column(s) to be excluded a few more ... Sample application URL, http://68.32.61.40/datadata/ddSearch.cfm Drop me a line at [EMAIL PROTECTED] if you want source code. Welcome feedback. Li, Chunshen (Don) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
