X-Git-Url: http://git.smho.de/gw/?p=owTools.git;a=blobdiff_plain;f=src%2FmySensorDB.cpp;h=891282eef1a196bedac7df94b8d46a8946658098;hp=76631e31d87bb363a0dde3dda7575b8a8332995c;hb=c7cb52d06aae49ba200634f348af90414d78cfac;hpb=19b96d5dd54181e04c81f82ec7ca1a69198e2bd8 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])+", ";