18 |
|
|
19 |
reply.setHeader("Refresh", "120"); |
reply.setHeader("Refresh", "120"); |
20 |
|
|
21 |
tntdb::Connection conn = tntdb::connect(dburl); |
tntdb::Connection conn = tntdb::connectCached(dburl); |
22 |
|
|
23 |
|
|
24 |
std::string query1; |
std::string query1; |
34 |
query2 += "SELECT temperature,flamedetector,conveyorerror,powerfailure "; |
query2 += "SELECT temperature,flamedetector,conveyorerror,powerfailure "; |
35 |
query2 += "FROM logtable "; |
query2 += "FROM logtable "; |
36 |
query2 += "WHERE installationnr = :v1 "; |
query2 += "WHERE installationnr = :v1 "; |
37 |
query2 += "ORDER BY messagenr DESC "; |
query2 += "ORDER BY messagenr DESC,logtime DESC "; |
38 |
query2 += "LIMIT 1"; |
query2 += "LIMIT 1"; |
39 |
|
|
40 |
|
|