"Charles Jardine" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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. >
I bet it is the upper case thing. I went home and created a small SQLite database and reran the example and it worked fine. I will try that when I get back to work. Robert _______________________________________________ templates mailing list [EMAIL PROTECTED] http://lists.template-toolkit.org/mailman/listinfo/templates
