2. PHPRunner General questions
  3. [SOLVED]  Select multiple values from checkboxes, second try
This topic is locked
[SOLVED]

 Select multiple values from checkboxes, second try

 		10/1/2015 11:39:09 AM
PHPRunner General questions
K
 kdgsv author

Hallo,
I have started a thread here in Feb. 2015 with the same problem, but as it is looked I cannot add anything.
This is the original thread:
http://www.asprunner.com/forums/topic/22985-select-multiple-values-from-checkboxes/
Finally I have found the root cause but dont have a solution so far.
After changing the field type from Int to varchar the script was working fine.
There might be a change inside PHPrunner 8.0 compared with PHPrunner 6.2 which causes the problem.
Maybe someone knows why the filed type can cause this problem.
Any idea would be appreciated.
Thank you.
Matthias
Sergey Kornilov admin 10/1/2015

You must use varchar field for this field. Since you setup this field as multiselect it is expected to be a text field so it can save comma separated values like 32,35,38.

Even if you are not saving it in the database and handle it via events field itself still need to be a varchar.
K
 		kdgsv author 10/2/2015



You must use varchar field for this field. Since you setup this field as multiselect it is expected to be a text field so it can save comma separated values like 32,35,38.

Even if you are not saving it in the database and handle it via events field itself still need to be a varchar.


Thank you Sergey,
I see what you are saying.
What I not understand so far is the following.
I used INT fields in this table together with PHPRunner 6.2 and the event code was working fine.

If I use an INT field with PHPrunner 8.0 it creates ony two new database entries, means if I select more than two items from the multiselct box it does not work.
If it needs to be a varchar, it should not work anyway with INT field?
Thank you.
Matthias