> And, can I depend on SQLite to generate results in the same order as the > original prepare/step sequence and the temp table generation, ie. is the > temp table's rowid going to be consistent with the original step order?
If you use an ORDER BY clause, yes. If not, then the rows are returned in random order. As for the rest of your questions, why do you not just join the search conditions with an AND? --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users