iterate over ZSQL method and make hidden form values...?
I have a form that collects about 15 values, and a ZSQL method that collects about 15 values on the same page. I want to amalgamate them together and push them through to the next page where I could then use them all easily in another ZSQL method by just passing REQUEST. (note, I am using ZODBCDA so zsql_result.dictionaires() is unavailable to me!). Something like this(but that actually works ;-)): <form> <dtml-in zsql_method> <dtml-in sequence-item> <input type="hidden" name="<dtml-var sequence-item-name>" value="<dtml-var sequence-item-value"> > </dtml-in> </dtml-in> <many other inputs here................> <input type="submit" name="submit" value="go"> </form> Thanks, -- -- Erik Myllymaki erik@pacific-shores.com
[Erik Myllymaki]
I have a form that collects about 15 values, and a ZSQL method that collects about 15 values on the same page. I want to amalgamate them together and push them through to the next page where I could then use them all easily in another ZSQL method by just passing REQUEST.
(note, I am using ZODBCDA so zsql_result.dictionaires() is unavailable to me!).
Something like this(but that actually works ;-)):
<form> <dtml-in zsql_method> <dtml-in sequence-item> <input type="hidden" name="<dtml-var sequence-item-name>" value="<dtml-var sequence-item-value"> > </dtml-in> </dtml-in>
<many other inputs here................> <input type="submit" name="submit" value="go"> </form>
This is unclear to me. If the form has already collected the values, why to you need to collect them a second time? And if this zsql_method is acting correctly, why are you trying to put its returned data into hidden fields in another form? You can access the results from the zsql_method in another method the same as you can access them in a dtml page, so just pass the results to the new method: <dtml-let results=zsql_method> <dtml-var "second_zsql_method(param=results)"> </dtml-let> Of course, you have to declare "param" when you define the 2nd zsql method. Cheers, Tom P
Erik Myllymaki writes:
I have a form that collects about 15 values, and a ZSQL method that collects about 15 values on the same page. I want to amalgamate them together and push them through to the next page where I could then use them all easily in another ZSQL method by just passing REQUEST.
(note, I am using ZODBCDA so zsql_result.dictionaires() is unavailable to me!).
Something like this(but that actually works ;-)):
<form> <dtml-in zsql_method> <dtml-in sequence-item> What should that do?
"sequence-item" is here a "Record" object not a sequence.
<input type="hidden" name="<dtml-var sequence-item-name>"
What's "sequence-item-name" (and "sequence-item-value"). Seems, you want some background reading on "dtml-in" variables. I can suggest the "DTML" section of <http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html> Said, that I do not understand what you want to do with your inner "dtml-in", I can help you to work around the missing "dictionaries": <dtml-let results=zsql_method columns="results.names()" > <!-- results now contains the result sequence, columns the column names --> <dtml-in results> <dtml-in columns prefix=col_> <dtml-var col_item> <!-- this is the column name--> <dtml-var expr="_[col_item]"> <!-- this is your column value. provided there is no name clash --> </dtml-in> </dtml-in> </dtml-let> Dieter
Dieter Maurer wrote:
Erik Myllymaki writes:
I have a form that collects about 15 values, and a ZSQL method that collects about 15 values on the same page. I want to amalgamate them together and push them through to the next page where I could then use them all easily in another ZSQL method by just passing REQUEST.
(note, I am using ZODBCDA so zsql_result.dictionaires() is unavailable to me!).
Something like this(but that actually works ;-)):
<form> <dtml-in zsql_method> <dtml-in sequence-item> What should that do?
"sequence-item" is here a "Record" object not a sequence.
<input type="hidden" name="<dtml-var sequence-item-name>"
What's "sequence-item-name" (and "sequence-item-value"). Seems, you want some background reading on "dtml-in" variables. I can suggest the "DTML" section of
<http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html>
Yes, I realize these are not legit variables, I was just trying to show an example of what I need without knowing ALL the methods or variable names avaiable to me.
Said, that I do not understand what you want to do with your inner "dtml-in", I can help you to work around the missing "dictionaries":
<dtml-let results=zsql_method columns="results.names()" > <!-- results now contains the result sequence, columns the column names --> <dtml-in results> <dtml-in columns prefix=col_> <dtml-var col_item> <!-- this is the column name--> <dtml-var expr="_[col_item]"> <!-- this is your column value. provided there is no name clash --> </dtml-in> </dtml-in> </dtml-let>
Thanks, this is what I was after. I ended up using an external method to provide the dictionaries() function, but being able to do it right in DTML is handy. -- -- Erik Myllymaki erik@pacific-shores.com
participants (3)
-
Dieter Maurer -
Erik Myllymaki -
Thomas B. Passin