in reply to Re^8: using template on same page
in thread using template on same page
Your SQL 'SELECT FOO, BAR, MOO FROM tble ...' returns records with 3 fields FOO, BAR and MOO.
If you want to display only the value in FOO use [% name.0 %] in the template, if BAR use [% name.1 %] and if MOO use [% name.2 %]. The values 0,1,2 corresponding to the position of each field in the select.
Best practice would be to select only the fields you need.
poj
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^10: using template on same page
by bigup401 (Pilgrim) on Sep 17, 2018 at 17:24 UTC |