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>
</form>
....
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">
</form>
... footer ...
</dtml-with>
<dtml-else>
... error handling (no record for record_id) ...
</dtml-if>
</dtml-let>
3. An SQL method with "record_id" and your fields as arguments
and an SQL "update" as (query) template (as you did for
"insert").
Dieter
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )