vinu
vinu

Reputation: 191

How to get DB query result without extra comma being added when using robot framework

I am using Robot Framework to connect to the database. The connection query is:

${Result_Intake}= | Query | SELECT Use_Intake_Datapage_Flag FROM smCase_Type WHERE Case_Type_Code = 'VR'
Log ${Result_Intake}

The Problem is that the result that returned with is like [(False,)]. There is extra comma , added in the end of the result, and hence not able to make decision based on the result received from the query.

Upvotes: 0

Views: 512

Answers (1)

vinu
vinu

Reputation: 191

Got my answer. I have to Access the database like:

${Result_Intake[0][0]}

It seems to be a 2 dim Array

Upvotes: 3

Related Questions