Re: [chris] Displaying an Image from Another Table

Tue, 26 Jan 2010 16:40:35 -0800

That worked. Thanks.

Displaying an Image from Another Table

Mon, 25 Jan 2010 10:16:28 -0800

Hi,

Below is the code I have used for a detail page about degree 'programs'. It works well and allows me to use fields from the 'schools' table.

$urlNum = getNumberFromEndOfUrl();
list($programsRecords, $programsMetaData) = getRecords(array(
'tableName'   => 'programs',
'limit'       => '1',
'leftJoin'    => array('schools' => 'schoolNum'),
'where'       => "programs.num = $urlNum"
));
$programsRecord = @$programsRecords[0]; // get first record
// show error message if no matching record is found
if (!$programsRecord) {
header("HTTP/1.0 404 Not Found");
print "Record not found!";
exit;
}
?>

When I want to show fields from the schools table I use code like this:

I have a problem when I try to get an uploaded image from the schools table to show up. However, if I upload the image to the programs table I can show the image using this code:

 
" />

Why can't I get the image from the schools table using the same code as above (putting the 'schools.' in front of the field? In other words, the following code returns and error:

 
" />

Please let me know if there is a work around (or if I am doing something wrong). I would rather upload the school picture once in the schools table instead of potentially multiple times (sometimes 3 or 4 times) in the programs table.

Thanks.

Re: [chris] New to CMS Builder - A Few Questions

Tue, 05 Jan 2010 19:29:51 -0800

Chris,

The code you provided worked perfectly. That should do me for now.

Thanks for your help. [:)]

Re: [onlinemba] New to CMS Builder - A Few Questions

Tue, 05 Jan 2010 15:07:00 -0800

Please...not everyone all at once. [:(]

OK, I figured out #2 by reading some other posts in the forum. I also figured out the second part of #3. #1 is not longer relevant because I have a work-around.

So all I need to know is this part in #3...

"I want to be able to have the schools '_link' value show up when I view the programs List Page."

Any help would be welcomed.

New to CMS Builder - A Few Questions

Mon, 04 Jan 2010 18:55:14 -0800

Hi,

I had been using Listings Manager (LM) for an old website so I was very used to that program. However, I am now trying to do a similar website using CMS Builder. I really like CMS Builder and am starting to get the hang of it. It really is a great program. I have a few questions though...

1. This one should be an easy answer, so I will do it first. In the Section Editors area, I click 'modify' on the table I want to edit. Under the Viewer URLs tab there is a field called Filename Fields. I would like to use two fields there so my file name becomes a combination of the two fields. Is this possible? It looks like it should be possible. However, my results show that it only takes the first field.

2. I have a table for schools and a table for programs. Schools can have one or many programs. So I have a list field in the programs table that links to the schools table. I have done this by school name, not by record number. My experience with databases tells me to link by a unique value...like the schools record number. Should I be worried about this? It is much easier to link by the school name because it shows up in my programs table without using extra code. Just wondering.

3. Same tables as in question #2. I want to be able to have the schools '_link' value show up when I view the programs List Page. I think it needs some extra code for this. I also want to use another field from schools table and have it show up when I view the programs List Page. This is probably the same solution, but I want to do both.

Any help would be appreciated.