Print column 1 Row 1 from Dataset using Python?

Ignition
1

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?

1 Like
2 
print laneAssignment.getValueAt(0,0)
2 Likes
3

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

Thanks!