X-Git-Url: http://git.smho.de/gw/?a=blobdiff_plain;ds=sidebyside;f=src%2FmySensorDB.cpp;h=891282eef1a196bedac7df94b8d46a8946658098;hb=8b3ce8126a8bbc16822e939bc46f513e1c52b3d3;hp=76631e31d87bb363a0dde3dda7575b8a8332995c;hpb=c7561c5e50f1df4015c0c250bdbaa2efbb95a3bd;p=owTools.git diff --git a/src/mySensorDB.cpp b/src/mySensorDB.cpp old mode 100755 new mode 100644 index 76631e3..891282e --- 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])+", ";