Wierd CF Output IE Problem
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. Any ideas? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276210 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Wierd CF Output IE Problem
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
Re: Wierd CF Output IE Problem
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