On May 8, 3:37 pm, all4one <[EMAIL PROTECTED]> wrote:
> Contributors have moved items in the order they wish to display on the
> page but the page displays the items in random order.
>
> I have four columns of content: Parent, Description, Image, and
> Title... the order should be based on the Title.  What am I missing?
>
> <!-- ResultSet Sort -->
<!--$ strNumRecords=ssGetXmlNodeCount(SS_DATAFILE, root & "/Title") --
>
<!--$ nNumRecords=toInteger(strTrimWs(strNumRecords)) -->
<!--$ nPos=1 -->

<!--$ rsCreateResultSet("ssListTemp", "Title,Image,Abstract,Parent") --
>
<!--$ rsCreateResultSet("ssList", "Title,Image,Abstract,Parent") -->

<!--$ loopwhile nPos <= nNumRecords -->
 <!--$ title = ssIncludeXml(SS_DATAFILE, root & "/" & "Title" & "[" &
nPos & "]/node()") -->
 <!--$ image = ssIncludeXml(SS_DATAFILE, root & "/" & "Image" & "[" &
nPos & "]/node()") -->
 <!--$ abstract = ssIncludeXml(SS_DATAFILE, root & "/" & "Abstract" &
"[" & nPos & "]/node()") -->
 <!--$ parent = ssIncludeXml(SS_DATAFILE, root & "/" & "Parent" & "["
& nPos & "]/node()") -->
 <!--$ rsAppendRowValues("ssListTemp", title & "," & image & "," &
strReplace(abstract,',','[EMAIL PROTECTED]') & "," & parent) -->
 <!--$ setValue("#local","count" & parent,getValue("#local","count" &
parent) + 1) -->
 <!--$ nPos=nPos+1 -->
<!--$ endloop -->

<!--$ rsMerge("ssList", "ssListTemp", "Title") -->
<!--$ rsSort("ssList","Title","string","asc") -->
<!--$ rsSort("ssList","Title","string","asc") -->

<!--$ rsCreateResultSet("ssParentList", "Title,Text,Count") -->

<!--$ strNumParentRecords=ssGetXmlNodeCount(SS_PARENTDATAFILE,
ssParentRoot & "/Title") -->
<!--$ nNumParentRecords=toInteger(strTrimWs(strNumParentRecords)) -->
<!--$ nParentPos=1 -->

<!--$ loopwhile nParentPos <= nNumParentRecords -->
 <!--$ title = ssIncludeXml(SS_PARENTDATAFILE, ssParentRoot & "/" &
"Title" & "[" & nParentPos & "]/node()") -->
 <!--$ text = ssIncludeXml(SS_PARENTDATAFILE, ssParentRoot & "/" &
"Text" & "[" & nParentPos & "]/node()") -->
 <!--$ rsAppendRowValues("ssParentList", title & "," &
strReplace(text,',','[EMAIL PROTECTED]') & "," & getValue("#active","count" &
title)) -->
 <!--$ nParentPos=nParentPos+1 -->
<!--$ endloop -->

Reply via email to