/[H9]/trunk/tntnet/dynamic/customerlist.ecpp
ViewVC logotype

Diff of /trunk/tntnet/dynamic/customerlist.ecpp

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 74 by torben, Tue Nov 27 22:25:36 2007 UTC revision 122 by torben, Sun Dec 2 16:56:14 2007 UTC
# Line 13  Line 13 
13  dburl;  dburl;
14  </%config>  </%config>
15    
16  <&header title="Critical systems">  <&header title="Customers and installations">
17  </&header>  </&header>
18    
19  <h2>Customers and installations</h2>  <h2>Customers and installations</h2>
# Line 50  if (res.size() != 0) Line 50  if (res.size() != 0)
50                  std::stringstream sqlstream;                  std::stringstream sqlstream;
51                  sqlstream << "SELECT id, description FROM installation ";                  sqlstream << "SELECT id, description FROM installation ";
52                  sqlstream << "WHERE customerid = " << customerid;                  sqlstream << "WHERE customerid = " << customerid;
53                    sqlstream << " ORDER BY description ASC";
54    
55                  tntdb::Result instres = conn.select(sqlstream.str());                  tntdb::Result instres = conn.select(sqlstream.str());
56    
57                  if (instres.size() > 0)                  if (instres.size() > 0)
58                  {                  {
59                          out << "Installations:\n";                          out << "Installations:\n";
60                          out << "<ol style='margin-top:0px;'>\n";                          out << "<ol>\n";
61                          for (tntdb::Result::const_iterator instit = instres.begin(); instit != instres.end(); ++instit)                          for (tntdb::Result::const_iterator instit = instres.begin(); instit != instres.end(); ++instit)
62                          {                          {
63                                  tntdb::Row instrow = *instit;                                  tntdb::Row instrow = *instit;
Legend:
Removed from v.74  
changed lines
  Added in v.122
  ViewVC Help
Powered by ViewVC 1.1.20