[FX.php List] Sorting and Skipsize

Erik Andreas Cayré erik at cayre.dk
Sat Aug 19 06:28:43 MDT 2006


Den 19/08/2006 kl. 10.58 skrev Gjermund Gusland Thorsen:

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

This is not a mistake.FM returns the first [skipsize] records of the  
found set, unless you specify a starting record.
This is equivalent to viewing the first 10 of 11 sorted records in  
FM. In descending order, you will see the exact same 10 first records  
as Jon listed...

Solutions...
1. You could split the work: find the records in FM and sort them in  
php (there are lots of array sorting functions in php)
2. If you always know in advance which records you want, you could  
set the starting returned record in the FX query

I'd probaly prefer 1., since it allows me to not know in advance  
which starting record to ask for...


---
Erik Andreas Cayré
Spangsbjerg Møllevej 169
DK-6705 Esbjerg Ø

Home Tel: +45 75150512
Mobile: +45 40161183

»If you can't explain it simply, you don't understand it well enough.«
-- Albert Einstein

»If you don't have time to do it right, when will you have time to do  
it over?«
-- John Wooden, basketball coach


-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 1856 bytes
Desc: not available
Url : http://www.iviking.org/pipermail/fx.php_list/attachments/20060819/56bf61c2/smime.bin


More information about the FX.php_List mailing list