https://interactivetools.com/forum/forum-search.php?k=user%3Ajjem Mon, 13 Apr 2026 12:02:14 -0700 en-us Showing records from several tables on a detail page https://interactivetools.com/forum/forum-posts.php?postNum=2232323#post2232323 Hi Ross,

Here is the missing file (discographie).

About the sorting option I'll try to make it as clear as I can...

I need to be able to sort the records called from another table. For example in the Creations, when I select multiple records in the interpretes field, I need to be able to give a sort order which can be different from what the pulldown shows or from the sorting setting.

Example: the pulldown list shows:

  1. John Doe, piano
  2. Phiharmonia Orchestra
  3. Charles Dutoit, conductor

I'd like it to appear fronted like:

  1. Philharmonia Orchestra
  2. Charles Dutoit, conductor
  3. John Doe, piano

I hope this makes it clearer.

Thanks again,

Jeremy

]]> Wed, 06 Nov 2013 04:30:18 -0800 forum-posts.php?postNum=2232323#post2232323 Showing records from several tables on a detail page https://interactivetools.com/forum/forum-posts.php?postNum=2232218#post2232218 Hi Ross,

I'm out of office these days... I'll post the needed information tomorrow.

Thanks,

Jeremy

]]> Wed, 23 Oct 2013 08:54:59 -0700 forum-posts.php?postNum=2232218#post2232218 Showing records from several tables on a detail page https://interactivetools.com/forum/forum-posts.php?postNum=2232182#post2232182 Hi Ross,

Here are the files, there is one table I did not create yet, it's the Discography. But I guess the process will be the same as for the others.

Thank you!

Jeremy

]]> Fri, 18 Oct 2013 06:06:49 -0700 forum-posts.php?postNum=2232182#post2232182 Showing records from several tables on a detail page https://interactivetools.com/forum/forum-posts.php?postNum=2232148#post2232148 Hi,

I have 4 tables:

1) Works

2) Interpretes

3) Premieres

4) Discography

here is what I am trying to do:

1) Enter records into the "interpretes" table (name, first_name, function fields)

2) In the  "Premieres" table, I need to make a list field (pull down multivalue) with an advanced MYSQL query that lists the fields from "interpretes" in the following way:

name first_mane (function). In the viewer code I'd need to be able to custom sort them.

3) in the "Works" table, I need to be able to pull the info from the "premieres" table, including the name first_mane (function) fields from the "interpretes" table as well as the custom sorting

Is this possible? I have no idea where to start to solve the custom sorting in point 2) and the point 3). If needed I'd hire you.

Thanks so much for your help,

Jeremy

]]> Thu, 17 Oct 2013 07:08:56 -0700 forum-posts.php?postNum=2232148#post2232148 Permalink breaks record display of linked table https://interactivetools.com/forum/forum-posts.php?postNum=2231197#post2231197 Hi,

just bought the permalink add-on. Since then, for the records I entered a permalink, some information does not appear anymore. All other records which do not have a permalink set, this field is diplaying. Here is the page code at the top of the page:

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/chroot/home/jfzbinde/jfzbinden.ch/html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }
list($oeuvresRecords, $oeuvresMetaData) = getRecords(array(
'tableName' => 'oeuvres',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$oeuvresRecord = @$oeuvresRecords[0];
if (!$oeuvresRecord) { dieWith404("Record not found!"); }
?>
<?php list($editeursRecord) = getRecords(array(
'tableName' => 'editeurs',
'where' => "num = '{$oeuvresRecord['editeur']}'",
'limit' => '1',
));
$editeursRecord = @$editeursRecord[0]; // get first record
?>
<!DOCTYPE html>  etc.

and here is the concerned issue (in red). 

<dl class="dl-horizontal">
<?php if ($oeuvresRecord['texte'] != ""): ?><dt>Texte:</dt><dd><?php echo $oeuvresRecord['texte'] ?></dd><?php endif ?>
<?php if ($oeuvresRecord['instrumentation'] != ""): ?><dt>Instrumentation:</dt><dd><?php echo $oeuvresRecord['instrumentation'] ?></dd><?php endif ?>
<?php if ($oeuvresRecord['dedicace'] != ""): ?><dt>Dédicace:</dt><dd><em><?php echo $oeuvresRecord['dedicace'] ?></em></dd><?php endif ?>
<?php if ($oeuvresRecord['commande'] != ""): ?><dt>Commande:</dt><dd><?php echo $oeuvresRecord['commande'] ?></dd><?php endif ?>
<?php if ($oeuvresRecord['mouvements'] != ""): ?><dt>Mouvements:</dt><dd><?php echo $oeuvresRecord['mouvements'] ?></dd><?php endif ?>
<?php if ($editeursRecord['internet'] != ""): ?><dt>Editeur:</dt><dd><a href="http://<?php echo $editeursRecord['internet']; ?>" /><?php echo $editeursRecord['raison_sociale']; ?></a></dt><?php else: ?><dt>Editeur:</dt><dd><?php echo $editeursRecord['raison_sociale']; ?></dd><?php endif ?>
<?php if ($oeuvresRecord['remarques'] != ""): ?><dt>Remarques:</dt><dd><?php echo $oeuvresRecord['remarques'] ?></dd><?php endif ?>

<?php if ($oeuvresRecord['oe_creations'] != ""): ?><dt>Création:</dt><dd><?php echo join(', ', getListLabels('oeuvres', 'oe_creations', $oeuvresRecord['oe_creations'])); ?></dd><?php endif ?>
</dl>
<hr/>
<?php if (!$oeuvresRecord): ?>
No record found!<br/><br/>
<?php endif ?>
<!-- /STEP2: Display Records -->


<a href="<?php echo $oeuvresMetaData['_listPage']; ?>">&lt;&lt; Retour à la liste</a> -
<a href="mailto:?subject=<?php echo urlencode(thisPageUrl()) ?>">Envoyer cette page</a>

]]> Thu, 11 Jul 2013 06:05:26 -0700 forum-posts.php?postNum=2231197#post2231197 URGENT: New install on existing Database https://interactivetools.com/forum/forum-posts.php?postNum=2231194#post2231194 my hosting company had a backup of the files... learned the hard way! Thanks for your help anyway.

Jeremy

]]> Thu, 11 Jul 2013 02:56:53 -0700 forum-posts.php?postNum=2231194#post2231194 URGENT: New install on existing Database https://interactivetools.com/forum/forum-posts.php?postNum=2231178#post2231178 Hello,

Just upgraded to latest version of CMS Builder. I did a DB backup before doing it. Somehow, I used a new ftp software that did replace all the CMSAdmin folder instead of uploading the files into it.

Now when I try to login in, it goes to the installer, and doesn't find the backup file. What can I do?

Thanks for your help,

Jeremy

]]> Wed, 10 Jul 2013 04:31:18 -0700 forum-posts.php?postNum=2231178#post2231178 Product listing: check two category fields https://interactivetools.com/forum/forum-posts.php?postNum=2231160#post2231160 That's it... thanks a lot.

Jeremy

]]> Tue, 09 Jul 2013 00:19:59 -0700 forum-posts.php?postNum=2231160#post2231160 Product listing: check two category fields https://interactivetools.com/forum/forum-posts.php?postNum=2231143#post2231143 Hi,

I do have a listing of musical works. On a one page layout, it selects works from different categories ID and put them under subtitles.

For now this is my code (which is working) but I need it to check "categorie2" field each time as well because some works appear in 2 different categories (I made two categories fields in my "works" table).

Thanks for your help

Jeremy

<!-- Musique cordes -->
         <section id="oeuvrescordes">
          <div class="page-header">
          <h3>Cordes</h3>
          </div>
          <?php foreach ($oeuvresRecords as $record): ?>
          <?php if ($record['categorie'] == '12'): ?>
          <h4><?php echo $record['titre'] ?></h4>
          <p><?php echo $record['formation'] ?></p>
          <p><a href="<?php echo $record['_link'] ?>">Détails</a></p>
          <?PHP endif ?>
          <?php endforeach; ?>
          </section>
 <!--section -->
<!-- Musique vents -->
         <section id="oeuvresvents">
          <div class="page-header">
          <h3>Vents</h3>
          </div>
          <?php foreach ($oeuvresRecords as $record): ?>
          <?php if ($record['categorie'] == '13'): ?>
          <h4><?php echo $record['titre'] ?></h4>
          <p><?php echo $record['formation'] ?></p>
          <p><a href="<?php echo $record['_link'] ?>">Détails</a></p>
          <?PHP endif ?>
          <?php endforeach; ?>
          </section>
 <!--section -->
<!-- Musique vents -->
         <section id="oeuvresmixte">
          <div class="page-header">
          <h3>Instruments mixtes</h3>
          </div>
          <?php foreach ($oeuvresRecords as $record): ?>
          <?php if ($record['categorie'] == '14'): ?>
          <h4><?php echo $record['titre'] ?></h4>
          <p><?php echo $record['formation'] ?></p>
          <p><a href="<?php echo $record['_link'] ?>">Détails</a></p>
          <?PHP endif ?>
          <?php endforeach; ?>
          </section>
 <!--section -->

]]> Mon, 08 Jul 2013 07:50:04 -0700 forum-posts.php?postNum=2231143#post2231143 Showing records from 2 tables https://interactivetools.com/forum/forum-posts.php?postNum=2231093#post2231093 Hi,

I will try to make this clearer, sorry.

I first enter the first_name and the name of the performers in the "performers" table.

In the "Creations" table, I enter date, venue, etc. and I can then choose a performer in a list (multi check list) that comes from the "perfoermers" table.

I then create a work in the "works" table, where I can associate a creation to it (drawn from the "creations" table). In that multi check field I was able to show the date and city but the performer is shown only by its "num" and not first_name, name. See attached file.

In clear;)

I am trying to associate a creation that has one or more performers to a work.

]]> Mon, 01 Jul 2013 08:39:44 -0700 forum-posts.php?postNum=2231093#post2231093 Showing records from 2 tables https://interactivetools.com/forum/forum-posts.php?postNum=2231041#post2231041 Hello,

This doesn't concern the front end but only cmsAdmin.

I have 3 tables:

"works", "creations", "performers".

in the "creations" table, I have a list fields where I can select "performers" (by first_name and name).

in the "works" table, I would like to be able to select from a list that comes from the "creations" table.

it works but I'd like to show the "performers"  first_name, and  name. For now it only shows  "num" field, which doesn't help.

Thanks for your help

]]> Fri, 21 Jun 2013 06:16:42 -0700 forum-posts.php?postNum=2231041#post2231041 show multiple records under a same article https://interactivetools.com/forum/forum-posts.php?postNum=2229445#post2229445 Hi Greg,

The one section solution was indeed the best idea.

Thanks again for your suggestion!

Jeremy

]]> Wed, 13 Feb 2013 12:11:49 -0800 forum-posts.php?postNum=2229445#post2229445 show multiple records under a same article https://interactivetools.com/forum/forum-posts.php?postNum=2229441#post2229441 Hi Greg,

thanks for you reply. Yes they are linked as in the knowledge base you mentioned.

I am trying to see how I could combone the two sections and let you know how it worked out.

Thank you,

Jeremy

]]> Wed, 13 Feb 2013 10:49:52 -0800 forum-posts.php?postNum=2229441#post2229441 show multiple records under a same article https://interactivetools.com/forum/forum-posts.php?postNum=2229435#post2229435 Hello,

I am trying to set up an admin control of a slider.

1) I created a "Slides" section where the user just enters a slide id and a background image (in red below). I will the include the correct code from the code generator.

Within those "Slides" there are text and "front" images that have to be controled from the admin.

2) I created a slide_images section (as a category section) where the user can upload the "front images" and other informations into different fields (in green below).

The structure would be:

<section id="feature_slider" class="">

<article class="slide" id="showcasing" style="background: url('img/backgrounds/landscape.png') repeat-x top center;">

       <img class="asset left-30 sp600 t120 z1" src="img/slides/scene1/macbook.png" />

       <div class="info">
       <h2>Beautiful theme for showcasing your works.</h2>
       </div>
</article>
<article class="slide" id="ideas" style="background: url('img/backgrounds/aqua.jpg') repeat-x top center;">
       <div class="info">
      <h2>We love to turn ideas into beautiful things.</h2>
      </div>
      <img class="asset left-480 sp600 t260 z1" src="img/slides/scene2/left.png" />
      <img class="asset left-210 sp600 t213 z2" src="img/slides/scene2/middle.png" />
      <img class="asset left60 sp600 t260 z1" src="img/slides/scene2/right.png" />
</article>
<article class="slide" id="tour" style="background: url('img/backgrounds/color-splash.jpg') repeat-x top center;">
<img class="asset left-472 sp650 t210 z3" src="img/slides/scene3/ipad.png" />
<img class="asset left-365 sp600 t270 z4" src="img/slides/scene3/iphone.png" />
<img class="asset left-350 sp450 t135 z2" src="img/slides/scene3/desktop.png" />
<img class="asset left-185 sp550 t220 z1" src="img/slides/scene3/macbook.png" />
<div class="info">
<h2>Fully Responsive theme</h2>
<a href="features.html">TOUR THE PRODUCT</a>
</div>
</article>
<article class="slide" id="responsive" style="background: url('img/backgrounds/indigo.jpg') repeat-x top center;">
<img class="asset left-472 sp600 t120 z3" src="img/slides/scene4/html5.png" />
<img class="asset left-190 sp500 t120 z2" src="img/slides/scene4/css3.png" />
<div class="info">
<h2>
Responsive <strong>HTML5 & CSS3</strong>
Theme
</h2>
</div>
</article>
</section>

How can include the slide_images  information within the "Slides". Could anyone help?

Many Thanks,

Jeremy

]]> Wed, 13 Feb 2013 08:13:08 -0800 forum-posts.php?postNum=2229435#post2229435 License expired? https://interactivetools.com/forum/forum-posts.php?postNum=2229332#post2229332 Hi, I had for long a license for a website. I just wanted to access the admin and it says: your license has expired.

What do I have to do. I did not know that CMS Builder licenses expire...

Thanks

]]> Tue, 05 Feb 2013 05:35:03 -0800 forum-posts.php?postNum=2229332#post2229332 Re: [chris] list categories https://interactivetools.com/forum/forum-posts.php?postNum=2201658#post2201658
So I have all CD's listed under to top category. Then part of them are listed under the first sub-category again. Then they are listed again in the second subcategory.... see new attachement.

Sorry for the trouble...
]]> Fri, 05 Feb 2010 16:29:40 -0800 forum-posts.php?postNum=2201658#post2201658 Re: [chris] list categories https://interactivetools.com/forum/forum-posts.php?postNum=2201655#post2201655
See attachement....
]]> Fri, 05 Feb 2010 15:49:23 -0800 forum-posts.php?postNum=2201655#post2201655 Re: [chris] list categories https://interactivetools.com/forum/forum-posts.php?postNum=2201592#post2201592
Thanks for the hint. here is the full page code. I still get only the (sub)categories listed as wanted but the content (<?php echo $discographyRecord['title'] ?>) doesn't appear... I'd much appreciate another "coup de pouce" (help)...
Result of that page in the attached screenshot


<?php
require_once "/.../.../.../.../html/cmsAdmin/lib/viewer_functions.php";
list($cd_categoriesRecords, $selectedCategory) = getCategories(array(
'tableName' => 'cd_categories',
));

list($discographyRecords, $discographyMetaData) = getRecords(array(
'tableName' => 'discography',
));

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title> Discography</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<link rel="stylesheet" type="text/css" href="css/360player.css" />
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
<script src="http://cdn.jquerytools.org/1.1.2/full/jquery.tools.min.js"></script>
<script type="text/javascript" src="js/berniecode-animator.js"></script>
<script src="js/soundmanager2.js" language='JavaScript' type="text/javascript"></script>
<script src="js/360player.js" language='JavaScript' type="text/javascript"></script>
</head>
<body>
<?php include('includes/header.html'); ?>
<div id="contentWrapper">
<div class="pageTitle">Discography</div>
<!-- InstanceBeginEditable name="pageContent" -->
<div class="pageContent">
<ul>

<?php foreach ($cd_categoriesRecords as $categoryRecord): ?>
<?php echo $categoryRecord['_listItemStart'] ?>
<?php if ($categoryRecord['_isSelected']): ?>
<b>
<?php endif ?>
<?php echo $categoryRecord['name'] ?>
<?php if ($categoryRecord['_isSelected']): ?>
</b>
<?php endif ?>

<?php foreach ($discographyRecords as $discographyRecord): ?>
<?php if ($discographyRecord['category'] != $categoryRecord['num']) { continue; } // skip records which aren't in this category ?>
<?php echo $discographyRecord['title'] ?>
<?php endforeach ?>


<?php echo $categoryRecord['_listItemEnd'] ?>
<?php endforeach ?>
</ul>

<?php if (!$discographyRecords): ?>
No records were found!<br/>
<br/>
<?php endif ?>
</div>
</div>
</body>
</html>
]]> Wed, 03 Feb 2010 15:02:57 -0800 forum-posts.php?postNum=2201592#post2201592 Re: [gkornbluth] list categories https://interactivetools.com/forum/forum-posts.php?postNum=2201468#post2201468
It definitely got me closer. The screenshot 1.png is what I get. Screenshot 2.png is what I try to achieve. So it is like a menu tree, but the titles of the articles have to show up directly under the categories or subcategories.

Here is the code I used:
<ul>
<li><a href="?">(All Articles)</a></li>
<?php foreach ($cd_categoriesRecords as $categoryRecord): ?>
<?php echo $categoryRecord['_listItemStart'] ?>
<?php if ($categoryRecord['_isSelected']): ?>
<b>
<?php endif ?>
<a href="?category=<?php echo $categoryRecord['num'] ?>"><?php echo $categoryRecord['name'] ?></a>
<?php if ($categoryRecord['_isSelected']): ?>
</b>
<?php endif ?>
<?php echo $categoryRecord['_listItemEnd'] ?>
<?php endforeach ?>
</ul>
<!-- content -->
<?php foreach ($discographyRecords as $record): ?>
<?php echo $record['title'] ?><br/>
<?php endforeach ?>
<?php if (!$discographyRecords): ?>
No records were found!<br/>
<br/>
<?php endif ?>
<!-- end content -->
Wondering if I could integrate the content part into the menu. I actually do not need it as a menu, it is more a tree in list view. Any hint would be great. Thanks
]]> Thu, 28 Jan 2010 15:45:29 -0800 forum-posts.php?postNum=2201468#post2201468 list categories https://interactivetools.com/forum/forum-posts.php?postNum=2201441#post2201441
I would like sort records the list view like following:

Category 1
Sub Category 1
Product 1
Product 2
Product 3
Sub Category 2
Product 1
Product 2
Product 3

Category 2
Sub category 1
Product 4
Product 5
Product 6

I did start to do it manually like this

<!-- Solo Records -->
<h2>Solo recording</h2>
<?php list($discographyRecords, $discographyMetaData) = getRecords(array(
'tableName' => 'discography',
'where' => 'solo_orchestral = "solo"',
)); ?>
<?php foreach ($discographyRecords as $discographyRecords): ?>
<?php echo $discographyRecords['orchestra'] ?><br/>
<?php echo $discographyRecords['conductor'] ?><br/>
<?php echo $discographyRecords['title'] ?><br/> etc
then

<!-- Orchestra Records -->
<h2>Orchestral Recordings</h2>
<?php list($discographyRecords, $discographyMetaData) = getRecords(array(
'tableName' => 'discography',
'where' => 'solo_orchestral = "orchestra"',
)); ?>
<?php foreach ($discographyRecords as $discographyRecords): ?>
<?php //echo $discographyRecords['orchestra'] ?><br/>
<?php echo $discographyRecords['conductor'] ?><br/>
<?php echo $discographyRecords['title'] ?><br/>

I cannot find anything on this forum where I could start to dynamically set this up. Any hint would be great... Thanks for your help
]]> Wed, 27 Jan 2010 16:44:58 -0800 forum-posts.php?postNum=2201441#post2201441 Re: [Dave] Image vars https://interactivetools.com/forum/forum-posts.php?postNum=2193061#post2193061
The fact is my gallery does not work because I have the <?php break; ?> to show only one image per record in the List.

The <a rel="rokbox[650 424] (<?php echo $record['num']?>)" was to group the rest of the pictures of each record (album) into a slideshow (mootools).

[:/]
]]> Fri, 22 Aug 2008 09:40:16 -0700 forum-posts.php?postNum=2193061#post2193061 Re: [Dave] Image vars https://interactivetools.com/forum/forum-posts.php?postNum=2193058#post2193058 J
]]> Fri, 22 Aug 2008 08:58:19 -0700 forum-posts.php?postNum=2193058#post2193058 Image vars https://interactivetools.com/forum/forum-posts.php?postNum=2193055#post2193055 I would like the record num and not the upload num, below in the bold php tag. How do I get this done? Have been searching through the posts with no success...

Thanks for your help.

(By the way, Dave, thanks for the help on the contact form issue...)
Jeremy

<?php foreach ($galleryRecords as $record): ?>
<h3><?php echo $record['title'] ?></h3>
<p>
<?php foreach ($record['pictures'] as $upload): ?>

<?php if ($upload['hasThumbnail']): ?>
<a rel="rokbox[650 424](<?php echo $records['num']?>)" href="<?php echo $upload['urlPath'] ?>" title=""><img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="" /></a><br/>
<?php elseif ($upload['isImage']): ?>
<img src="<?php echo $upload['urlPath'] ?>" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" alt="" /><br/>
<?php else: ?>
<a href="<?php echo $upload['urlPath'] ?>">Download <?php echo $upload['filename'] ?></a><br/>
<?php endif ?>
<?php break; ?>
<?php endforeach ?></p>
]]> Fri, 22 Aug 2008 05:37:10 -0700 forum-posts.php?postNum=2193055#post2193055 undefined variable: SETTINGS in init.php https://interactivetools.com/forum/forum-posts.php?postNum=2192986#post2192986
I'm using 1.22 CMS Builder. I get this message on my contact form page:

Notice: Undefined variable: SETTINGS in /home/www/d5f077c.../web/cmsAdmin/lib/init.php on line 32 Notice: Undefined variable: SETTINGS in /home/www/d5f077.../web/cmsAdmin/lib/viewer_functions.php on line 9 Error: You must install the program before you can use the viewers.

Any idea of what the problem is?
Thanks,
Jeremy
]]> Mon, 18 Aug 2008 08:21:40 -0700 forum-posts.php?postNum=2192986#post2192986 Re: [Dave] Multiple View in V.1.15 https://interactivetools.com/forum/forum-posts.php?postNum=2191706#post2191706 J
]]> Sat, 24 May 2008 08:19:18 -0700 forum-posts.php?postNum=2191706#post2191706