Search results only find record num 1

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

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

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

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

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
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

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