On Mon, Oct 25, 2004 at 09:42:04AM -0400, Robert wrote:
> 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.
One suggestion would be to rewrite your SQL to give your columns aliases
which don't contain dots.
SELECT surname, first_name, msf810.email_address as email_address,
msf810.employee_id as employee id
and then...
<td>[% user.SURNAME %]</td>
<td>[% user.FIRST_NAME %]</td>
<td>[% user.EMAIL_ADDRESS %]</td>
<td>[% user.EMPLOYEE_ID %]</td>
(all this untested as I don't have an oracle installation to hand)
Dave...
--
We are far too young and clever
_______________________________________________
templates mailing list
[EMAIL PROTECTED]
http://lists.template-toolkit.org/mailman/listinfo/templates
