Given the data model below, does anyone know of a package or module that
would generate code for, or fill in, an HTML::Template like that
provided below the database ddl? If not, would there be interest in
such a module if I could create it?
Ron
create table books (
book_id integer,
title varchar(1024),
isbn varchar(80)
);
create table authors (
author_id integer,
book_id integer references books(book_id),
last_name varchar(80),
first_name varchar(80)
);
<html>
<head><title>Test Template</title>
<body>
<TMPL_LOOP NAME="+books">
<ul>
<li />Title is "<TMPL_VAR NAME=".title">"
<li />ISBN is <TMPL_VAR NAME=".isbn">
<li />Authors are:
<ul>
<!-- name below is shorthand for +books.book_id.authors -->
<!-- could still be abbreviated to +authors if fk's link
tables -->
<TMPL_LOOP NAME=".book_id.authors:ORDER_BY:.last_name,.first_name" >
<li /><TMPL_VAR NAME=".last_name">, <TMPL_VAR
NAME=".first_name">
</TMPL_LOOP>
</ul>
</ul>
</TMPL_LOOP>
</body>
</html>
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Html-template-users mailing list
Html-template-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/html-template-users
