Dynamic list

[Segi]

I have 2 dynamic lists tied to a dropdown:

Permission Sections and Permissions. Both fields have "When list is built" to "Each display"

When you select a permission section, the permission dropdown list is built using fields.ASSIGNMENTS_PERMISSION.list.buildList();

I'm having an issue where if you select "Please select" from the Permissions dropdown, Ebase crashes with the error "Unable to build dynamic list Permissions for field ASSIGNMENTS_PERMISSION : a list field with the Dynamic Sql option has no value" Is there a way to have it not attempt to built the list if "Please select" is selected.

[Jon]

If you click the required checkbox, the system will not attempt to build the list when the required where clause field has no value (Please Select). So you shouldn't see this message.

Do you actually need the Dynamic Sql option ? If you are just supplying a value for a where clause parameter you can just click the required checkbox. Dynamic Sql gives you protection against SQL injection, but if the user can't enter the value in question, it isn't needed.

[Segi]

Jon,

The DL is defined as:

Code: Select all

SELECT * FROM Permissions Where PermissionSectionID=&&WHERECLAUSE ORDER BY PermissionName

I selected Required for the WHERECLAUSE list field and unchecked dynamic SQL but I still have the same crash when selecting Please select for the dropdown that this DL is tied to

Update: Sorry I don't know why this double posted. I changed "When list is built" from Each display to First display and now it works as expected

[Segi]

Jon,

The DL is defined as:

Code: Select all

SELECT * FROM Permissions Where PermissionSectionID=&&WHERECLAUSE ORDER BY PermissionName

I selected Required for the WHERECLAUSE list field and unchecked dynamic SQL but I still have the same crash when selecting Please select for the dropdown that this DL is tied to