Spaces in the input fields? Did you examine the resulting query in your debug output?
You're going to use <cfqueryparam> when you finalize this, right? -----Original Message----- I am doing a very, very simple search on two database columns, "Title" and "Link". For my query, I am also doing the simplistic: <cfquery name="Search" datasource="mydb"> SELECT * FROM my_table WHERE 0=0 AND Title LIKE '%#FORM.SearchText#%' OR Link LIKE '%#FORM.SearchText#%' </cfquery> On the output, I just do a simple output query of search. Now for my problem. In Firefox, the search will return the appropriate results, as expected. However, in IE 6.0, the exact same search returns nothing. I have gone cross-eyed trying to figure out what could possibly be happening. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276211 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
