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

Reply via email to