Search Types in Section Editors

Fri, 04 Oct 2013 11:00:22 -0700

Where is the information on Search Types that appear in the Section Editors? The editor states that more information can be found in the docs, but I can't find it.

Re: [Tom P] Listing ALL records after search

Tue, 27 Dec 2011 15:08:37 -0800

Thanks, Tom. Works Great!

I actually had done exactly what you suggested earlier except that I had not added the allowSearch parameter and set it to "false". That was all that I was missing.

Here is what I wound up adding:

  list($listingDDRecords, $listingDDDetails) = getRecords(array(
    'tableName'   => 'listings',
	'allowSearch'      => false, 
	'loadCreatedBy'  => false, 
	'loadUploads'      => false, 
  ));

The critical part is the allowSearch parameter! Thanks for replying to my post so quickly. I should be launching their site very soon. It's really coming together nicely.

Listing ALL records after search

Tue, 27 Dec 2011 11:48:05 -0800

I am trying to create a page that has a search form on it to search records (listings) on a CMS Builder powered realty website. Everything works great except for one thing. My dropdowns are auto-populated from fields in the "listings" DB table. The problem is that after a search, the page (which still has a search form on the left side of the page) now only shows the drop down values that pertain to the result returned from the previous search.

I want ALL applicable field records to be shown in the search form drop down menus ALWAYS, regardless of a previous search. For example, there is a "county" dropdown field that should always show all unique counties from that exist in the current listings. As I said, it works great until you perform the first search, then the dropdowns narrow themselves so that they are pulled from the set of the returned results.

How do I force what I am wanting without messing up the returned results that should be shown to the viewer normally?

Thanks,
Keith D Sellars
WebGraffix Media Solutions, LLC
http://www.webgraffix.com

Nesting multi records?

Thu, 08 Sep 2011 15:01:08 -0700

I have created a multi-record editor. I would like to create the ability to add another multi-record function inside of the editor. What I want to do is allow a user to add bullets to a field and then drag and sort as necessary. Is this possible?

Here's my exact situation:
1 - I created a Multi-record editor titled "Jobs".
2 - One of the fields is titled "Education and Experience".
3 - I would like to user to add bullets, one by one, until they add as many or few as they want. Ideally, the user would also be able to drag and drop to sort the list as necessary.
4 - I can format the output in php with whatever custom code is needed for the resultant html.
5 - The "Education and Experience" bulletted list would be different for almost every job that is posted.

Again, is it possible to do what I'm asking?

Thanks in advance,
Keith D Sellars
WebGraffix Media Solutions, LLC
http://www.webgraffix.com

Re: [zip222] Total records

Tue, 31 Aug 2010 15:15:48 -0700

Thanks. I had JUST figured that out:

'orderBy' => 'RAND()',

... much appreciated for the quick reply.

You original answer will help me out in the future as well, I am sure.

Thanks again,
Keith D Sellars

Total records

Tue, 31 Aug 2010 14:57:52 -0700

How do I determine the total number of records through the section viewer code? I am using a php random number generator function to pull a number at random within a certain range of numbers.

What I want to do is this:
The php function I'm using is:
$random = rand(1, 5);
... but as you can see, the 5 in this case has to be the max number of existing records. Therefore, I need to determine what the number of records is, in a variable, so that I can pass it to this function.

I think I use the getRecords function for CMS, but am not sure exactly how to do that (or if that is what I even need to use).

How do I get this "total records" value, OR if there is a simpler way to grab a record at random in the header code, how do I do that?

Thanks in advance,
Keith D Sellars

Re: [Jason] Auto templates

Wed, 11 Aug 2010 10:43:26 -0700

Jason,

I actually had already implemented one of your solutions partially. I did indeed create a dropdown from the Staff page. However, the issue that I had was not all of the Staff members were set up as "users". As a result, what I wound up doing was setting up user accounts with the exact same name as what exists for the staff members. This was what I had to do in order to pull in the createdBy field as well as all of the information located on the staff page (name, phone, email, etc.).

I know what I did is not the truest way that it should be done, but it works. If I do another car dealership in the future, I would prefer to get you to help me get the code be the cleanest it can be. There are one or 2 things that I didn't do because of this issue, but they were minor things that didn't really matter.

Overall, I'm very pleased with the result - http://www.southwindford.com. My main reason for posting this was to let you guys know that I think the templates themselves need some slight modification so that they work completely as they should "out of the box".

Auto templates

Tue, 10 Aug 2010 12:04:31 -0700

I purchased the Auto templates last week and have designed a website using them (with the CMS software).

We just launched the website, http://www.southwindford.com.

During the design, the website owner alerted me of a problem. The "listed by" field in the "listings.php" and "ListingsDetail.php" files weren't pulling in the person's name that created the listing, but rather were pulling in the last person listed on the Home Pages editor (I've renamed my editor to "Staff").

Looking into the code, I saw that there was no mechanism that ties listings to staff, or even to the "user", on either of these pages. I believe this is a flaw in the template. Can you please confirm this to me?

I believe that there needs to be some sort of modification, possibly to the "listings" table that allows the person making a new listing to select the desired person from the Home Pages (staff, in my case), table.

It will probably be somewhat simple for you guys to do, but for me, when "joins" are included in the mysql queries, I get lost.

I programmed some work-arounds for this, but am not completely happy with the way I "fixed" it.

Would you please look into this and if you confirm what I'm saying, let me know what the corrections are either by posting them here or sending updated files?

Thanks,
Keith D Sellars
WebGraffix Media Solutions, LLC

Re: [webgfx] Search Form Basics

Fri, 06 Aug 2010 09:49:23 -0700

Never mind guys. I looked at the online documentation at http://www.interactivetools.com/docs/cmsbuilder/viewer_search.html and it helped me get everything I needed.

Works great!

Search Form Basics

Fri, 06 Aug 2010 09:07:34 -0700

I am working on a very simple form at http://www.southwindford.com/index.php. The page that it should post to is
http://www.southwindford.com/all_vehicle_listings.php.

There are 4 fields on my form - 2 radio buttons and 2 dropdown boxes. For some reason, the form is simply not working. Can you tell me what the basics of the search form are?

FYI, the radio buttons search a field called "condition" which is a dropdown field on the "listings" section editor. The only 2 options for the "condition" field are either "New" or "Used".

One text field is titled "year", and is a dropdown field on the "listings" editor.

The second text field is titled "category_name". It also exists as a field on the "listings" editor, but is created by the "get options from database" feature. (It is ultimately a field in a table named "vehicle_category").

The form returns empty results no matter what is posted. I want it to return only results that match all conditions (new or used, year, and vehicle category). What do I need to do to make this work?

Re: [Donna] Advanced Menu dynamic description missing

Tue, 30 Mar 2010 09:21:47 -0700

Thanks, Donna. That seemed to do it. I cleared the cache per your instructions, restarted Firefox and everything seems to be working just as it should. Thank you very much!!!

Multiple dynamic category levels

Mon, 29 Mar 2010 17:49:23 -0700

I need to be able to create a set of categories which can be accessed in a dropdown menu when the CMS user adds items (products in this case), to their database. I know how to do this, but I also need to be able to create a set of subcategories as well, which are also accessible in a dropdown list. I wouldn't mind if they were all on the same list as long as they were grouped by their parent category.

Ideally, it would be a dynamic javascript driven list which would populate itself based on their selection of categories.

How would I accomplish this? To see where I'm going with this, take a look at http://www.sharberoil.com/products_services.php. The product subcategories, for instance, are things like BF Goodrich, Cooper Tires, etc.

When I get through, this text will link to a page showing a list of products that are all related. The user will then be able to click onto a product to see detailed information, including a photo, description, etc.

How would I go about this? Any insight would be greatly appreciated.

Re: [Jason] Advanced Menu dynamic description missing

Mon, 29 Mar 2010 16:35:36 -0700

OK, just figured out a little bit more for you. I did what you suggested (reloading the file). Didn't have any effect. However, I tried it it Internet Explorer 8 and it works fine. It just doesn't work in FireFox 3.5.8.

Also, I think I found another minor issue. The General Settings page kept asking me for a Website Root Directory. After some investigation, I discovered that the variable "webRootDir" was not in the default settings.dat.php file at all. I created it and it works fine, but wanted to let you know in case it wasn't related to my upgrade.

Advanced Menu dynamic description missing

Mon, 29 Mar 2010 15:32:24 -0700

I just upgraded a CMSB installation to version 2.03. Everything seems OK, except that if I want to add a new section editor, the description for the "advanced menu types" is missing. I have a different site that uses version 2.01 and it works fine.

I've tried to troubleshoot it and I see in the lib/menus/database/addTable_functions.js file, the very last function should be handling this, but all I see is "..." where the description should be in the editor. No matter if I select anything or not, the description never appears.

Somewhere I ran across a reference to a bug fix for this, but can't locate it anymore.

Can you help me out please?

Entering multiple records at once

Fri, 27 Nov 2009 12:08:23 -0800

I have set up a section editor that allows rows of data to be entered with each row containing about 10 columns (or fields). This is numerical data for a client.

The section editor is a multi-record type. The issue that I've run into is that when entering records, only 1 record can be entered at a time. This, of course, is not normally a problem since it is the standard way of entering data manually. Each record can be thought of as simply a row of numerical data in different columns. Is there any way possible to enter several new records ("rows") at once before "saving", like, for instance, MS Excel would allow you to do?

It would really save my client quite a bit of time entering data, but I think what I'm wanting to do is not possible realistically, but thought I'd ask.

Thanks,
Keith D Sellars
WebGraffix Media Solutions, LLC
http://www.webgraffix.com

Re: [Dave] Searching for multiple keywords in multiple fields

Thu, 19 Nov 2009 08:33:39 -0800

THANK YOU GUYS!!! The latest suggestion worked great although I had another issue to deal with that it caused. When I inserted the new "input" name values for the form submission (as suggested), I ran into a problem with the fact that I am passing category names to the page via the URL. I corrected that issue and everything works perfectly now with the direct links as well as the search function.

[:)]
Keith D Sellars
WebGraffix Media Solutions
www.webgraffix.com

Re: [chris] Searching for multiple keywords in multiple fields

Fri, 13 Nov 2009 16:54:40 -0800

Chris, the link method that Dave posted works (ie, http://www.bainbridgegachamber.com/membersSearch.php?name,notes_query=bruce mann, but not the method using the form submission that you posted.

For instance, one listing has the following in its "notes" field:
- Offers accounting services, businesses and individuals.

The "name" field for this listing contains the following:
Bruce D. Mann, CPA

If I search for any multiple word term in which the words are not in the exact order, then the query returns a blank result. How do I get Dave's results, but using a search form like I am using?

Again, the URL is:
http://www.bainbridgegachamber.com/membershipListingsNEW.php

The "accounting" and "Air Conditioning and Heating" categories are the best to use for testing purposes since they contain notes and have multiple listings in each category.

We're close to what I need. What do I need to do in order to get it exactly right using the form to allow for the search rather than a direct link?

Thanks,
Keith D Sellars
http://www.webgraffix.com

Searching for multiple keywords in multiple fields

Mon, 09 Nov 2009 09:07:48 -0800

I have a list viewer that shows a list of member categories for a Chamber of Commerce (http://www.bainbridgegachamber.com/members.php). Each category can then have multiple member listings, each of which contains 5 or 6 different fields. The member category page also has a search function.

I want the search function to show results if ALL of the keywords typed into the search field exist regardless of the order. I want 2 fields searched - name & notes_keyword.

Currently, unless there is an exact match of words in the search field (in the exact order), it won't return anything. For instance, I can search for "accounting services, businesses" and it returns results, but if I search for " businesses, accounting services", it returns no results.

I'm assuming I need a custom mysql query in the list viewer. How would I do this?

Re: [Dave] Search forms searching multiple fields

Mon, 03 Aug 2009 09:31:22 -0700

Dave,

Works great! Many thanks!

[:)]

Keith D Sellars
WebGraffix Media Solutions, LLC
http://www.webgraffix.com

Re: [Dave] Notice: Announce your new CMS Builder websites here!

Tue, 28 Jul 2009 16:39:16 -0700

Bainbridge - Decatur Chamber of Commerce - http://www.bainbridgegachamber.com.

Entire site is editable through CMS Builder. Includes the ability for the site owner to create membership categories and then enter individual member listings which can be assigned to multiple categories at once. I am sorting the member categories and listings so that they display alphabetically regardless of the dragSortOrder in CMS Builder.

Re: [Dave] Notice: Announce your new CMS Builder websites here!

Tue, 28 Jul 2009 16:36:16 -0700

Albany Motor Speedway - http://www.albanymotorspeedway.net.

All pages on the site are editable through CMS Builder. The home page only lists the first 10 racers from one of several classes of racers. Each reload of the page loads a different listing at random. The coding was very complex for me, but works out well for the website owners because almost the entire website is editable through CMS Builder.

Search forms searching multiple fields

Tue, 28 Jul 2009 16:32:00 -0700

I have created a categorized membership listing for our local Chamber of Commerce, using CMS Builder.

I have a simple search form located at http://www.bainbridgegachamber.com/membershipListingsNEW.php that is set to search one field. I would like it to search 2 different fields at once (a field named "name" and one named "notes") for the search term entered by the viewer.

Is it possible to do this? If so, how?

Personnel records by CMS

Tue, 26 Aug 2008 09:07:48 -0700

I have a client that needs me to set up CMS that, in addition to doing the standard page editing, also needs to have the ability to create a set of records that will function as a membership directory, complete with names, addresses, phone numbers, and photos. The membership directory will need to be searchable (by name at least, if not other fields as well) if possible.

Also, the client will need me to create a "newsletter" type of feature. Is it possible for us to create a function that would always display the most current "newsletter", but would create links to previous versions as well? (basically creating a new record each time they want to publish a new newsletter and archiving the old ones).

I'm pretty sure that CMS will do all of this, but this will be the first time that I've used these features if I land the client, and I want to make sure that either I am able to tackle it or that I have help at hand if needed, free or paid. I know php fairly well, but am not extremely familiar with this CMS program yet, although it's pretty powerful from what I've seen thus far.

Re: [Dave] Creating/Displaying uploads

Fri, 04 Apr 2008 11:32:11 -0700

Thanks Dave. I appreciate your quick response and resolution to my question. Turns out that I had apparently created the section correctly, but maybe not actually "saved" it. (something weird like that). Also, the code that I was using wasn't exactly correct. I'm posting what I wound up using below so that others can see how to display the contents of an upload.

If you want to see the page in action, visit http://www.decaturcountyga.org/Human_Resources.php and scroll down to the "Documents" section in the left-hand navigation. I've changed the code below slightly to make the foreach loop create a complete table row for each uploaded file that exists.

I am very impressed with this software. Dave, Donna, Luke, and the others are SUPER! One of the best support teams that I've ever run across. This is the same level of service that my company, WebGraffix Media Solutions, offers. Keep it up guys!

Here's the simple version of the code that Dave sent to me. I've changed the table name and the "require_once" value for the sake of security. I also am using the first info field (info1) as the name of the file to display rather than the actual uploaded name of the file.

 [font "Arial"] 
 
 
          require_once "/usr/public/serverpath/admin/cms/lib/viewer_functions.php"; 
      $options = array();                // NOTE: see online documentation for more details on these options 
      $options['tableName'] = 'documents'; // (REQUIRED) MySQL tablename to list record from. Example: "article"; 
      $options['recordNum'] = '';        // (optional) Record number to display.  Example: "1"; Defaults to number on end of 
                                                      // url, then 1 
      $options['where']     = '';           // (ADVANCED) MySQL WHERE conditions to use INSTEAD of recordNum to look up 
                                                     // record. Example: "fieldname = 'value'" 
      $record = getRecord($options); 
    ?> 
    
 
 
 
  
  HR Documents Page Viewer
 
     
      Record Number: 
 
     
 
     
      No record found!

 
     
   
 
 
 
 
   
     
     
     
     
  
       
        " width="" 
        height="" alt="" />
 
 
       
        " width="" height="" 
        alt="" />
 
 
       
        Download

Again, thanks Dave!!

User account email?

Fri, 04 Apr 2008 11:18:19 -0700

What is the user's account email for? I haven't been able to find anywhere that makes use of this field. I thought that maybe there would be a "forgot password" feature, but there's not one.

The field is required though and also prevents duplicates from being added. Is there anywhere that this field is used?