18 January 2026:
Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.
This forum is now archived and is in read-only mode. Please continue discussions on our improved new Sahi Pro Community forum.
Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.
mysql query return by sahi is not in correct format.
Anila
Members
Hi,
I am used below mysql query to connect to mysql db and get results.The mysql db has IOT tables and guess the query retun is in binary values.
var db = _getDB("com.mysql.jdbc.Driver",
"jdbc:mysql://mysqlcache02-stage3.stage3.dc2.responsys.com:3306/qa37_cust",
"iddp_cache_sl", "3slp4ssw0rd");
var $rs = db.select("SELECT VALUE_ FROM s_007502_00000001024_000063 s;");
_alert($rs[0]["VALUE_"]);
_alert($rs[1]["VALUE_"]);
QUERY RESULTS in SAHI
_alert("\u0007\u0000\u0001C\u0007\u0000\u000222\u0007\u0000\u0007Kareena\u0007\u0000\u0001D\u0007\u0000\u001a2012-01-16 02:42:57.882869\u0007\u0000\u001a2012-01-16 02:42:57.882869");
_alert("\u0007\u0000\u0001A\u0007\u0000\u000221\u0007\u0000\u0007Sharukh\u0007\u0000\u0001B\u0007\u0000\u001a2012-01-16 02:42:22.559519\u0007\u0000\u001a2012-01-16 02:42:22.559519");
The actual message which is stored in db:
'C''22''Kareena', ''D'<some more values>
'A''21''Sharukh', ''B'<some more values>
Can any one please help me how to get the query result the way how its stored in db?
I am used below mysql query to connect to mysql db and get results.The mysql db has IOT tables and guess the query retun is in binary values.
var db = _getDB("com.mysql.jdbc.Driver",
"jdbc:mysql://mysqlcache02-stage3.stage3.dc2.responsys.com:3306/qa37_cust",
"iddp_cache_sl", "3slp4ssw0rd");
var $rs = db.select("SELECT VALUE_ FROM s_007502_00000001024_000063 s;");
_alert($rs[0]["VALUE_"]);
_alert($rs[1]["VALUE_"]);
QUERY RESULTS in SAHI
_alert("\u0007\u0000\u0001C\u0007\u0000\u000222\u0007\u0000\u0007Kareena\u0007\u0000\u0001D\u0007\u0000\u001a2012-01-16 02:42:57.882869\u0007\u0000\u001a2012-01-16 02:42:57.882869");
_alert("\u0007\u0000\u0001A\u0007\u0000\u000221\u0007\u0000\u0007Sharukh\u0007\u0000\u0001B\u0007\u0000\u001a2012-01-16 02:42:22.559519\u0007\u0000\u001a2012-01-16 02:42:22.559519");
The actual message which is stored in db:
'C''22''Kareena', ''D'<some more values>
'A''21''Sharukh', ''B'<some more values>
Can any one please help me how to get the query result the way how its stored in db?