Getting malformed queries when using CCK fields for search input
Great module...I'm having a few problems which may not be bugs, but I can't seem to solve them. I am using fastsearch in conjunction with views_filterblock. I've created a input block at http://ibe.scribeproduction.com. There are a few instances when I get malformed queries when I search on certain words, characters, etc. For instance, when I search on 'baron' in the author field I get an error. Here is the query:
SELECT count(node.nid) FROM node node LEFT JOIN content_type_bep_title node_data_field_bep_author ON node.vid = node_data_field_bep_author.vid WHERE (node.status = '1') AND (node.type IN ('bep_title')) AND (UPPER(node_data_field_bep_author.field_bep_author_value) LIKE UPPER(''node'aron%'))
However, when I search on 'Baron' (capitalized) the query is formed properly. Also an issue with 'business' and 'Business' in the title field. Ideas?