Hi.

Thanks for the pointers in my previous question. After I knew what to search for, I looked up several Zope docs and did what I wanted. However, I would like to ask some more questions:

I have the following statement:

<dtml-in searchField>
OR
FirstNameMI like <dtml-sqlvar sequence-item type="string">
OR
LastName like <dtml-sqlvar sequence-item type="string">
</dtml-in>

Where searchField is returned as searchField:tokens. So far so good. I want to put % in front, and after every keyword. So I try something like:

FirstNameMI like <dtml-sqlvar expr='%'+sequence-item+'%' type="string">

However, because now I use an assignment operator for an expression, Zope takes sequence-item as two separate things, sequence minus item. Is there a way to work around this? I tried everything I could think of, but still the same. I would like to avoid having to use a simple dtml-var because I read in the docs that it's better for security this way (e.g. someone can't write DELETE * FROM tableName in the query).

My final question, is regarding the previous, next results navigation options. (e.g. Previous 5 results, or Next 5 results). How can I have these two side by side? It seems that if I take the previous results link from the top and put it at the bottom, it doesn't appear, because there are some <dtml-if> statements before.

Thanks in advance,

Alex