How to setup dependent list

Wed, 01 Jul 2015 10:23:54 -0700

Hi Dave,

Thanks for the response. I'm not worried about the front end, I can code that. Custom mysql is no problem. I guess what I need to know is how I access the trigger select value to pass to the custom mysql.

Example; if I had a states drop down and want the selected state to drive the options for the cities select.

Jim

How to setup dependent list

Tue, 30 Jun 2015 13:58:29 -0700

I'm looking at cmsb for a new project and have a specific need for dependent lists. Each product will be assigned to a category from the categories table. Depending on the category assigned to a product I need the options for colors, size etc. to be pulled from the respective tables; color, sizes where I have defined values for color and sizes and assigned them values for each category. So what I need to understand is how to trigger a refresh of the color options when the user selects the category they are assigning the product too. Can't seem to understand from the docs how this should be setup.

Sharing wysiwyg image between records in section

Wed, 20 Jun 2012 20:34:04 -0700

I have a section called pages with a field called content that is type wysiwyg. If I upload an image in the wysiwyg editor I'd like to be able to use it again on another page but when on another page in the section it does not know that the image has been uploaded. Is there any way to see all images uploaded in a wysiwyg field on other records in that section?

Re: [Dave] paging problem

Fri, 16 Jan 2009 08:41:25 -0800

Hi Dave,

I have created a second function in my own lib file as you suggested and it works fine.

Thanks,
Jim

Re: [Dave] paging problem

Wed, 14 Jan 2009 20:09:16 -0800

In getNumberFromEndOfUrl() function I added these two lines right before the if (preg_match...) statement:

$url = explode('=&',$urlData);
$urlData = $url[0];

It makes $urlData always contain just the url we want to strip the num off of.

Jim

Re: [Dave] paging problem

Wed, 14 Jan 2009 13:11:19 -0800

Code is only running on my dev server so I can't show you a link. However, your suggestion points out the problem which is related to how the getNumberFromEndOfUrl() function works. It does exactly what it says, gets the number from the end of the url which as you suggested is the value after page=3. The solution to the problem was a simple change to the getNumberFromEndOfUrl() so that it first removes any data from the url after the =& that appears on a link. After making that change it works just fine and as expected. If doing this won't cause any problems then maybe the function could be modified for future versions?

paging problem

Tue, 13 Jan 2009 12:24:18 -0800

I have a strange paging problem. I have a viewer on a newsDetail page that displays the news item then the comments that are linked to news items by the num field of the news table. There are actually four viewers on this page (the other two are not important).

The problem I am having is with paging of the comments.

Example: if I page to the second comments page the page displays the news item and page 2 of the comments just fine. However, if I page to page 3 or back to page 1, even though the url is correct the wrong news item page displays?

I am using the getNumberFromEndOfUrl() function to grab the num value from the news item and then using it in the where clause of the comments viewer. The strange part of this is that the url on the paging link and in the address bar are correct but it goes to the wrong news item.

Any ideas as to why this happens?

User Accounts and Category Menu

Mon, 15 Dec 2008 17:45:03 -0800

I am building a cms where I want to maintain admin control but give a Manager ability to edit the different content sections. I just discovered that I can not give a user Section Access to sections that are type Category Menu. It appears that it is automatically forcing this type to admin only access! How can I override this. I need to be able to allow my Manager type user to edit these Category Menus. I use one as the dynamic menu structure for content pages and one to categorize members on the site. If I have to give the user access as admin then they can get at other things that I don't want them to see or touch.

Advanced Search and other questions

Fri, 12 Dec 2008 10:51:53 -0800

I purchased CMS Builder about 3 weeks ago and must say I am impressed with the power of the product for building and managing backends. I've been using PHPMaker for the last year or so to build backends for custom cms solutions and though you can do quite a bit with it, since its a code generator, there is more work in making design updates (though it does have the advantage of a single license fee). It is much quicker to work with CMS Builder for rapid prototyping as the immediate synchronizing of the schema to the interface really saves time. I have been able to build a frontend cms framework library of wrapper functions in a very short period of time because of the strength of the backend and viewer function. This includes; integrating a css dropdown menu, a lightbox type of photo gallery, categorized searchable events list, dhtml slideshow, menu category treeview and a flash video player.

Now a couple of questions on the current CMS Builder limitations.

#1) Is there anything coming for CMS Builder to provide advanced search abilities? I have sections with dropdowns to categorize content; for example - news items or a photo gallery. To make life easier for the person editing content it would make sense to give them the search ability to have a dropdown list of the categories so they could select a category to filter the rows on. Same thing holds for dates. We need to be able to search for a range of dates.

Also on the issues of dates. I much prefer the ability to use a popup calendar to enter dates then 3 dropdown lists. Would like to see this become an option for date fields.

#2) Is there any way to have additional indexes for the tables? Seems like num is the only index we can have. I like to create indexes to optimize queries where appropriate; for example - on the news category mentioned above; or dates if querying on them.

#3) One more question. Has there been any thought to a developer license? My goal is to build a framework that allows me to quickly wrap a custom design around it to provide a simple cms with standard features that I can market to clients in my area. Most of them are small businesses that have very limited budgets and my target will require a low price point.