Forum OpenACS Q&A: Using ad_form variables elsewhere in the template

So I have a nifty ad_form that I am using to edit an object.

I would like to use the results of the query that populates the form elsewhere in the page but haven't been able to figure out how to do that.

specifically I would like something like the following:
.tcl
--------------------
ad_form -name contact_info -form {
  {contact_id:key}
  {first_names:text}
...
} -select_query {
  select first_names
    from contacts
  where contact_id = :contact_id
}
---------------------

.adp
---------------------
<h2>Edit Contact: @first_names@</h2>
<formtemplate id="contact_info"></formtemplate>

---------------------

Any suggestions?

Thanks,

Carl

Collapse
Posted by Tilmann Singer on
Using -on_request instead of -select_query and doing a db_1row inside it should do the trick.