Listing Multiple Table Records

7 posts by 2 authors in: Forums > CMS Builder
Last Post: January 27, 2009   (RSS)

By JoeKMT - January 26, 2009

HI Dave,
Have a new one for you,
I want to getRecords from two different tableNames, to show on the same page, not sure what the snytax should look like, this doesn't work,

<?php
require_once "/home/alternat/public_html/cmsAdmin/lib/viewer_functions.php";

list($scheduleRecords, $scheduleMetaData) = getRecords(array(
'tableName' => 'schedule',
));
list($small_groupRecords, $small_groupMetaData) = getRecords(array(
'tableName' => 'small_group',
));

?>

I just don't know PHP code that well, but I can see using CMS Builder will force me to learn it faster, which is a good thing. Can you help me out here?

Thanks!

Joe

Re: [JoeKMT] Listing Multiple Table Records

By Dave - January 26, 2009

Hi Joe,

That looks perfect to me. Is it giving you an error?

You also need to copy and paste the code further down the page the displays the records.

Let me know some more details and I'll try to help.
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] Listing Multiple Table Records

By JoeKMT - January 26, 2009

Here is the error I'm getting,

getRecords(small_group): Unknown field 'title' in filenameFields or titleField options!

Just not sure what this is.

Joe

Re: [JoeKMT] Listing Multiple Table Records

By Dave - January 26, 2009

Can you attach your viewer file?
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] Listing Multiple Table Records

By JoeKMT - January 26, 2009

Here is the Viewer Code as I have it on my page.

Joe
Attachments:

viewer-code_001.txt 8K

Re: [JoeKMT] Listing Multiple Table Records

By JoeKMT - January 26, 2009

Found it Dave, Section Editor/Viewer URLs/Filename Fields, I had a invalid name of "title" listed.

Thanks for all of your help!!!!!

Joe [;)]

Re: [JoeKMT] Listing Multiple Table Records

By Dave - January 27, 2009

Glad to hear it's working! :) Let us know if you need anything else.
Dave Edis - Senior Developer
interactivetools.com