Forum OpenACS Q&A: "select failed"(exception NSDB,....

Collapse
1: "select failed"(exception NSDB,....
Posted by Pol Vilarmau on 01/23/03 08:02 PM
Hi!

i've got the next error:

"select" failed (exception NSDB, "Query was not a statement returning rows.)
ERROR: parser: parse error at or near "("

the query is:

db_multirow domains domains_select {
  select *
    from cads_domains
    where cads_id = :package_id
    and acs_permission.permission_p(domain_id,:user_id,'cads_read_domain') = 't'
order by short_name
}

the error is in the "acs_permission....." line, but i don't know why!

I'm working on OpenACS 4.5 and postgres 7.1
Anybody could take me a hand?

Thanks, Pol Vilarmau

Collapse
2: Re: "select failed"(exception NSDB,.... (response to 1)
Posted by Don Baccus on 01/23/03 08:41 PM
It looks like you've got a query with Oracle rather than Postgres syntax.

"acs_permission.permission_p" in Oracle sez "the permission_p package which is part of the acs_permission package".

Postgres doesn't have packages.  What we've done is to map such functions into a form using double underbars, as in "acs_permission__permission_p"

(if the HTML rendering doesn't make it clear, the double underbar separates "acs_permission" and "permission_p")

Collapse
3: Re: "select failed"(exception NSDB,.... (response to 2)
Posted by Pol Vilarmau on 01/23/03 08:45 PM
Thanks Don! That's the solution!!! :)