X-Git-Url: https://git.smho.de/gw/?a=blobdiff_plain;f=src%2FmySensorDB.cpp;h=891282eef1a196bedac7df94b8d46a8946658098;hb=17ea6dc449cad650a4c783446ab048c12e44c666;hp=76631e31d87bb363a0dde3dda7575b8a8332995c;hpb=c7561c5e50f1df4015c0c250bdbaa2efbb95a3bd;p=owTools.git diff --git a/src/mySensorDB.cpp b/src/mySensorDB.cpp index 76631e3..891282e 100755 --- a/src/mySensorDB.cpp +++ b/src/mySensorDB.cpp @@ -193,7 +193,7 @@ int mySensorDB::insertValues(owDevice *dev) { sprintf(hs,"%016llX",(unsigned long long)dev->getNum().num); std::string query; query="INSERT INTO `"+mypre+"OW"+std::string(hs)+"` ("; - for (size_t i=0;i<4;i++) if (dev->config->getPropertyID(i)!=0) query+=std::string(hs)+"_"+std::to_string(i+1)+", "; + for (size_t i=0;i<4;i++) if (dev->config->getPropertyID(i)!=0) query+="`"+std::string(hs)+"_"+std::to_string(i+1)+"`, "; query.pop_back();query.pop_back(); query+=") VALUES ("; for (size_t i=0;i<4;i++) if (dev->config->getPropertyID(i)!=0) query+=std::to_string(dev->values[i])+", ";