Forum .LRN Q&A: categories procs query

Collapse
1: categories procs query
Posted by Alvaro Rodriguez on 09/10/08 05:35 PM
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 09/10/08 05:52 PM
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 09/10/08 05:58 PM
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 09/10/08 06:17 PM
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 :)