[V4MD2] SELECT LIMIT

[Heinrich Ruoff]

all Data in Field Type "Text" is still working
all Data in Fileld Type "VarChar" won't work

On 6/13/05, Heinrich Ruoff <heinrichruoff at gmail.com> wrote:
> 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
> >
>