Skip to Content
2
Former Member
Sep 28, 2012 at 09:28 AM

SQL script issue

155 Views

hello experts,

I am new to BOIS and wrote below statement in the rule:

$aa = SQL('connection', 'SELECT count(*) FROM table 1 where field1 = \'$parameter0\''' ); $parameter0 is varchar

if ($aa > 0 )

return true;

else

return false;

....

The issue is if I use a constant instead of the parameter like (where field1 = \'1000\') the result is correct.

But if I use parameter like above, the result is always false.

Could you please let me know where is my fault. thank you in advance.