[Zope] Zsql and dtml --- newbie

Tuttle, Gene cetuttle at rottlundhomes.com
Wed Sep 1 14:27:29 EDT 2004


I am have trouble understanding how this should work.
I have a form that has dynamic fields on it. 
the number and name are variable.
I would like to store these in a working table in a database.
The table has two fields and I have a ZSQL method to update the database
:
select add_key_working('<dtml-var
expr="_.SecurityGetUser().getUserName()">', <dtml-sqlvar key type="string">,
<dtml-sqlvar value type="string">);


I try this and it does not work
<dtml-if submit>
		<!-- Insert new values option values from the working table
-->
		<dtml-in "REQUEST.form.items()" sort>

			  <dtml-call
"SAS.queries.add_key_working(key=<dtml-var sequence-key),value=<dtml-var
sequence-item>>

	           </dtml-in>

</dtml-if>

it is not valid DTML
How do I get the values into the query.
Thanks
Gene Tuttle


More information about the Zope mailing list