Hi all, I am a newbie and I have a question,
I have a countries table with 'country_code' and
'name' fields, the table has
211 records and
the database is postgres and
connection is made with product Z Psycopg (also I
have checked it with PoPy
and the result is the same one I explain later).
I have declared a ZSQLMethod(getCountriesZSQL) with
a simple query:
SELECT country_code,name FROM countries. At Advanced Tab's
ZSQLMethod I have
managed the following parameters to cache the
query:
Maximum rows to retrieve: 300
Maximum results
to breaks: 300
Maximum Time (sec) to breaks: 5000
I have created a DMTL Method to show a combo-select
of countries:
<SELECT name="comboCountries">
<dtml-in
getCountriesZSQL>
<OPTION VALUE='<dtml-var country_code
null="">'>
<dtml-var name
null="">
</dtml-in>
</SELECT>
This is my question:
When I delete a record of
countries table, the table changes and
I think that the combo-select
shouldn´t change because is cached;
but, in fact, the combo-select changes
soon, over he fifth or sixth page
refresh. The result changes showing 210
and 211 records randomly...
What is the reason of this behavior?
Does anyone
know what is the solution?
Regards,
ZRaul.
Z8-)