For the DBI:mysql plugin, the example in the docs for TT shows something like this:
[% FOREACH thing = DBI.query('SELECT * FROM mytable') %]
[% thing.name %]
[% END %]This works good, but can I skip the foreach loop when I know I am just going to get one result(pri key)? I can't seem to make this work.
[% thing = DBI.query('SELECT name FROM mytable where name = "joe"') %]
[% thing.name %]
[% END %]I've tried with SET thing = ... too, but no go.. Are there any docs available for this plugin? Thanks for any pointers.
Ken A.
_______________________________________________ templates mailing list [EMAIL PROTECTED] http://lists.template-toolkit.org/mailman/listinfo/templates
