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
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
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!
3 matches
Mail list logo