Re: [JoeKMT] Listing Multiple Table Records

Mon, 26 Jan 2009 17:29:26 -0800

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: [Dave] Listing Multiple Table Records

Mon, 26 Jan 2009 16:30:11 -0800

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

Joe

Re: [Dave] Listing Multiple Table Records

Mon, 26 Jan 2009 16:17:29 -0800

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

Listing Multiple Table Records

Mon, 26 Jan 2009 14:11:00 -0800

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,

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] Displaying Records Question.

Thu, 22 Jan 2009 15:07:04 -0800

Thanks Dave for all of your timely help, I'll let you know if I get stuck again.

Joe

Re: [Dave] Displaying Records Question.

Thu, 22 Jan 2009 15:01:17 -0800

Sorry about the link, here it is again
http://irvine.directrouter.com/~alternat/pages/schedule.php

I think I understand the code you posted, it adds the table cells if there is a record to post, could still take a look at the link, let me know if you see anything wrong.

Thanks,

Joe

Re: [Dave] Displaying Records Question.

Wed, 21 Jan 2009 17:18:33 -0800

Here is a link to the web page to see how it is being displayed.http://irvine.directrouter.com/~alternat/schedule.php

I have also uploaded the viewer code.

Thanks for your fast response.

Joe

Displaying Records Question.

Wed, 21 Jan 2009 07:54:37 -0800

I have created a monthly class schedule for a personal trainer, Monday through Saturday are available to have records added but right now not all days of the week have a class, what code would I use to 1. Display only if there is a record and 2.How do I make the table the records display in collapsible only showing the days there is a class.

Thanks!