[Templates] Returning a select using multiple tables

[prev] [thread] [next] [Date index for 2004/10/25]

My select statments looks like this (from ORACLE):

SELECT surname, first_name, msf810.email_address, msf810.employee_id

When I plug this into a loop it looks like this:

            <td>[% user.SURNAME %]</td>
            <td>[% user.FIRST_NAME %]</td>
            <td>[% user.MSF810.EMAIL_ADDRESS %]</td>
            <td>[% user.MSF810.EMPLOYEE_ID %]</td>

TT2 apparently does not like it when there are multiple periods. So how do I
get around this? In a "normal" Perl script I would just do a "bind_columns"
but I do not know where to insert that, if I even can. I am searching via
Google but nothing so far.

Robert




_______________________________________________
templates mailing list
templates@xxxxxxxxxxxxxxxx.xxx
http://lists.template-toolkit.org/mailman/listinfo/templates