No I am sorry but I need to query the ping_timeout column from inside the same query.
-- Marco Bambini http://www.sqlabs.com On Jun 12, 2011, at 2:02 PM, Roger Andersson wrote: > On 06/12/11 01:52 PM, Marco Bambini wrote: >> things are recently changed in my app and ping_timeout is now a client >> property set inside the Clients table (and no longer a global property), so >> I would like to perform the query: >> snprintf(sql, sizeof(sql), "select id from Clients where last_activity< >> datetime('now', '-%d.00 seconds', 'localtime');", settings.ping_timeout); >> using just the ping_timeout column in the Clients table instead of the >> settings.ping_timeout global property. >> >> Any idea? > snprintf(sql, sizeof(sql), "select id from Clients where last_activity < > datetime('now', '-%d.00 seconds', 'localtime');", ping_timeout); > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
