# Error in Pipeline Script block

**URL:** <https://forum.inductiveautomation.com/t/error-in-pipeline-script-block/30889>\
**Category:** Ignition\
**Created:** [December 22, 2019, 7:37am UTC](https://forum.inductiveautomation.com/t/error-in-pipeline-script-block/30889 "2019-12-22T07:37:23Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![rafi.shaik](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@rafi.shaik](https://forum.inductiveautomation.com/u/rafi.shaik)\
**Post date:** [December 22, 2019, 7:37am UTC](https://forum.inductiveautomation.com/t/error-in-pipeline-script-block/30889/1 "2019-12-22T07:37:23Z")

</div>

Hi,  
I am new to Ignition, Can anyone help me out.  
I am trying to bring email id from database and sending email with Script block in pipeline.I am getting error massage as Error executing scripting block in logs. I am triggering script block with Switch block then Script block will start executive and have to send email to the user.Can u please tell me can i send email with Script block without notification block for dynamic users.

The following is Script which is written in Script block.

query = system.db.runScalarQuery(" SELECT email\_id FROM database.userlist where user\_id = 2")  
recipients = [query]  
body = “Hello, this is an email”  
smpt = “[smpt.gmail.com:465](http://smpt.gmail.com:465):tls”  
system.net.sendEmail(“mail.gmail.com”,"myemail@gmail.com", “Here is the email!”, body, 0, recipients)

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [December 22, 2019, 3:17pm UTC](https://forum.inductiveautomation.com/t/error-in-pipeline-script-block/30889/2 "2019-12-22T15:17:44Z")

</div>

> [@rafi.shaik](#):
>
> recipients = [query]

It looks like this part is where your error is. For scripts, I'd recommend using the script playground tool to get them working first.

This should instead be something like this (not in front of pc to check):

```auto
#edit: this won't work, need to convert query to a pydataset, or use an incrementer and then val.getValueAt(i,0)
recipients = [Val.getValueAt(0) for Val in query]

```

---

<div class="post-metadata">

**Author:** ![rafi.shaik](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@rafi.shaik](https://forum.inductiveautomation.com/u/rafi.shaik)\
**Post date:** [December 22, 2019, 3:47pm UTC](https://forum.inductiveautomation.com/t/error-in-pipeline-script-block/30889/3 "2019-12-22T15:47:58Z")

</div>

I have tried what you suggested but its shows same error.

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [December 22, 2019, 8:54pm UTC](https://forum.inductiveautomation.com/t/error-in-pipeline-script-block/30889/4 "2019-12-22T20:54:14Z")

</div>

Did you try the script in the scrip playground tool?  
Also sorry, my late-night brain failed me.

Use this:

```auto
recipients = [row[0] for row in system.dataset.toPyDataset(query)]

#or this
recipients = [query.getValueAt(i,0) for i in range(query.getRowCount())] 

```

---

<div class="post-metadata">

**Author:** ![rafi.shaik](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@rafi.shaik](https://forum.inductiveautomation.com/u/rafi.shaik)\
**Post date:** [December 23, 2019, 5:52am UTC](https://forum.inductiveautomation.com/t/error-in-pipeline-script-block/30889/5 "2019-12-23T05:52:31Z")

</div>

Thanks you for your respond.  
Actually i am working in Alarm Notification Pipeline.  
Yes i was tested in Script console.But i am unable to get dataset from database.

I am getting like this in Script console.

Traceback (most recent call last):  
File “”, line 2, in   
AttributeError: ‘int’ object has no attribute ‘getRowCount’

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [December 23, 2019, 3:05pm UTC](https://forum.inductiveautomation.com/t/error-in-pipeline-script-block/30889/6 "2019-12-23T15:05:46Z")

</div>

Actually, you were right in your first post: the scalar function just returns a single value. Go back to that but include the database name as the 2nd argument.