2011/6/25 Kees Nuyt <k.n...@zonnet.nl> > > selectStr=" > > SELECT categories.desc > > , weights.measureDate > > , weights.weight > > , weights.fat > > , weights.water > > , weights.muscle > > FROM weights > > , categories > > WHERE categories.desc = 'Cecil' > > AND weights.categoryID = categories.id > > ORDER BY weights.measureDate DESC > > LIMIT ${SHOW_NUMBER} > > ; > > " > > for record in $(echo "${selectStr}" | sqlite3 ${DATABASE} | tac) ; do > > If you like, you can tac in SQL: > > selectStr=" > SELECT * FROM ( > SELECT categories.desc > , weights.measureDate > , weights.weight > , weights.fat > , weights.water > , weights.muscle > FROM weights > , categories > WHERE categories.desc = 'Cecil' > AND weights.categoryID = categories.id > ORDER BY weights.measureDate DESC > LIMIT ${SHOW_NUMBER} > ) ORDER BY weights.measureDate > ; > " >
Is a lot neater and also a little more efficient. Thanks again. -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users