I have the following tt2/html code:
[% USE DBI('dbi:mysql:netstore','root','Saverio') %]
[% query = "SELECT * FROM projects WHERE NameProject = $project" %]
[% query %]
[% pdata = DBI.prepare($query) %]
[% column = pdata.execute %]
<tr><td>Project type: [% column.Type %]</td></tr>
<tr><td>Project language: [% column.Language %]</td></tr>
<tr><td>Project description: [% column.Description %]</td></tr>
[% query %] is correct, that is to say SELECT * FROM projects WHERE NameProject
= Prova
When I try to capture values in column.Type, column.Language and
column.Description I obtain empty values.
Where is the problem?
Thank you in advance,
Savio
_______________________________________________
templates mailing list
[email protected]
http://mail.template-toolkit.org/mailman/listinfo/templates