To me it would depend on the size of data. If I had a few hundred products max and the desc fields weren't huge, I'd do QoQ simply because I'd be done in a few minutes, and never have to worry about Verity headaches.
Remember that in CF5 though, QoQ is case sensitive. The workaround is to lcase/ucase the column in the original query, and if you are using that column already to display text to the end user, you will want to create a field just for the search function. select *, productDescription AS search_productDescription from products. -- jon mailto:[EMAIL PROTECTED] Thursday, March 6, 2003, 1:34:39 PM, you wrote: LCCC> Suppose i have a productDescription column in my products table, and i want to search for a string. LCCC> Witch one do you advise? LCCC> 1) Query of query LCCC> - do a master query (select * from products) and cache it. LCCC> - do a query of query (select * from masterquery where productDescription like '%#Criteria#%') LCCC> or LCCC> 2) Use verity 2k LCCC> - create a recordset LCCC> - create a collection based on this record set (cfindex) LCCC> - use cfsearch to search that collection. LCCC> Thank you for your opinions. LCCC> Leonardo Crespo LCCC> icq: 198810 LCCC> [EMAIL PROTECTED] LCCC> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
