Getting error ( invalid identifier) when I am trying to pass variable in SQL Query through SAHI

gyanadeep

Here is my details-

$AAA = 9015066384

var $db = _getDB( db connection);
var $Data = "SELECT * FROM table WHERE XXX =" + $YYY; (when I use _alert function to see the value in the YYY variable then I can see the correct value there)
var $rscom1 = $db.select($Data);

Then I am trying the value with the DB value.

_assertEqual($AAA , $rscom1[0]["ZZZ"]);

But getting below error-

error- exception: java.sql.SQLSyntaxErrorException: ORA-00904: "FBEU00001IHQ": invalid identifier

FBEU00001IHQ this is the value for $YYY

Pratyush_Tyto

Hi gyanadeep,
I think passing the variable $YYY in single quotes should solve the problem that you're facing.

Regards.