Forum .LRN Q&A: categories procs query

Collapse
Posted by Alvaro Rodriguez on
I'm using categories from 2.3.1 but it was modified, I noticed that in the repository there's a query in the generic xql that should be in a specific xql.

/categories/tcl/categories-procs.xql

fullquery name="category::get_parent.get_parent_id"
querytext

select parent_id
from categories
where category_id = :category_id
>>>> limit 1

/querytext
/fullquery

Collapse
2: Re: categories procs query (response to 1)
Posted by Dave Bauer on
Interesting. The limit 1 has no effect on that query anyway. It can just be removed since category_id is unique.
Collapse
3: Re: categories procs query (response to 1)
Posted by Dave Bauer on
I fixed it in cvs on HEAD and oacs-5-4 branch. I am not sure if any existing .LRN code uses this procedure.
Collapse
4: Re: categories procs query (response to 3)
Posted by Alvaro Rodriguez on
Thanks Dave,
I haven't found any calls to this proc in dotlrn packages (at least on my side 2.3.0), only in my code :)