Bill Broadley writes:
 > Does someone have an example (with DTML or similiar source) that
 > demonstrates the following:
 > 1.  A search field for record id, or a list with a clickable URL for each
 >     record (that is the result from a SQL select)
 > 2.  Allows updating of the record with a DTML form with values already
 >     populated
 > 3.  An SQL update based on the values from #2.
Where is your problem?

1. HTML form for record selection
<form action=populate_form>
Record_Id: <input name=record_id><br>
<input type=submit>

2. "populate_form" -- generates populated form
<dtml-let records=locate_by_record_id> <!-- "locate_by_record_id" is a 
                                            Z SQL Method with
                                            arguement "record_id"
                                            returning the corresponding
                                            object -->
  <dtml-if "_.len(records)"> <!-- is there one? -->
    <dtml-with "records[0]"> <!-- take the first -->
      ... header ...
      <form action=update method=post>
        Field1: <input name=Field1 value="&dtml-Field1;"><br>
        .... do for all fields ....
        <input type=hidden name=record_id value="&dtml-record_id;">
        <input type=submit value="update">
      ... footer ...
    ... error handling (no record for record_id) ...

3. An SQL method with "record_id" and your fields as arguments
   and an SQL "update" as (query) template (as you did for


Zope maillist  -  [EMAIL PROTECTED]
**   No cross posts or HTML encoding!  **
(Related lists - )

Reply via email to