Well, it turns out that the casing of the fieldnames was the problem. I didn't realize that this was an issue for IE (and I don't quite understand why it would be). Anyway, it works, so that is enough.
Thanks for your help, and yes, I am going to add the <cfqueryparam> on the final go. Thanks! Joel >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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276228 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
