# Integer custom properties format change btw 7.5 and 7.6 **URL:** \ **Category:** Ignition\ **Created:** [September 28, 2013, 2:24pm UTC](https://forum.inductiveautomation.com/t/integer-custom-properties-format-change-btw-7-5-and-7-6/7343 "2013-09-28T14:24:32Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Post date:** [September 28, 2013, 2:24pm UTC](https://forum.inductiveautomation.com/t/integer-custom-properties-format-change-btw-7-5-and-7-6/7343/1 "2013-09-28T14:24:32Z")
I use integer custom properties “Id\_select” to store id for a parametrized SQL query. In 7.5.5 version all is fine. For example the value is 2551065. (this value of this custom properties is binded to the selected value of a dropdown component) I upgrade to 7.6.3. In 7.6.3 the value become : 2 551 065 ie with space every 3 digits. and now my database SQL Query : …WHERE id\_itineraire IN({Root Container.Id\_select}) for a table component give me an sql error because of space into the value. Is there a way the avoid this integer value formating ??? (on custom properties or on component integer properties) ---
**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Post date:** [October 3, 2013, 6:50pm UTC](https://forum.inductiveautomation.com/t/integer-custom-properties-format-change-btw-7-5-and-7-6/7343/2 "2013-10-03T18:50:14Z")
Will be corrected for next release ? ![:scratch:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/76d1620bec252bfac07050c889ff5a91dc8a9c25.gif ":scratch:") ---
**Author:** ![adamaustin](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@adamaustin](https://forum.inductiveautomation.com/u/adamaustin)\ **Post date:** [October 3, 2013, 7:07pm UTC](https://forum.inductiveautomation.com/t/integer-custom-properties-format-change-btw-7-5-and-7-6/7343/3 "2013-10-03T19:07:57Z")
For now, you can use the replace expression to get rid of the spaces: ```auto WHERE id_itineraire IN(replace({Root Container.Id_select}," ", "")) ``` ---
**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Post date:** [October 4, 2013, 7:05am UTC](https://forum.inductiveautomation.com/t/integer-custom-properties-format-change-btw-7-5-and-7-6/7343/4 "2013-10-04T07:05:17Z")
Yes, thanks for the solution, but I have lots of SQL query to check. A fix in next RC will be better… ---
**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\ **Post date:** [October 7, 2013, 10:57pm UTC](https://forum.inductiveautomation.com/t/integer-custom-properties-format-change-btw-7-5-and-7-6/7343/5 "2013-10-07T22:57:10Z")
This works for me in 7.6.3. Are you using a different locale? Using a 9 digit number in the where clause from a dropdown selectedValue property works fine. How does your Id\_select integer get its value? ---
**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Post date:** [October 8, 2013, 4:04pm UTC](https://forum.inductiveautomation.com/t/integer-custom-properties-format-change-btw-7-5-and-7-6/7343/6 "2013-10-08T16:04:56Z")
The locale is fr for 7.5.5 abd 7.6.4rc1 Java Version Oracle Corporation 1.7.0\_09 on both Root Container.Id\_select is calculated by an expression : if({Root Container.ContainerMessageHoraire.CheckBoxToutesLignes.selected},{Root Container.ContainerMessageHoraire.DropdownLigneTc.IdsItineraire}, {Root Container.ContainerMessageHoraire.DropdownLigneTc.selectedValue}) IdsItineraire is a String custom property. This property is calculated by an SQL expression : select GROUP\_CONCAT(distinct id\_itineraire SEPARATOR ‘,’) as ITINERAIRE from VUE\_CMD\_HORAIRE\_IHM where id\_pae={Root Container.id\_pae} Root Container.ContainerMessageHoraireDropdownLigneTc.selectedValue = 2 551 066 (with spaces) in 7.6.4rc1 instead of 2551066 in 7.5.5 The problem occur when Root Container.ContainerMessageHoraire.CheckBoxToutesLignes.selected is FALSE ---
**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\ **Post date:** [October 8, 2013, 5:42pm UTC](https://forum.inductiveautomation.com/t/integer-custom-properties-format-change-btw-7-5-and-7-6/7343/7 "2013-10-08T17:42:06Z")
The trueReturn and falseReturn values must be the same type so I think your Id\_select must be getting converted to a string with spaces because of your IdsItineraire. If it’s fueled by an expression, then you can try forcing it to be an integer then convert it back to a string. Try this expression instead:`if({Root Container.ContainerMessageHoraire.CheckBoxToutesLignes.selected}, {Root Container.ContainerMessageHoraire.DropdownLigneTc.IdsItineraire}, toString(toInt({Root Container.ContainerMessageHoraire.DropdownLigneTc.selectedValue})))` ---
**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Post date:** [October 9, 2013, 1:19pm UTC](https://forum.inductiveautomation.com/t/integer-custom-properties-format-change-btw-7-5-and-7-6/7343/8 "2013-10-09T13:19:55Z")
thanks robert. It solve my problem for 7.6.4