Search results only find record num 1

4 posts by 2 authors in: Forums > CMS Builder
Last Post: July 22, 2011 (RSS)

Archived
Reply
Reply

By markr - July 21, 2011

I have a search form doing a keyword search on several fields but it is not finding records that it should. It is only finding keywords in record number 1.

I am using the following clause on the listPage to only show future events...

'where' => 'eventDate > NOW()',

Is this causing the problem? It appears to work for the list page but is this not well-formed?

Re: [markr] Search results only find record num 1

Archived
Reply
Reply

By Jason - July 21, 2011

Hi,

Would you be able to attach the .php page you're working with so we can take a look at your code?

thanks,

---------------------------------------------------
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] Search results only find record num 1

Archived
Reply
Reply

By markr - July 21, 2011

Sure. Thanks for takin' a look.

I need the basic list page to show only future events.

Then I need the same list page to show the results of the keyword search form.

Attachments:

list_004.php 2K

Re: [markr] Search results only find record num 1

Archived
Reply
Reply

By Jason - July 22, 2011

Hi,

I took a look and I don't see anything immediately wrong. Something we can try to help pin point the issue is to use the:
'debugSql' => true,

option in getRecords() like this:

// load records
list($calendarRecords, $calendarMetaData) = getRecords(array(
    'tableName'   => 'calendar',
    'perPage'     => '30',
    'where'       => 'eDate > NOW()',
    'debugSql'    =>  true,
  ));

This will output the actual mysql query that is being executed. If you could run a search with this option enabled and post your results, we can take a look at that.

Hope this helps