Template Toolkit and DBI Changing Table Name by Variable

[seekperlwisdom]

[% USE DBI %]
[% DBI.connect('dbi:mysql:phones', 'user', 'password')%]
This is what we have

[% FOREACH fone = DBI.query('SELECT * FROM nokia') %]
    
    name : [% fone.modelno %]<br/>
    desc : [% fone.desc %]<br/>
    <img src="[% fone.image %]" width="60" height="60" alt="[% fone.mo
+delno %]" /><br/>
    price: [% fone.price %]<br/>

    [% END %]
    <hr/>

my templatetoolkit.pl access this tt.file. i want templatetoolkit.pl to pass value of a variable which would change table name in this tt.file. i can do it with perl block but there must be a way which i cant find.i tried
[% select * from [% tablename %] %]
which is stupid but hope it make sense what i am trying to achieve with Template Toolkit. regards,

[merlyn]

Use _ for concatenation.

[%
  sql = 'SELECT * FROM ' _ tablename;
  FOREACH fone = DBI.query(sql) %]

[seekperlwisdom]

thanks merlyn

[ikegami]

From what I can tell from reading the docs,

[% FOREACH fone = DBI.query("SELECT * FROM $tablename") %]

[seekperlwisdom]

thanks ' and " does make a big differnce i need to go back to LEARNING PERL again thanks

[ikegami]

You were executing a line of TT code, not a line of Perl code. Perl's rules don't apply. (Although Perl does the same thing here.)