>>>>> "Gert" == Gert Brinkmann <[email protected]> writes:
Gert> You have to use quotes I guess:
Gert> SELECT * FROM projects WHERE NameProject = '$project'
Gert> It would be better if the DBI plugin would offer parameter binding. I do
Gert> not know this plugin yet. Maybe it is possible to write something like:
Gert> SELECT * FROM projects WHERE NameProject = ?
Gert> ...
Gert> parameters = [$project]
Yes, it *does* support parameter binding, which should
always be preferred to interpolation.
[%
query = DBI.prepare('SELECT * FROM projects WHERE NameProject = ?';
FOREACH row = query.execute(project);
...;
END;
%]
(If only we could make interpolation illegal... :)
--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<[email protected]> <URL:http://www.stonehenge.com/merlyn/>
Smalltalk/Perl/Unix consulting, Technical writing, Comedy, etc. etc.
See http://methodsandmessages.vox.com/ for Smalltalk and Seaside discussion
_______________________________________________
templates mailing list
[email protected]
http://mail.template-toolkit.org/mailman/listinfo/templates
