No Record found on secondary pages

8 posts by 4 authors in: Forums > CMS Builder
Last Post: May 25, 2009   (RSS)

By bruno - December 11, 2008

I have a list page displays news: http://brooksproperties.com/news/

The footer is an include file. On the second and third articles pages ( http://brooksproperties.com/news/newsArticle.php?News-Item-2-2 http://brooksproperties.com/news/newsArticle.php?News-Item-3-3 ) im getting a 'record not found'.

Why does this work on the first article page, and index page, but not the secondary pages?

Ive attached the newsArticle page, list page, and footer.


Thanks!

Niki
Attachments:

newsarticle.php 4K

footer.php 3K

index_006.php 4K

Re: [bruno] No Record found on secondary pages

By ross - December 11, 2008

Hi Bruno

Thanks for posting!

I just checked out your site and all the "Read More" links are working for me as well as the two you specifically put in your post.

I am curious if you already got this going or if perhaps I am not looking at the right thing.

Either way, let me know. Thanks!
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/

Re: [bruno] No Record found on secondary pages

By Dave - December 12, 2008

Hi Bruno,

What's happening is this code in the footer is trying to load the record number that is on the end of the url:

list($real_estate_tipsRecords, $real_estate_tipsMetaData) = getRecords(array(
'tableName' => 'real_estate_tips',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));

So when the url ends in 1 (or nothing) that works fine, but when it's another number it won't. Try removing the where line:

list($real_estate_tipsRecords, $real_estate_tipsMetaData) = getRecords(array(
'tableName' => 'real_estate_tips',
'limit' => '1',
));

Also, you can add allowSearch => false, too so later when you add search engines it won't "filter" those footer records, since I'm assuming you want to show them all the time:

list($real_estate_tipsRecords, $real_estate_tipsMetaData) = getRecords(array(
'tableName' => 'real_estate_tips',
'limit' => '1',
'allowSearch' => false,
));

Let me know if that works for you!
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] No Record found on secondary pages

By bruno - December 12, 2008

Dave -

Thanks so much for all your help! Its the quick answers to all the newbie questions that make the support of your products great!

Niki

Re: [Dave] No Record found on secondary pages

By NigelGordijk - May 21, 2009

Hi, Dave.

I think I'm having a somewhat similar problem. I have a section on my client's site that has links to sublevel pages: http://www.yallaf1.com/calendar.php. The first link works okay, but the other two (there will be more) result in a "Record not found!" message. I tried deleting

'where' => whereRecordNumberInUrl(1),

but I still get the same error message.

I've attached both of these pages. Please can you advise me how to fix this?
Nigel Gordijk

Common Sense Design: User-focused Web design
Tel: 001 519 342 5348 | Web: www.commonsensedesign.net
Attachments:

calendar.php 37K

calendar_event.php 38K

Re: [NigelGordijk] No Record found on secondary pages

By ross - May 25, 2009

Hi Nigel

Thanks for hanging on with this one. I have been clicking around on your calendar page there and so far, haven't found a link that comes up with a no record found message. Could you let me know which one I should be trying?

Thanks!
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/

Re: [ross] No Record found on secondary pages

By NigelGordijk - May 25, 2009

Hi, Ross.

Thanks for the reply. I actually found the problem and fixed it at the weekend.

Cheers,
Nigel Gordijk

Common Sense Design: User-focused Web design
Tel: 001 519 342 5348 | Web: www.commonsensedesign.net