Forum OpenACS CMS: problem on cms/tcl/pagination-procs-<db_name>.xql

Hello,

It seems that cms/tcl/pagination-procs-<db_name>.xql is being reported
as a not well formed xml.  I have looked at it it seems to be ok.
Here are the contents of pagination-procs-oracle.xql:

<?xml version="1.0"?>
<queryset>

<partialquery="pagination::paginate_query.pg_paginate_query">
    <querytext>

      select *
      from
        (
          select
            x.*, rownum as row_id
      from
        ($sql) x
        ) ordered_sql_query_with_row_id
      where
        row_id between $start_row and $start_row + $rows_per_page - 1

    </querytext>
</partialquery>

</queryset>

Looks to be an ok xml.  So I dont know if this is a bug so I did not
post it on the SDM also cms is still on datamodel state.  I have
encountered this problem for about a week now.  So what I do everytime
after is CVS update is that I delete this files.  If its not deleted
ACS will not run if installed already or cms will not install during
ACS installation.

Can someone tell me if there is indeed a problem?  Thanks.

Jun

When did you last do a cvs update?  Roberto and I have been doing quite a bit of work on cms lately, so that problem should be fixed.  I'm currently running a fresh install from cvs, and I don't see the problem.
I think the XML error is in this line:
<partialquery="pagination::paginate_query.pg_paginate_query">
It should be:
<partialquery name="pagination...>
I just checked out from CVS and it looks like the error is in the -oracle version, but not the -postgresql version.
I haven't done any testing of cms with oracle yet, so I missed that.  It's fixed now.
Thanks Dan and Vinod.  It has been fixed.

Jun