Re: Dynamic Custom Fields - Jorge Arturo Tijerina García - com.mysql.lists.eventum-users

7 messages in com.mysql.lists.eventum-usersRe: Dynamic Custom Fields

From	Sent On	Attachments
Jorge Arturo Tijerina García	02 May 2008 13:03
Jorge Arturo Tijerina García	06 May 2008 10:44
John Schubert	06 May 2008 13:15
Jorge Arturo Tijerina García	06 May 2008 16:29
Bryan Alsdorf	06 May 2008 23:35
Jorge Arturo Tijerina García	05 Jun 2008 07:14
Chris Davis	05 Jun 2008 11:17

Subject:	Re: Dynamic Custom Fields
From:	Jorge Arturo Tijerina García (jorg...@gmail.com)
Date:	06/05/2008 07:14:22 AM
List:	com.mysql.lists.eventum-users

Hello..!! Great example..!! It works ..!! Even it is hardcoded (the values to display) it works. Now, is there a posibility to get a dynamic list of values, let's say ... from a database? How can I match the selected value from the combo to a value stored in the DB, and then display these values in a dependable combo...?

Any suggestions wil help... regrads!

On Wed, May 7, 2008 at 1:35 AM, Bryan Alsdorf <bry...@mysql.com> wrote:

I added an example and directions to the wiki, please take a look and see if it helps.

http://eventum.mysql.org/wiki/index.php/DynamicCustomFieldExample

Best Regards, /bryan

Jorge Arturo Tijerina García wrote:

While digging into the file detail, I realize that the blank page appear only when I "extend" the Dynamic_Custom_Field_Backend class from my customized class file. If I do not extend the class, the only thing I get is de list of options I delcared in the array inside of the getStructuredData() function:

function getStructuredData() { return array( array( "keys" => array("Procesos"), "options" => array( "auditoria" => "Auditoria", "modelado" => "Modelado", "calidad" => "Calidad" ) ), array( "keys" => array("Arquitectura"), "options" => array( "framework" => "Framework", "ealib" => "EALib" ) ) ); } based on the file documentation, "keys" elements must match the "controlling" field (master combo) and the "options" elements are displayed in the "child" combo that depends on the master selection, but.. my question is, where did I define the change event of the master combo?, How do I relate the master combo with the child combo (subordinate)?. I set up only one class file with these options but it seems doing nothing at all ...

Please advise.

PS. No error log is generated...

On Tue, May 6, 2008 at 3:15 PM, John Schubert <jos...@psu.edu> wrote:

Blank pages usually means a php error, have you checked your error logs or

enabled the display of php errors to see if that helps?

-John

Jorge Arturo Tijerina García wrote:

Hi everybody.

Any luck with this?... has anyone got this working? Please advise...!! Help needed ASAP for this issue.....

_____________________________________________________________________________ I would actually be interested in seeing a working demonstration of dynamic custom fields as well, if one is available anywhere. Other than a brief mention in the list archive from a few years ago (link below), I can't find any documentation of how this is supposed to work, and my results vary between a blank screen and a select list with all options.

http://lists.mysql.com/eventum-users/2789

I'm unclear on the what the documentation in class.dynamic.php refers to as the "controlling" field. Supposing I want two fields, the first containing options A and B, and the second displaying either 1, 2, 3 or X, Y, Z depending on the selection made in the first field. I assumed that the "controlling field" setting for the second field would be the id and name of the first field, but does the first field need to be configured as a dynamic field also? If so, what is its controlling field?

Based on the information in the 1/23/06 post, I created two copies of the original class.dynamic.php script (class.field1.php, class.field2.php), each extending Dynamic_Custom_Field_Backend. Setting the first custom field to use class.field1.php in the admin panel results in a blank screen on the anonymous form as well as on the custom field config screen. I had to edit the database manually to remove the reference. Configuring class.field1.php to be a standalone (i.e., not extending class.dynamic.php) results in a select list on the anon form that displays the full contents of the array.

Perplexed,

__________________________________________________________________________________________

Manager of Network and Information Systems http://www.vmhost.psu.edu 814-863-8334

Discover new MySQL Monitoring & Advisory features at: http://www.mysql.com/products/enterprise/whats_new.html