[Zope] concatenate

Horvath Adam halinuxkata@freemail.hu
Thu, 18 Apr 2002 08:37:25 +0200 (CEST)


I have a problem with concatenating.

There are two dtml method.
One with a form with three select variable: year, month 
and day

The other dtml method process the form and call a zsql 
method in a loop
again and again when the "next or previous x hit" link is 
clicked.

In the zsql method:
select * from table 
<dtml-sqlgroup where>
    <dtml-sqltest concatenateddate column=date type=int 
op=like>
</dtml-sqlgroup>

So the problem:
If I concatenate the date in zsql method. (three 
arguments: year,month,day)
Only the first  10 hit are find with the specified date 
and at the 
next 10 and more hits the date term is ignored.

But, if I concatenate the three form variables in  the 
processing dtml method
before calling the zsql-loop and REQUEST.set
('concatenateddate' , ....
and call zsql method in loop(It has only one argument now.)
The result is the same. Only the first 10 hit are find 
with the specified date
and at the next 10 and more hits  the date term is ignored.

And I don't like the date term to be ignored from the 
second loop. 
How can I do this job?
(I've been thinking about it for three days :) )

An another questions: I'd like to build multi-language 
website.
I imagined that there is a dictionary text file with all 
the words and
sentences of the program in several languages. And the 
program is displayed
in the selected language.
Are there any documentations in that topic and example 
programs?

Thanks Halinux