Details Page no record found

Hi MRI,

If I understand you correctly, I'd try removing the: where' => whereRecordNumberInUrl(1), in the employment listings and see if that helps. Sometimes the 'limit' => '1', can give strange results as well.

You might also, add:

allowSearch => false,

so later when you add search engines it won't "filter" those records, since I'm assuming you’ll want to show them all the time.

The issue of not showing particular text can be done using an "if" statement around the HTML entry with a ! (not) before the $ as in the "records not found!", below.

You don't have to repeat the entire block of "require once" code on your page either.

You can use: <?php

require_once "/XXXXXXX";

list($ad_managerRecords, $ad_managerMetaData) = getRecords(array(
'tableName' => 'ad_manager',
'limit' => '2',
'orderBy' => 'RAND()',
'where' => " page_display LIKE '%\tAll\t%' ",
));

list($employment_pageRecords, $employment_pageMetaData) = getRecords(array(
'tableName' => 'employment_page',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$employment_pageRecord = @$employment_pageRecords[0]; // get first record

// show error message if no matching record is found
if (!$employment_pageRecord) {
print "Record not found!";
exit;
}

list($employment_listingsRecords, $employment_listingsMetaData) = getRecords(array(
'tableName' => 'employment_listings',
'limit' => '1',
));
$employment_listingsRecord = @$employment_listingsRecords[0]; // get first record

// show error message if no matching record is found
if (!$employment_listingsRecord) {
print "Record not found!";
exit;
}

?>

If you know that you don't need them, you can remove the: // show error message if no matching record is found
if (!$employment_pageRecord) {
print "Record not found!";
exit;
} or change "Record not found!" to anything that you prefer.

Hope this sets you in the right direction.

Best,

Jerry Kornbluth

Hi MRI,

I know that this is probably not what you want to hear, but...

Most of the time, the easiest approach to troubleshooting is to start simple and build on that. You have all of your section editors populated with data so it should be a pretty easy task.

Try mocking mock up a simple page that displays data from one section editor, without any formatting and with only a few fields from the admin's generated code area.

Once that's working, add the next section to the page and mock up a few fields from that.

See where you get into trouble and then make the appropriate changes on your finished pages.

I'd simplify the code at the top of your page as a start so that you can get a clearer picture of what's going on.

Hope that this approach gets you closer.

You can always post the code of your pages here (no sensitive or access information) but unless a problem pops out easily, it's sometimes difficult to digest the approach that you're using and ferret out the issues.

Best,

Jerry

I got it....sorry.

Now, just need help with the removing of the header text if there are no records in that section.

Heres how its set up.. http://runningaces.mriinteract.net/employment/

in the CMS I have a Employment listings where you can add new job listings... then you select which category it show show up in.

If there are no job listings in a certain category, I would like that category header to not display.

Heres how the listings are set up:

<h3><strong>CARD ROOM</strong></h3>
<ul>
<?php foreach ($employment_listingsRecords as $record): ?>
<?php if (strpos($record['category'], 'Card Room')): ?>
<li><a href="<?php echo $record['_link'] ?>"><?php echo $record['job_title'] ?></a></li>
<?php endif ?>
<?php endforeach; ?>
</ul>

<h3><strong>FACILITIES</strong></h3>
<ul>
<?php foreach ($employment_listingsRecords as $record): ?>
<?php if (strpos($record['category'], 'Facilities')): ?>
<li><a href="<?php echo $record['_link'] ?>"><?php echo $record['job_title'] ?></a></li>
<?php endif ?>
<?php endforeach; ?>
</ul>

<h3><strong>FINANCE</strong></h3>
<ul>
<?php foreach ($employment_listingsRecords as $record): ?>
<?php if (strpos($record['category'], 'Finance')): ?>
<li><a href="<?php echo $record['_link'] ?>"><?php echo $record['job_title'] ?></a></li>
<?php endif ?>
<?php endforeach; ?>
</ul>

<h3><strong>FOOD &amp; BEVERAGE</strong></h3>
<ul>
<?php foreach ($employment_listingsRecords as $record): ?>
<?php if (strpos($record['category'], 'Food and Beverage')): ?>
<li><a href="<?php echo $record['_link'] ?>"><?php echo $record['job_title'] ?></a></li>
<?php endif ?>
<?php endforeach; ?>
</ul>

<h3><strong>HUMAN RESOURCES</strong></h3>
<ul>
<?php foreach ($employment_listingsRecords as $record): ?>
<?php if (strpos($record['category'], 'Human Resources')): ?>
<li><a href="<?php echo $record['_link'] ?>"><?php echo $record['job_title'] ?></a></li>
<?php endif ?>
<?php endforeach; ?>
</ul>

<h3><strong>INFORMATION TECHNOLOGY</strong></h3>
<ul>
<?php foreach ($employment_listingsRecords as $record): ?>
<?php if (strpos($record['category'], 'Information Technology')): ?>
<li><a href="<?php echo $record['_link'] ?>"><?php echo $record['job_title'] ?></a></li>
<?php endif ?>
<?php endforeach; ?>
</ul>

<h3><strong>MARKETING</strong></h3>
<ul>
<?php foreach ($employment_listingsRecords as $record): ?>
<?php if (strpos($record['category'], 'Marketing')): ?>
<li><a href="<?php echo $record['_link'] ?>"><?php echo $record['job_title'] ?></a></li>
<?php endif ?>
<?php endforeach; ?>
</ul>

<h3><strong>MUTUELS</strong></h3>
<ul>
<?php foreach ($employment_listingsRecords as $record): ?>
<?php if (strpos($record['category'], 'Mutuels')): ?>
<li><a href="<?php echo $record['_link'] ?>"><?php echo $record['job_title'] ?></a></li>
<?php endif ?>
<?php endforeach; ?>
</ul>

<h3><strong>RACING</strong></h3>
<ul>
<?php foreach ($employment_listingsRecords as $record): ?>
<?php if (strpos($record['category'], 'Racing')): ?>
<li><a href="<?php echo $record['_link'] ?>"><?php echo $record['job_title'] ?></a></li>
<?php endif ?>
<?php endforeach; ?>
</ul>

<h3><strong>SECURITY/SURVEILLANCE</strong></h3>
<ul>
<?php foreach ($employment_listingsRecords as $record): ?>
<?php if (strpos($record['category'], 'Security')): ?>
<li><a href="<?php echo $record['_link'] ?>"><?php echo $record['job_title'] ?></a></li>
<?php endif ?>
<?php endforeach; ?>
</ul>

Glad you got it working.

You also seem to understand "if" statements fairly well.

I've got to run out now, but I'm sure you'll get it fixed.

Best,

Jerry

Hi MRI,

Did you get your conditional header text working?

If not, you could try something like this:

<?php $found = 0; ?>
<?php foreach ($employment_listingsRecords as $record): ?>
<?php if (strpos($record['category'], 'Card Room')): ?>
<?php if (!$found): ?>
<h3><strong>CARD ROOM</strong></h3>
<ul>
<?php $found = 1; ?>
<?php endif ?>
<li><a href="<?php echo $record['_link'] ?>"><?php echo $record['job_title'] ?></a></li>
<?php endif ?>
<?php endforeach; ?>
<?php if ($found): ?>
</ul>
<?php endif ?>

Please let us know if you have any questions.

cool thanks!! I actually rigged it to work using another way which is probably more complicated... but ill give your suggestion a shot and see how it works.