Re: [Zope] SQL Query -> DTML Form with populated values -> SQL update example??
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 Record_Id: 2. "populate_form" -- generates populated form ... header ... Field1: do for all fields ... 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 "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 )
[Zope] SQL Query -> DTML Form with populated values -> SQL update example??
I'm fairly new to Zope. I have various view, search, and insert into a SQL database (MySQL) working. I'm having a problem connecting all the pieces for an update. 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. I checked the ZSQL pdf, and the giant HOWTO collection without finding a good example. Any help appreciated (including documentation references). Many thanks, -- Bill Broadley ___ 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 )