Forum OpenACS Q&A: Response to ETP and Oracle ... can someone help?

Collapse
Posted by Jun Yamog on

Hi Don,

I can not commit myself for this since I am very busy right now. Anyway I would not like ETP to be left out of Oracle. So I fired up my oracle and crossed my fingers that my oracle still works. Its been while since I used my Oracle.

Here is the first fix on tcl/etp-procs-oracle.xql this is the correct query clause

<partialquery name="etp::get_content_items.gci_orderby">
  <querytext>
	sort_order
  </querytext>
</partialquery>

I have also found a bug in moving the sort order. So I think the problems with ETP will be to deal with the tree_sortkey in Oracle. I will try to fix but no promises.

Guys and Gals please pitch in. I know Luke P is also very busy that is why ETP 2.0 is not moving that much. I know for sure I am guilty of not moving ETP 2.0.