Announcement

**ajmarrer** · 20 Feb 2012, 19:23

Just wanted to follow up and see if anyone has any advice on the problem that I am experiencing. Any help would be appreciated. Thanks in advance!

**RAS** · 21 Feb 2012, 02:59

Can you show me the code in which you're passing values in SelectItem or to DataSource?

**ajmarrer** · 21 Feb 2012, 17:20

The code that I am using is shown in my initial post. As for the values that are populating the SelectItem is handled directly by DataBinding in the background. Its simply the data that is part of the table from my SQL source.

This seems like something trivial that should work for me unless I am doing something incorrectly.

If you feel any other information would be helpful please just ask.
Thanks again.

**joe.parks@hyperproductive.com** · 21 Feb 2012, 18:40

Of what type is the "EmployeeId" property?

**ajmarrer** · 22 Feb 2012, 05:44

The EmployeeId field of the Employee Datasource is of type "sequence" in my Employees.ds.xml file.

In the actual SQL Employee table, its an auto-incremented field.

**ajmarrer** · 23 Feb 2012, 08:42

Isomorphic, any input on this? Have you found this to be working on your end and its simply that I am doing something incorrectly?

**Isomorphic** · 23 Feb 2012, 11:31

See the FAQ - we can't run your code, and as far as speculating with you, you're reporting a JavaScript error with no stack trace, so there's little we can do.

**joe.parks@hyperproductive.com** · 23 Feb 2012, 15:02

It looks like it's bringing back an array of int primitives rather than Strings. Does it work if you use a different property as the valueField? That is, can you try setting "FirstName" as both the displayField and the valueField?

**ajmarrer** · 24 Feb 2012, 06:49

Thanks for the suggestion! That actually began to work.

Given this scenario, it definitely seems like a bug.

If I have the following code....

Code:

               final SelectItem employeeName = new SelectItem("EmployeeId");
		employeeName.setTitle("Choose Employee");
		employeeName.setMultiple(true);
		employeeName.setOptionDataSource(employeesDS);
		employeeName.setValueField("EmployeeId");
		employeeName.setDisplayField("FirstName");
		employeeName.setRequired(true);
		employeeName.setPickListWidth(450);
		employeeName.setPickListProperties(pickListProperties);
		employeeName.setPickListFields(fName, lName, pos, dob, passportExp);

and performing employeeName.getValues() throws an error.
And if I change the "ValueField" as follows...

Code:

                final SelectItem employeeName = new SelectItem("EmployeeId");
		employeeName.setTitle("Choose Employee");
		employeeName.setMultiple(true);
		employeeName.setOptionDataSource(employeesDS);
		employeeName.setValueField("FirstName");
		employeeName.setDisplayField("FirstName");
		employeeName.setRequired(true);
		employeeName.setPickListWidth(450);
		employeeName.setPickListProperties(pickListProperties);
		employeeName.setPickListFields(fName, lName, pos, dob, passportExp);

and the error goes away. It seems to me like to SelectItem object is not taking the toString() value of the integer value that is being passed in from the "EmployeeId".

Below is my Employees.ds.xml file...

Code:

<DataSource ID="Employees" dbName="manifest"
	serverType="sql" tableName="employees">
	<fields>
		<field name="EmployeeId" type="sequence" primaryKey="true" hidden="true" />
		<field name="FirstName" title="First Name" type="text" length="64" required="true" />
	</fields>
</DataSource>

Ideally I would like to be able to maintain the "employeeId" as the "ValueField" because I am using this to "INSERT INTO" my sql table.
Any advice or workaround is welcome. Thanks again for all the support!

**elvisv** · 24 Feb 2012, 07:50

I'm having the same exact issue. Any suggestions? solutions?

**joe.parks@hyperproductive.com** · 24 Feb 2012, 07:56

What is the definition for "manifestDS"?

**ajmarrer** · 24 Feb 2012, 07:58

manifest.ds.xml file is shown below...

Code:

<DataSource ID="Manifest" dbName="manifest"	
serverType="sql" tableName="manifest">
	<fields>
		<field name="ManifestId" type="sequence" primaryKey="true" hidden="true" />
		<field name="EmployeeId" type="integer" hidden="true" foreignKey="employees.EmployeeId" />
		<field name="ProjectId" type="integer" hidden="true" foreignKey="projects.ProjectId" />
		<field name="CompanyId" title="Company Id" type="sequence" foeignKey="companies.CompanyId" />
	</fields>

**joe.parks@hyperproductive.com** · 24 Feb 2012, 09:09

Does the "getSelectedRecords()" method work for your requirements?

Code:

            public void onClick(com.smartgwt.client.widgets.form.fields.events.ClickEvent event) {
                final ListGridRecord[] selectedRecords = item.getSelectedRecords();
                for (ListGridRecord selectedRecord : selectedRecords) {
                    final String selectedItemId = selectedRecord.getAttribute("EmployeeId");
                    SC.say("Employee ID: " + selectedItemId);
                }
            }

**ajmarrer** · 27 Feb 2012, 08:39

That workaround worked Joe!

Thanks for the help.

However I still believe the SelectItem object should take the toString() values of integers when doing SelectItem.getValues();

Either way thanks again!

Announcement

SelectItem getValues() problem

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment