Question about mysql-d Object
Márcio Martins via Digitalmars-d-learn
digitalmars-d-learn at puremagic.com
Mon Dec 7 08:02:00 PST 2015
On Monday, 7 December 2015 at 14:40:12 UTC, Martin Tschierschke
> When I do the following:
> auto mysql = new Mysql("localhost", 3306, "mt", "",
> auto rows = mysql.query("select field from my_table limit 50");
> // second time same loop
> I only get the output of the first loop (50 lines), probably
> this is a feature
> not a bug, but what kind of Object is rows?
> A nested loop, did not worked either:
> Which other ways to access the elements of rows do I have?
> Sorry, but I am very new on D, (it may be the best language
> available, I don't know yet, but it is really the most
> interesting!) thank you!
I suppose that's because the rows object is a mysql cursor, which
means you can only iterate it once, and only forward (Not sure
how it is implemented in mysql-d). It seems like your inner loop
is exhausting it.
If you need random access or multiple iterations, you first need
to copy your rows into another array/structure, and then you can
do whatever you want with it.
More information about the Digitalmars-d-learn