Notice: CMSB v2.01 Beta 2: Signup & Feedback thread

Thanks, that's a bug. Let me know if you need a code fix right away, otherwise it's fixed for the next beta.

Thanks!

I can await the following version. I only test.

Thanks !

Dave, I'm happy to see the new default date field values feature, which works well for me in my beta testing.

Can you provide an example of when/how this new feature would be used?
"- Viewer Functions: Added advanced option 'addSelectExpr' for generating pseudo-fields or calculated values "
I'm not as advanced in PHP/MySQL as many others who visit this forum, but am continually learning and would like to understand the possiblities this feature provides.

Thanks.
Deborah

Hi Dave,

So far, when creating or modifying a User Account I get this error:

Notice: Undefined index: type in /path_to_my_server/cmsAdmin/lib/menus/default/save.php on line 107

An existing user Account record can be modified but a new User Account record can't be creates.

Best,

Jerry

Hi Dave, i was wondering if you were planning on implementing a jQuery plugin for the upload field.

A plugin such as uploadify (Link: http://www.uploadify.com/) or something similar would really great?

Cheers.

Hi LeQueb,

Yes we are actually working on something for that right now and it may be the focus of our 2.02 beta.

We were working with http://swfupload.org/ but I'll check out uploadify.com as well as it looks interesting.

Thanks for the suggestion and link! :)

Hi Deborah,

>an you provide an example of when/how this new feature (addSelectExpr) would be used?
It's for pretty advanced MySQL. So likely it would be used by us or when we post a snippet to help someone in the forum.

What it does is insert the addSelectExpr value into a SELECT query here:
SELECT *, addSelectExpr FROM tablename

So if you had:
'addSelectExpr' => ' NOW() as _currentDate ',

It would add a field _currentDate to your $records like $records['_currentDate']. That's because NOW() is a mysql function: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_now

Usually you'd use that when you had lots and lots of records and you wanted to sort them on a calculated value. Some examples of this that I'm working on now are a custom search engine that returns records based on a "match score" from 0-100 that is calculated, and a distance search that returns results based on distance from the searching users location and displayed that distance as well.

Some of the MySQL for this can be very complicated (see: http://www.zcentric.com/blog/2007/03/calculate_distance_in_mysql_wi.html ) but as we do it more and more ourselves we'll work on ways to make it simpler and build it into the software or plugins.

If you have say 10,000 or more records you need to do these calculations and the sorting in the database because it's not possible to do it in the application without loading all the records and that takes too much memory.

The main reason I added it was because I needed it for a custom project I was working on myself.

Hope that helps! Let me know if you want any more details. :)

Hi Jerry,

>So far, when creating or modifying a User Account I get this error:

Thanks for the report! I've fixed that for the next beta.