Invalid Data on form for data type "Select"

Scriptcase 9
#1

I have a field that as data type=select
everything is OK until I will select one string “5x114.3/5x127”. Even I do not send that string to the database just only ID of this string.
Rest of strings, such a “5x139.7/5x150” or “6x135/6139.7” works fine.

#2

Wich is the value for your invalid string?

#3

the value is “5x114.3/5x127”

#4

Wich is your sql statement for your field select?
can you show some result for your Query?

#5

This is result of my query
5x114.3
5x114.3/5x127
5x127
5x127/5x139.7
5x139.7
5x139.7/5x150
6x135/6x139.7
6x139.7

#6

Query
select distinct s.ID, s.bolt from p_bolt s join v_wheelID w on w.BoltID=s.ID
where w.StyleID =’{Style}’ and w.SizeID = ‘{size}’
order by Bolt

This is results of my query
5x114.3
5x114.3/5x127
5x127
5x127/5x139.7
5x139.7
5x139.7/5x150
6x135/6x139.7
6x139.7

#7

Your query must show 2 values for fields s.ID, s.bolt, el field d.ID is stored in DB, so you must verify your DATA TYPE for your field select of form and the value for the field s.bolt. maybe be NULL.

#8

Thank you, @alvagar
I change the “idea” and instead of a form I created a grid.