[Zope] ZSQL question

Kerekes Lajos lkerekes@xperts.hu
Tue, 24 Jul 2001 16:36:05 +0200


Hello!

I have a problem.
I have a form, which contains 10 chekboxes.
All checkboxes names are IDS. And the values
are different.

I made a ZSQL method:
"update Table set STATE = 2 where UID = <dtml-sqlvar id type=string>"

If I test it with the Test tab of Zope ZSQLmethod , it works. If I call
it from a dtml method, like <dtml-call
expr="updateZSQL(id='dasdasds-gsd-gwwe-bgvsdg')">,
it works fine.
But I cant use the values from the form.

I try this:
<dtml-in IDS>
<br><dtml-var sequence-item>
<dtml-call expr="updateZSQL(id='<dtml-var sequence-item>')">
</dtml-in>

It only writes the values of checkboxes to the HTML page, but doesn't
make the
update in the database.

What is wrong in it?

          Bye:

        Lajos