Re: [cmscott] Question about Filename field translation

Fri, 14 Sep 2012 19:00:01 -0700

Hi Dave,

Works like a charm! Thank you sir.

Cheers
[:)]

Re: [Dave] Question about Filename field translation

Fri, 14 Sep 2012 13:30:58 -0700

Hi Dave,

Looks like that could work, I'll test it out later today and let you know how I make out.

Very helpful :)

Thanks!

Re: [Dave] Question about Filename field translation

Thu, 13 Sep 2012 19:00:43 -0700

Hi Dave,

I'm looking up the record with both the num and title (trying to at least) fields. So there can still be duplicate titles in the table. I should have mentioned that.

Looking up both fields prevents duplicate pages, otherwise you can write anything between the ? and the num and the page resolves to the same content based on the num. I'm also enforcing lowercase. Throwing a 404 error page if the record isn't found.

Hello-World-1 (200)
Goodbye-World-1 (200)
heLlo-wOrlD-1 (200)

Should be:

Hello-World-1 (200)
Goodbye-World-1 (404)
heLlo-wOrlD-1 (404)

IDEALLY, I'd like to add another field to the table that gets auto-populated with the slug - where in my case the slug is the Filename field + num. I'm not too concerned with being able to edit the slug, although that would be nice - kind of like what Wordpress does with their titles.

That way I can easily lookup just the 'slug' field instead of both the 'title' and 'num' fields with no need to worry about de-normalizing the 'title' field for special characters.

Let's say 'title' is my Filename field...

num: 100
title: Get 20% Off Product ABC
slug: get-20-off-product-abc-100

Request comes in, query the db using the slug and return the content or throw a 404 if record isn't found.

Basically, instead of a _link field, I want a _slug field as I described.

I'm also using mod_rewrite to rewrite the viewer urls, but that doesn't impact anything here. Also note I already made slight adjustments to the _link in viewer_functions.php such as strtolower().

/products/product.php?the-slug gets rewritten to /products/the-slug

OTHERWISE, I need a way to de-normalize the 'title' field based on the Filename field.

Hope that makes sense, took a while to write it.

Thanks!

Re: [Jason] Question about Filename field translation

Thu, 13 Sep 2012 14:41:39 -0700

Hi Jason,

The problem I'm running into is that some of my Title field values contain special characters like the % character. These characters get stripped to build the URL slug.

So when I try to do what you suggest, it can't find the record.

Example:

TITLE: 10% off Product A
URL: 10-off-product-a

If I replace the hyphens with blank spaces, then lookup the title, can't find the record because of the % character.

Any ideas?

Thanks!

Question about Filename field translation

Wed, 12 Sep 2012 20:36:53 -0700

Hello,

When CMSB transforms the Filename field to the URL slug, does it get saved to the database somewhere so that I could query for the string?

If not, is there a way to build/decrypt the Filename-translation so that I could lookup a record based off the "Title" field for example?

In addition to the ability to lookup by the 'num' at the end of the URL, I'd like to be able to lookup records based on the URL value that CMSB generates from the Filename field.

Thanks!

Re: [chris] where upload field IS NOT NULL

Fri, 20 Nov 2009 20:05:03 -0800

Hi Chris,

There is definitely an upload field named "logo" in my organization table. I uploaded a screenshot.

Also, the standard cms_ prefix is in the Database Settings.

Thanks

Re: [chris] publicly populate a list field

Fri, 20 Nov 2009 19:33:56 -0800

Hi Chris,

Attached is my php.

In CMS Builder, organization.activity is a list field that pulls it's values from another table called activities using num as the value and title as the label.

Between lines 273-275

I'm attempting to post it's array value and insert it into the organization.activity list field.

Appreciate any help. Let me know if you have any questions.

Thanks

where upload field IS NOT NULL

Fri, 20 Nov 2009 02:15:28 -0800

Hello,

I'm trying to generate a list limited to 3 random records where the logo upload field is not empty.

----------------------------

list($organizationRecords, $organizationMetaData) = getRecords(array(
'tableName' => 'organization',
'limit' => '3',
'where' => 'logo IS NOT NULL',
'orderBy' => 'RAND()',
));

----------------------------

However, I'm getting this error:

MySQL Error: Unknown column 'logo' in 'where clause'

Any help would be appreciated.

Thanks

publicly populate a list field

Fri, 20 Nov 2009 01:17:03 -0800

Hello,

How can I publicly populate a cms builder multiple-select list field?

I have a list field called 'activity' that is grabbing it's values from another table 'activities' where $num is the value and $title is the label.

At the top of my page that has the html form, the mysql UPDATE statement for the activity field is as follows:

-----------------------

activity = '".mysql_real_escape_string( $_REQUEST['activity'] )."',

-----------------------

then in my html form

-------------------------

-------------------------

On the html form, a user can select multiple activities, but when the record is added to cms builder only the last selected activity becomes checked in the cms builder record.

Any ideas?

Thanks

Re: [Luke] run php script on record update

Wed, 04 Nov 2009 16:47:15 -0800

Hi Luke,

I have the basic structure of the script, it's not complete yet.

There may be some other features like this I need, so before I send an email I'll need to figure that all out, perhaps you will be able to kill 2 birds with 1 stone.

I thought there may be a simple way to do this.

Thanks

run php script on record update

Wed, 04 Nov 2009 15:38:48 -0800

Hello,

I'm setting up a mechanism for site visitors to submit event info for approval. Upon approval, I want to run a script to create an event on our Google Calendar.

I created an Events editor, that includes a checkbox field for "Approved"

I have a form that allows visitors to add a new event record. The form script will also send an email to the admin to review the event. If approved, they then go into CMS builder review/edit info and check the Approved checkbox.

Once the admin checks the Approved box and saves record, I want my google-calendar script to run which will create the event.

Is this possible?

Thanks

Re: [Shore] Where clause on a joined field?

Mon, 26 Oct 2009 20:11:31 -0700

After digging through the forum, I figured out why I couldn't do a simple...

'where' => 'category = "category name"'

because for my list field in the video table, I should be using the 'num' field as the option value from the categories table, instead of the title field (which should just be used as the label).

so after I fixed the list field, I'm able to do this...

'where' => 'category = 2',

sorry about that!

Where clause on a joined field?

Mon, 26 Oct 2009 17:39:56 -0700

Hello,

I have a video gallery, and each video has a category field. The categories are stored in a separate table called "categories" so I am able to add more categories down the road.

I'm trying to do this:

require_once "/home/test/public_html/cmsAdmin/lib/viewer_functions.php";

list($videoRecords, $videoMetaData) = getRecords(array(
'tableName' => 'video',
'where' => 'category = "A category"',
));

?>

but it's not understanding my Where clause.

I noticed in CMSB's generated viewer foreach code that the category field was being joined, as below:

How do I modify the Where clause from above so that I can create a list of videos from a specific category?

And can I create additional $videoRecords lists for each other category, that way I can arrange each list on the page where I want it.

Thanks

Re: [ShoreWebmaster] MySQL Error

Fri, 16 Oct 2009 16:43:15 -0700

as an aside...if you made that a required selection during the "list" field adding process, I wouldn't have created this post at all....just a thought....

works like a charm now though!

Re: [ShoreWebmaster] MySQL Error

Fri, 16 Oct 2009 16:33:45 -0700

I figured it out, for some reason I didn't select a field for option values.

MySQL Error

Thu, 15 Oct 2009 15:44:50 -0700

Hello,

I'm getting the following error when trying to add a new record. It's being caused by one of the fields which is a "list" field that is pulling it's values from another database table field.

Warning: Cannot modify header information - headers already sent by (output started at /home/test/public_html/cmsAdmin/lib/menus/header.php:15) in /home/test/public_html/cmsAdmin/lib/database_functions.php on line 557 There was an error creating the list field. MySQL Error: Unknown column '' in 'field list'

Any ideas?

Thanks!

Re: [Dave] modify createdDate

Wed, 18 Mar 2009 14:29:19 -0700

Hi Dave,

Thanks for getting back.

For some reason, it kind of works now, not sure what happened.

Last night, when I was adding new Testimonials, when I hit Save it would push it down to the bottom of the list, whereas I wanted it at top of list. And, they were all in order of createdDate. So I thought I had to either delete them all and start from the oldest testimonial first, or go into the mysql and reverse the createdDate fields so that they would be in proper chronological order.

Anyhow, it seems to be working now. Maybe it was just too late to get it to work right!

Thanks again, will let you know if something goes wrong.

modify createdDate

Tue, 17 Mar 2009 23:36:16 -0700

Hello,

I created a section editor for customer testimonials, but i added the records in reverse order.

I entered them going down the existing webpage list, whereas I should have entered them from the bottom of the webpage up.

In other words, I entered the most recent testimonial as the first record in cms builder.

So, now when I add a new testimonial, I have to drag it to the bottom of the record list each time I save it.

Is there a way to reverse the "createdDate" system field data across all records so that a new testimonial createdDate will allow for proper sorting when createdDate is used as a ListPage Field, without doing the dragsort each time?

Thanks