diff options
| author | Adam Ierymenko <adam.ierymenko@gmail.com> | 2013-10-17 05:40:04 -0400 |
|---|---|---|
| committer | Adam Ierymenko <adam.ierymenko@gmail.com> | 2013-10-17 05:40:04 -0400 |
| commit | 555471200c10f0b208b658dc460068ef64d8dbe2 (patch) | |
| tree | 6664fd57948331f3f91c289fdb08306fc08a3974 | |
| parent | 7e7e28f5f7d53df8f4897b243088d2f664651ae6 (diff) | |
| download | infinitytier-555471200c10f0b208b658dc460068ef64d8dbe2.tar.gz infinitytier-555471200c10f0b208b658dc460068ef64d8dbe2.zip | |
Add DISTINCT to queue query.
| -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"]]; |