# Print column 1 Row 1 from Dataset using Python?

**URL:** <https://forum.inductiveautomation.com/t/print-column-1-row-1-from-dataset-using-python/11540>\
**Category:** Ignition\
**Created:** [April 19, 2016, 7:46pm UTC](https://forum.inductiveautomation.com/t/print-column-1-row-1-from-dataset-using-python/11540 "2016-04-19T19:46:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tbackus](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tbackus/32/5091_2.png) [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\
**Post date:** [April 19, 2016, 7:46pm UTC](https://forum.inductiveautomation.com/t/print-column-1-row-1-from-dataset-using-python/11540/1 "2016-04-19T19:46:30Z")

</div>

So here’s the deal, I am using a script to run a stored procedure in MSSQL, I get a dataset returned “Dataset [1R ? 1C]”

How do I print that value? Apparently the Stored procedure is returning the column name and the value

Here’s my code:

`scanRead = 'C7717343800011'
call = system.db.createSProcCall("spGetCartonLaneAssignment")
call.registerReturnParam(system.db.VARCHAR)
call.registerInParam(1, system.db.VARCHAR, scanRead)	
system.db.execSProcCall(call)	
laneAssignment = call.getResultSet()
print scanRead
print laneAssignment`

The last line “print laneAssignment” I want to just return “2” For the life of me I cannot figure this out. Should be simple?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 19, 2016, 8:18pm UTC](https://forum.inductiveautomation.com/t/print-column-1-row-1-from-dataset-using-python/11540/2 "2016-04-19T20:18:57Z")

</div>

```auto
print laneAssignment.getValueAt(0,0)
```

---

<div class="post-metadata">

**Author:** ![tbackus](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tbackus/32/5091_2.png) [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\
**Post date:** [April 20, 2016, 12:59pm UTC](https://forum.inductiveautomation.com/t/print-column-1-row-1-from-dataset-using-python/11540/3 "2016-04-20T12:59:20Z")

</div>

Perfect. I knew it was something simple I just couldn’t find.

Thanks!