[FX.php List] Sorting and Skipsize

Gjermund Gusland Thorsen ggt667 at gmail.com
Sat Aug 19 02:58:06 MDT 2006


Is this mistake also if you make a plain XML query?

ggt667

On 8/18/06, Jonathan Schwartz <jonathan at eschwartz.com> wrote:
> I am getting different records found, using ascending and descending
> sort order when there are more records than the groupsize.
>
> For example, if there are 11 records total with the search field
> being 100 through 110, and skipsize =10 and sort order is ascending,
> the resulting search finds:
>         100 101 102 103 104 105 106 107 108 109
>
> That's fine.
>
> When the same query is executed with descending sort order, I get:
>         110 109 108 107 106 105 104 103 102 101
>
> In essence, the sort is being executed before the skipsize determines
> the records to be shown
>
> How can the record list be preserved and the sort be applied to the
> same found set?
>
> Jonathan
> --
>
> Jonathan Schwartz
> FileMaker 8 Certified  Developer
> Associate Member, FileMaker Solutions Alliance
> Schwartz & Company
> jonathan at eschwartz.com
> http://www.eschwartz.com
> http://www.exit445.com
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>


More information about the FX.php_List mailing list