Hello, I have a table in a sqlite database which looks like:
RowID : Dist : X : Y 1 : 1.24 : 15 : 15 2 : 0.66 : 13 : 17 3 : 0.82 : 8 : 12 4 : 2.14 : 17 : 19 5 : 1.83 : 15 : 13 I want to loop over the single entries of the database-table using Python: 1) a loop over the rowid from the beginning to the end (1 to 5) of the table and I want to get the values for X. The result should give: 15, 13, 8, 17, 15 2) I also want a loop over the list and want to get again X but in this case I want to get it in an ordered way, I want to get i ordered from the smalles Dist-value to the greatest Dist-value. So the result of the loop should be: 13, 8, 15, 15, 17 Do you know what I mean? How can I do that? How to loop over the entries of a sqlite database using Python? /Johannes -- GMX DSL Doppel-Flat ab 19,99 Euro/mtl.! Jetzt mit gratis Handy-Flat! http://portal.gmx.net/de/go/dsl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
