> Which looks like it translates to:
>
> [% sql = 'SELECT * FROM table WHERE type = ? AND headline LIKE ?' %]
> [% query = DBI.prepare( sql ) %]
> [% FOREACH blah = query.execute( 'type', '%headline%' ) %]
> ...
> [% END %]
That worked, thanks.
I hope this will be my last question today. Now in the same LIKE case i
want to use CGI.param('smth') with %'s. How is the syntax then?
'%CGI.param('smth')%' won't work, i bet and CGI.param('%smth%') is very
different thing too. I tried this:
[% word = CGI.param('smth') %] and then
[% query.execute('%word%') %], but i used '%word%' instead of '%smth%',
which is correct of course. So what now (again)?
P.S. How can i merge some textual variables into one? In perl it's looks
like
var1 = var2 . var3, or var1 = "text1" . "text2" (you get the point)
but in TT it doesn't seem to work and in docs i didn't find any examples
too.
Rgds,
Viljo
