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	<%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>