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: [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