diff options
| -rw-r--r-- | netconf-service/netconf.cpp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/netconf-service/netconf.cpp b/netconf-service/netconf.cpp index 7c8bcb6e..7e57562a 100644 --- a/netconf-service/netconf.cpp +++ b/netconf-service/netconf.cpp @@ -164,7 +164,7 @@ int main(int argc,char **argv) Dictionary to; { Query q = dbCon->query(); - q << "SELECT LOWER(HEX(Node_id)) AS Node_id,LOWER(HEX(Network_id)) AS Network_id FROM QNetworkConfigRefresh"; + q << "SELECT DISTINCT LOWER(HEX(Node_id)) AS Node_id,LOWER(HEX(Network_id)) AS Network_id FROM QNetworkConfigRefresh"; StoreQueryResult rs = q.store(); for(unsigned long i=0;i<rs.num_rows();++i) { std::string &nwids = to[rs[i]["Node_id"]]; |