On 20 Jun 2010, at 10:40pm, Sam Carleton wrote: > I am getting the EXACT same result, it calls findImage on for EVERY > row in the result set. The goal is to have the findImage() > short-circuit the where clause so that once it returns 1 one time, it > stops. Aka lots of 0's can be returned, but only one 1.
Then forget the fancy clause and just use LIMIT 1. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users