Details Page no record found

Did not work... still have the same issue..

let focus on the first issue.. then we figure out the second question i had.

ok lets try again..

http://runningaces.mriinteract.net/employment/index.php
This page lists all the job listings.. (page displays fine)

heres the header php code:

<?php

require_once "xxx";

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

?>
<?php

require_once "xxx";

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;
}

?>
<?php

require_once "xxx";

list($employment_listingsRecords, $employment_listingsMetaData) = getRecords(array(
'tableName' => 'employment_listings',
));

?>


Then when you click on a job listing... it should take you to the details page:
http://runningaces.mriinteract.net/employment/joblistings.php

this works fine: http://runningaces.mriinteract.net/employment/joblistings.php?HOUSEKEEPER-1

but any other job listing does not... i get the Record not found messages..

HEres the code on the details page:

<?php

require_once "xxx";

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

?>
<?php

require_once "xxx";

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;
}

?>
<?php

require_once "xxx";

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;
}

?>


can i send you files to review?
I think the conflict has to do with having multiple list records/single record on the same page.

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.