[Zope-DB] Question about creating a form

[Laura McCord]

I have a zsql method that uses two parameters to update a table.
Then, I have a zope page template that contains a form. Within the
<form> tags I display the results. 

For example,
<div tal:repeat="result batch"><td width=75>
<span tal:replace="result/UserName">UserName goes here</span></td>

Plus, I have a <select><option> menu. So the parameters needed for my
zsql method include the value from the <select> and a result derived
from the batch results (result/username). My question is in the <form
action=...> do I use the zsql method as the action or is the action
going to be a dtml method that calls the zsql method?

Preferably, I do not want to be redirected to another page. After I make
a selection from the drop down menu I want the zsql to update my
database and reload the page with the correct updates. The only
interaction between the user and the form is choosing a selection from
the <select> menu.


Thanks.