# Using a Store Procdure returns a count of rows rather than dataset

**URL:** <https://forum.inductiveautomation.com/t/using-a-store-procdure-returns-a-count-of-rows-rather-than-dataset/93290>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [July 16, 2024, 2:39pm UTC](https://forum.inductiveautomation.com/t/using-a-store-procdure-returns-a-count-of-rows-rather-than-dataset/93290 "2024-07-16T14:39:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ahawes](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ahawes/32/36337_2.png) [@ahawes](https://forum.inductiveautomation.com/u/ahawes)\
**Post date:** [July 16, 2024, 2:39pm UTC](https://forum.inductiveautomation.com/t/using-a-store-procdure-returns-a-count-of-rows-rather-than-dataset/93290/1 "2024-07-16T14:39:33Z")

</div>

Good morning Team,

I am using a stored procedure in MySQL to call a data set.

```python
CALL CW_OEE_Ignition( :startDate , :endDate , :scanner)

```

When I enter data into the query I get the expected results.

When I use a binding it only returns the count of rows.

Can any help me out?

Thanks!

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/1/b1fa4a68a90bae4fb4ee08219b268104e0d57318.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/9/f9ea6a9416e78cfa6a33d0b1d1c9676cd393775b.png)

---

<div class="post-metadata">

**Author:** ![YF129701](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/yf129701/32/60498_2.png) [@YF129701](https://forum.inductiveautomation.com/u/YF129701)\
**Post date:** [July 16, 2024, 3:22pm UTC](https://forum.inductiveautomation.com/t/using-a-store-procdure-returns-a-count-of-rows-rather-than-dataset/93290/2 "2024-07-16T15:22:25Z")

</div>

Can you show a picture of the OEE/SWOEEScans Named Query? The reason why is the query type may be set to Scalar instead of Select.

---

<div class="post-metadata">

**Author:** ![ahawes](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ahawes/32/36337_2.png) [@ahawes](https://forum.inductiveautomation.com/u/ahawes)\
**Post date:** [July 16, 2024, 3:35pm UTC](https://forum.inductiveautomation.com/t/using-a-store-procdure-returns-a-count-of-rows-rather-than-dataset/93290/3 "2024-07-16T15:35:39Z")

</div>

That was it, thanks!!!

I was trying some differnt things yesterday and forgot to change it back.