"recursive_access" by database read..

gligo

I am trying to read this sql statement:
select name from object_products where id=111

But as a result I get: recursive_access
If I want to retrieve more column, like:
select name, obj from object_products where id=111
works ok.
Why is that?

The other question is: How can I trim all these [[]] that are comming as a return result from the function? ex. "recursive_access"

My function is:
function ReadFromDB($driver, $url, $user, $psw, $query, $expected) {
var db=_getDB($driver, $url, $user, $psw);
$rs = db.select($query);
_assertEqual($rs, $expected);

narayan

I am not sure. We will look into this.

Could you check if this works:

select name as 'xxname' from object_products where id=111

Thanks,
Narayan

gligo

No, same result

chaudharyparesh

i m facing same problem
my query like
var $rs = db.select("select password from user where username='appliance'");
_log($rs,"info");
in Log it's display _log("recursive_access","info");
I also edit my query
var $rs = db.select("select 'password' from user where username='appliance'");
But result is same.





Any Idea

gligo

I will tell you what I did, because I didn't receive a decision:

$rs = db.select("select id, name from table_products where name='Product1'");
$Prod1 = $rs[0]["id"];

So you can take out, what ever column you need, but you have to have in the query more then 1 column to return

If someone can give better decision would be nice, otherwise this way works without any problems by me.

chaudharyparesh

Thanks gligo

it's works