Parent Directory | Revision Log | Patch
revision 126 by torben, Sun Dec 2 20:26:43 2007 UTC | revision 157 by torben, Wed Dec 5 11:48:38 2007 UTC | |
---|---|---|
# | Line 8 | Line 8 |
8 | std::string createInstallationSelector(tntdb::Connection& conn) | std::string createInstallationSelector(tntdb::Connection& conn) |
9 | { | { |
10 | std::stringstream out; | std::stringstream out; |
11 | tntdb::Result res = conn.select("SELECT c.name, i.id, i.description FROM customer c INNER JOIN installation i ON c.id = i.customerid"); | tntdb::Result res = conn.select("SELECT c.name, i.id, i.description FROM customer c INNER JOIN installation i ON c.id = i.customerid ORDER BY name,description"); |
12 | ||
13 | out << "<select name='installation'>\n"; | out << "<select name='installation'>\n"; |
14 |
|
ViewVC Help | |
Powered by ViewVC 1.1.20 |