[Zope] Zsql and dtml --- newbie

[Jim Abramson]

you don't need dtml-var inside another dtml tag...

so for one thing you'd have to change:

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

to:

			  <dtml-call
"SAS.queries.add_key_working(key=key,value=_['sequence-item'])">


But there's another thing...you probably don't want everything in
REQUEST.form.items()....this is going to include, at the very least,
your submit button's name and value, which you probably don't want in
your db.

Better off checking explicitly for the input names you used in the html
form.


Jim


-----Original Message-----
From: Tuttle, Gene [mailto:cetuttle at rottlundhomes.com] 
Sent: Wednesday, September 01, 2004 2:27 PM
To: zope at zope.org
Subject: [Zope] Zsql and dtml --- newbie

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
_______________________________________________
Zope maillist  -  Zope at zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )