Direct Link to Tabs Problem - Record not found!

5 posts by 2 authors in: Forums > CMS Builder
Last Post: December 2, 2010   (RSS)

By meg - December 1, 2010

I had this problem once before using this tab front-end method but I can't see to figure out how I resolved it - please HELP!!

If you go here: emeritihealth.org, then under About, select any of the drop down items after the first one and you see it comes up "Record not found!"

How do I resolve this? You can see it not being a problem if you go elsewhere throughout the site because I don't have the CMS connected to the rest of the site, temporarily.

Re: [meg] Direct Link to Tabs Problem - Record not found!

By Jason - December 1, 2010

Hi meg,

Could you attach about.php so i can take a look at your code. My guess is that you're using whereRecordNumberInUrl() which is pulling the last number from your url and trying to find a record with that number. From the look of your URL though, that number seems to be used for something else.

How are you deciding which record to get form the database?

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] Direct Link to Tabs Problem - Record not found!

By meg - December 1, 2010

Well, the link in the menu is associated numerically with the tab script and I thought that would translate through in the database, but it doesn't. The record for the content is associated with about_subcategories. Do you think I need to add a foreach about_subcategories at the top of the menu script as well? It's associate with the content...maybe that's my problem? I'm sending this...and will try what I mentioned as well. Thanks so much for all your help!
Attachments:

about.php 6K

Re: [meg] Direct Link to Tabs Problem - Record not found!

By Jason - December 1, 2010

Hi meg,

I took a look at your code and I noticed that you use whereRecordNumInUrl() when selecting from:
meta_tags
header_menu_links
about_title_photos

From the way you're using them, they appear to be single record sections. Is that correct? If so, you don't need a where clause since there will only ever be 1 record in a single record section. So for those 3, remove:
'where' => whereRecordNumberInUrl(1),

That should take care of your "Record Not Found" issue. Give that a try and see if you're page is working the way you expect.

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/