[V4MD2] SELECT LIMIT

[Heinrich Ruoff]

I thought 12 is the last position an not the total number of records
thanks - now LIMIT works as expected using 2.0.4 fc5

do you have a clue whats wrong with the strings from DB?
did there anything change in V4MD  2.0.4 fc5 regarding encoding?


On 6/13/05, Ivan Smahin <IvanSmahin at public.kherson.ua> wrote:
> Hello Heinrich,
> 
> Monday, June 13, 2005, 1:04:12 PM, you wrote:
> 
> HR> after update from 2.0.3 to 2.0.4 fc5
> HR> the first recordCount is reported correctly
> HR> ("SELECT * FROM tb_bje_artikel LIMIT 0,4")
> 
> HR> but "SELECT * FROM tb_bje_artikel LIMIT 8,12"
> HR> returns an recordCount of 12 instead of 4
> 
> This is wrong.
> "... LIMIT 8,12" means - 12 records starting after 8 position (9).
> 
> So we have 12 records
> 
> Try it - you can easy see affecyed rows
> SELECT RecID, * FROM tb_bje_artikel LIMIT 8,12
> 
> 
> --
> Best regards,
>  Ivan                            mailto:IvanSmahin at public.kherson.ua
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>