Erin and Igor, I simply cannot wrap my head around the correct syntax. BAsed on the documentation, I believe I should be looking to make it fit this pattern:
CASE WHEN x=w1 THEN r1 WHEN x=w2 THEN r2 ELSE r3 END Does the WHERE clause get replaced with the WHEN clause like this: CASE SELECT FolderId, ImageId, instertedon FROM V_FAVORITES_SELECTED WHEN instertedon > julianday(@time) THEN findImage(@rootPath, FolderId, ImageId) ELSE 0 END; On Sun, Jun 20, 2010 at 12:02 PM, Erin Drummond <[email protected]> wrote: > You missed the "case when" part. > See "The CASE Expression" : http://www.sqlite.org/lang_expr.html > > On Mon, Jun 21, 2010 at 2:28 AM, Sam Carleton > <[email protected]> wrote: >> Igor, _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
