Wierd CF Output IE Problem

2007-04-25 Thread Joel Watson
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

RE: Wierd CF Output IE Problem

2007-04-25 Thread Everett, Al \(NIH/NIGMS\) [C]
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

Re: Wierd CF Output IE Problem

2007-04-25 Thread Joel Watson
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!