Not finding the relevant article.

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

Re: [rg1986] Not finding the relevant article.

By Jason - September 21, 2011

Hi Richard,

It looks like a minor problem with your getRecords call on med_newsArticle.php. If you could attach that page to this thread, I can take a look at the code and let you know what changes to make.

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] Not finding the relevant article.

By Footplate - September 21, 2011 - edited: September 21, 2011

Many thanks, attached is the page.

Richard
Attachments:

med_newsarticle.php 8K

Re: [rg1986] Not finding the relevant article.

By Jason - September 22, 2011

Hi Richard,

The problem here is you need to add a WHERE clause to your getRecords call to get the record specified in the URL.

Try this:

// load records
list($media_newsRecords, $media_newsMetaData) = getRecords(array(
'tableName' => 'media_news',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));


That should take care of the issue for you.

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] Not finding the relevant article.

Thanks, that has solved it!!!!

Your help is a appreciated! :)

Rich