Passing variable in URL results in no CMS access

Hi Jeremy

Thanks for posting!

When you have a variable like that in the URL, CMS Builder actually tries to do a search for it. Basically, it will try and find all your records that the menu field set to 2. Of course, you don't have a menu field so it's breaking things.

The solution here will be to add the following to your viewer code:

'allowSearch' => '0',

That will tell CMS Builder to ignore what you have in the URL. Give it a shot and let me know how you make out :).

Hi Jeremy,

For detail viewers it also uses the number in the url to know which record to load. If you have a single record section (such as about us, etc) try removing this line:

'where' => whereRecordNumberInUrl(1),

If you remove that line it will just return the first record in the database, which for single record sections should be fine.

Hope that helps, let me know if that works for you. If it doesn't, feel free to attach the children.php file to this thread and I can take a look for you.

Thank you Dave!!! :-)

That did the trick! I can't tell you how much I appreciate your response and assistance (as well as Donna's). Looks like I may meet my deadline after all. :-)

You guys are the best! Have a great weekend!

Jeremy

HI - I'm having an identical problem...

Here's the background for my issue:

1. It's a news page where the detail of the news story is in the right column, and a list of up to 10 news stories is in the left column, all populated from the same table.
2. The newsdetail.php page i created includes links back to the CMS for all the navigation menus, logo, footer content & links, etc.
3. When I click on the first article, the page loads beautifully - all the menus appear as well as all the footer links. The URL ends with a '1'.
4. When I click on the second news item everything breaks. No menus, an error where the logo should be, no footer content, etc. The URL ends with a '2'.

Changing the number on the end to a 1 or 0 loads the first news story and everything else on the page wonderfully.

Changing the number on the end of the URL to anything other than 1 or 0 results in a 'mis-loaded' page. The correct article shows, but none of my menus or footer content loads (essentially nothing else from the CMS loads).

And I need to load records greater than 1 as I'm anticipating many news stories to be populated in this page.

I've tried the 'allowSearch' => '0', also, but that doesn't help either.

That said, any ideas?

I've attached a slightly modified version of the file I'm having issues with. I took out the full URL in the 'require_once' line. Any insight & fixes would be appreciated.

Love the product by the way - using it on 2 company sites already and have 2-3 more planned after I finish up this project.

Thanks.

Hi cricket7475!

Did you try taking out the "where" line? I believe that's what ended up working for us. Just a thought.

Jeremy

Hi cricket7475,

Your code is using the number it finds in the URL for two lookups, both for your "common" section and your "news" section:

list($commonRecords, $commonMetaData) = getRecords(array(
'tableName' => 'common',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$commonRecord = @$commonRecords[0]; // get first record

list($newsRecords, $newsMetaData) = getRecords(array(
'tableName' => 'news',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$newsRecord = @$newsRecords[0]; // get first record

Try removing the line in red above.

I hope this helps! Please let me know if you have any questions.

That worked - still learning php and all it's nuances. Thanks for the help!

Glad to be of help! :)