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
participants (1)
-
Tuttle, Gene