# Dropdown displaying data outside of dataset **URL:** \ **Category:** Ignition\ **Created:** [November 17, 2011, 5:53pm UTC](https://forum.inductiveautomation.com/t/dropdown-displaying-data-outside-of-dataset/3619 "2011-11-17T17:53:20Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Post date:** [November 17, 2011, 5:53pm UTC](https://forum.inductiveautomation.com/t/dropdown-displaying-data-outside-of-dataset/3619/1 "2011-11-17T17:53:20Z")
One of my screens lets the operaters set recipe parameters using a dropdown. The dataset on the combo box itself is bound to a SQL database. I’m receiving reports that occasionally the text in the dropdown is displaying a raw number (which seems to be the ingredient index in the PLC) rather than the description from the database. Possibly related, the dropdown text will also bet set to an empty string occasionally. Any ideas? ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [November 17, 2011, 6:58pm UTC](https://forum.inductiveautomation.com/t/dropdown-displaying-data-outside-of-dataset/3619/2 "2011-11-17T18:58:37Z")
Make sure the dropdown list component is in strict mode. That way the selectedValue can only be a value within the dataset. ---
**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Post date:** [November 17, 2011, 10:40pm UTC](https://forum.inductiveautomation.com/t/dropdown-displaying-data-outside-of-dataset/3619/3 "2011-11-17T22:40:49Z")
The dropdowns are already set to strict. Any other suggestions? ![:scratch:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/76d1620bec252bfac07050c889ff5a91dc8a9c25.gif ":scratch:") ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [November 21, 2011, 7:25pm UTC](https://forum.inductiveautomation.com/t/dropdown-displaying-data-outside-of-dataset/3619/4 "2011-11-21T19:25:21Z")
What is the dropdown’s “No Selection Label” set to? If it’s blank, that might explain when the combo box goes blank. (no selection, or selected value doesn’t exist in the table) I can’t think of why the display would display the number. Can you reproduce this by any chance? ---
**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Post date:** [November 21, 2011, 10:28pm UTC](https://forum.inductiveautomation.com/t/dropdown-displaying-data-outside-of-dataset/3619/5 "2011-11-21T22:28:03Z")
The ‘No Selection Label’ is set to “”. I haven’t been able to reproduce the problem in a lab setting, but the customer says they experience this issue once to twice a day. Data is bound to a client tag dataset that executes a stored procedure, and selected value is bound to a SQLTag referencing the PLC. The customer’s gateway is still running 7.2.6 if it helps. ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [December 9, 2011, 5:40pm UTC](https://forum.inductiveautomation.com/t/dropdown-displaying-data-outside-of-dataset/3619/6 "2011-12-09T17:40:29Z")
Can you show me the details of all three bindings as well?