# Sqlite select query not returning data

**URL:** <https://discourse.nodered.org/t/sqlite-select-query-not-returning-data/16742>\
**Category:** General\
**Created:** [15 October 2019 18:44 UTC](https://discourse.nodered.org/t/sqlite-select-query-not-returning-data/16742 "2019-10-15T18:44:22Z")\
**Posts on this page:** 1\
**Showing post:** 12

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [19 October 2019 22:43 UTC](https://discourse.nodered.org/t/sqlite-select-query-not-returning-data/16742/12 "2019-10-19T22:43:49Z")

</div>

I think that since you are sending the sql via the msg.topic, it ends processing at the `;` at the end of the `create index` statement. So you can only send in one statenment at a time.

If you use the batch option, No result rows are returned.

---

_[View the full topic](https://discourse.nodered.org/t/sqlite-select-query-not-returning-data/16742)._