Robert wrote:
I am using the TT book. On page 357, Example 9-1 it describes how to get a
product listing. My code follows that example:
[% USE DBI("dbi:Oracle:ELLTST", "*****", "*****") -%]
[% FOREACH user = DBI.query("SELECT surname, first_name FROM msf810")
-%]
<tr><td>[% user.surname %]</td><td>[% user.first_name %]</td></tr>
[% END -%]
When I run this I get a bunch of table rows with no data in them (and there
is data there). Am I missing something (besides brains)?
Oracle column names are really in UPPER CASE.
Either user the upper case names to retrieve the values from the
row, like:
<tr><td>[% user.SURNAME %]</td><td>[% user.FIRST_NAME %]</td></tr>
or better, ask the DBI to translate the names into lower case
like:
[% USE DBI("dbi:Oracle:ELLTST", "*****", "*****",
{ FetchHashKeyName='NAME_lc' }) -%]
See 'perldoc DBI' to find out what you can put in the 4th
argument to connect.
--
Charles Jardine - Computing Service, University of Cambridge
[EMAIL PROTECTED] Tel: +44 1223 334506, Fax: +44 1223 334679
_______________________________________________
templates mailing list
[EMAIL PROTECTED]
http://lists.template-toolkit.org/mailman/listinfo/templates
