Is This Correct

3 posts by 2 authors in: Forums > CMS Builder
Last Post: January 19, 2011   (RSS)

Re: [socanews] Is This Correct

By Jason - January 19, 2011

Hi,

What's happening here is that you're storing 2 values in your category field, "Profiles" and a letter. The _keywords search looks for an instance of that character in the field. If you look at the letters that are returning all the results, they're all letters in the word "profiles".

What you can do is create your where clause manually to only look a the second value, not the profiles part. Try this:

list($artistsRecords, $artistsMetaData) = getRecords(array(
'tableName' => 'artists',
'allowSearch' => false,

'where' => "category LIKE '%\t".@$_REQUEST['category_keyword']."\t'",
));

Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Is This Correct

By Joseph - January 19, 2011

Thanks Jason that now works fine.