On Mon, Apr 4, 2011 at 12:26 PM, Simon Slavin <slav...@bigfraud.org> wrote: > But he's combining two INSERTs into one. What I think he needs is first an > INSERT OR FAIL to possibly add a new person, and then an INSERT ... SELECT > which looks up that person's ID.
I didn't see that in the original post. Did I miss it? But even so: INSERT ...; INSERT ... SELECT ... WHERE ... (SELECT EXISTS <row added in first INSERT>); :) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users