# UI Dropdown - get result from SQL
**URL:** https://discourse.nodered.org/t/ui-dropdown-get-result-from-sql/614
**Category:** Dashboard
**Created:** [5 June 2018 09:46 UTC](https://discourse.nodered.org/t/ui-dropdown-get-result-from-sql/614 "2018-06-05T09:46:40Z")
**Posts on this page:** 11
**Page:** 3
### Author:  [@knolleary](https://discourse.nodered.org/u/knolleary)
#### Post date: [27 August 2018 08:43 UTC](https://discourse.nodered.org/t/ui-dropdown-get-result-from-sql/614/41 "2018-08-27T08:43:02Z")
> [@zenofmud](#):
>
> > ER\_WRONG\_VALUE\_COUNT\_ON\_ROW
>
> Ok, I don't believe this is from an insert
Why do you think that? A Google search for that error only shows it in relation to insert statements with different numbers of columns and values. If you know of a different SQL statement that can generate the error then do let us know.
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [27 August 2018 08:50 UTC](https://discourse.nodered.org/t/ui-dropdown-get-result-from-sql/614/42 "2018-08-27T08:50:03Z")
Umm, I plead I'm up too early and not thinking 🤔
However, I think the idea of adding the debug nodes to figure this out is needed.
(Ok, going back to bed now)
---
### Author:  [@rishanaziz](https://discourse.nodered.org/u/rishanaziz)
#### Post date: [28 August 2018 03:17 UTC](https://discourse.nodered.org/t/ui-dropdown-get-result-from-sql/614/43 "2018-08-28T03:17:41Z")
This is what I got:
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [28 August 2018 06:04 UTC](https://discourse.nodered.org/t/ui-dropdown-get-result-from-sql/614/44 "2018-08-28T06:04:43Z")
Why are you looking for name='undefined' in the query? Is that what you want? If not then work out where that has come from. However I don't think that would cause that error message.
---
### Author:  [@knolleary](https://discourse.nodered.org/u/knolleary)
#### Post date: [28 August 2018 06:43 UTC](https://discourse.nodered.org/t/ui-dropdown-get-result-from-sql/614/45 "2018-08-28T06:43:57Z")
> [@knolleary](#):
>
> To be really clear: to debug this error we need to see the complete insert statement you are passing the SQL node that leads to this error.
I'm just going to repeat what I said. Until you share this, there's nothing we can do. Showing us debug output of other queries isn't helpful.
---
### Author:  [@rishanaziz](https://discourse.nodered.org/u/rishanaziz)
#### Post date: [29 August 2018 02:03 UTC](https://discourse.nodered.org/t/ui-dropdown-get-result-from-sql/614/46 "2018-08-29T02:03:43Z")
Hi Nick,
This is the debug output of the INSERT statement:
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [29 August 2018 06:11 UTC](https://discourse.nodered.org/t/ui-dropdown-get-result-from-sql/614/47 "2018-08-29T06:11:46Z")
The error says that in the command you have not got the same number of values as columns specified. How many columns have you specified and how many values have you provided?
---
### Author:  [@rishanaziz](https://discourse.nodered.org/u/rishanaziz)
#### Post date: [30 August 2018 05:43 UTC](https://discourse.nodered.org/t/ui-dropdown-get-result-from-sql/614/48 "2018-08-30T05:43:42Z")
Hi all,
I got it now. There are different number of columns and values in the statement. Some of the required columns are not specified in INSERT statement.
Thank you very much for helping.
---
### Author:  [@Soft4](https://discourse.nodered.org/u/Soft4)
#### Post date: [12 November 2018 18:58 UTC](https://discourse.nodered.org/t/ui-dropdown-get-result-from-sql/614/49 "2018-11-12T18:58:27Z")
I already try 2 evenings to fill my dropdown but do not get it done. I'm trying to execute post 2. But I only get the payloads out. When I use the change node with options, I get objects output.
---
### Author:  [@Soft4](https://discourse.nodered.org/u/Soft4)
#### Post date: [12 November 2018 19:00 UTC](https://discourse.nodered.org/t/ui-dropdown-get-result-from-sql/614/50 "2018-11-12T19:00:24Z")
---
### Author:  [@Soft4](https://discourse.nodered.org/u/Soft4)
#### Post date: [12 November 2018 20:22 UTC](https://discourse.nodered.org/t/ui-dropdown-get-result-from-sql/614/51 "2018-11-12T20:22:44Z")
Somewhere I made a mistake it turns out to work just like that. I had some old flows open and I think it went wrong. So with options variant it just worked. Sorry.
[Previous page](https://discourse.nodered.org/t/ui-dropdown-get-result-from-sql/614.md?page=2)