"Webmaster" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Looping. > > Is there a way to put this into a loop where it starts again but with > the > next Field2 ='Red'
Replace all subqueries that look like this: (select Field1 from table1 where Field2='Red' order by Field1 limit 1) with something like this: (select Field1 from table1 where Field2='Red' order by Field1 limit 1 offset :X) and vary X in the loop, starting from 0, until you get an empty resultset. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
