On Mon, Apr 4, 2011 at 12:26 PM, Simon Slavin <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
