Sam Carleton <scarle...@miltonstreet.com> wrote: > On Sun, Jun 20, 2010 at 5:23 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > >> In what way did the statement I gave you, exactly as written, fail to >> satisfy your requirements? > > Igor, > > When I put in EXACTLY what you gave me: > > SELECT FolderId, ImageId, instertedon FROM V_FAVORITES_SELECTED > WHERE case when instertedon > julianday(@time) then findImage(@path, > FolderId, ImageId) else 0 end;
Note that I only gave you the WHERE clause. The idea was to drop it into your statement, leaving other clauses intact. What happens if you append LIMIT 1 to the query above? -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
