tntnet/dynamic/customerlist.ecpp

<%pre>
#include <tntdb/connect.h>
#include <tntdb/connection.h>
#include <tntdb/result.h>
#include <tntdb/row.h>

#include "common.h"
</%pre>

<%config>
dburl;
</%config>

<&header title="Critical systems">
</&header>

<h2>Customers and installations</h2>

<{
tntdb::Connection conn;

conn = tntdb::connect(dburl); //letting exceptions flow up and to tntnet and let it display an error message

std::string customer_sql = "SELECT id,name,address,phonenr,contactperson FROM customer ORDER BY name ASC";

tntdb::Result res = conn.select(customer_sql);

std::ostream& out = reply.out();

if (res.size() != 0)
{
        for (tntdb::Result::const_iterator it = res.begin(); it != res.end(); ++it)
        {
                tntdb::Row row = *it;
                out << "<table border=1 width=80% cellspacing=0 align=center><tr><td>";
                out << "<b>" << row.getString(1) << "</b><br>\n\n";


                out << nl2br(row.getString(2)) << "<br>\n";


                out << "</td></tr></table><br>\n";

        }
}
else
{
        out << "<i>No customer records found!</i>";
}

}>

<&footer>
</&footer>
1	torben	71	<%pre>
2			#include <tntdb/connect.h>
3			#include <tntdb/connection.h>
4			#include <tntdb/result.h>
5			#include <tntdb/row.h>
6
7			#include "common.h"
8			</%pre>
9
10			<%config>
11			dburl;
12			</%config>
13
14			<&header title="Critical systems">
15			</&header>
16
17			<h2>Customers and installations</h2>
18
19			<{
20			tntdb::Connection conn;
21
22			conn = tntdb::connect(dburl); //letting exceptions flow up and to tntnet and let it display an error message
23
24			std::string customer_sql = "SELECT id,name,address,phonenr,contactperson FROM customer ORDER BY name ASC";
25
26			tntdb::Result res = conn.select(customer_sql);
27
28			std::ostream& out = reply.out();
29
30			if (res.size() != 0)
31			{
32			for (tntdb::Result::const_iterator it = res.begin(); it != res.end(); ++it)
33			{
34			tntdb::Row row = *it;
35			out << "<table border=1 width=80% cellspacing=0 align=center><tr><td>";
36			out << "<b>" << row.getString(1) << "</b><br>\n\n";
37
38
39			out << nl2br(row.getString(2)) << "<br>\n";
40
41
42			out << "</td></tr></table><br>\n";
43
44			}
45			}
46			else
47			{
48			out << "<i>No customer records found!</i>";
49			}
50
51			}>
52
53			<&footer>
54			</&footer>