[Zope] MySQL and form processing

[robert rottermann]

I have a sample on our "web page to be" (meaning the site is still under 
construction)
http://salome.redcor.net/wikis/CodeSnippets/view

There is also a linke to a "real world example" I copied from a running 
project.

Robert


Les Ferguson wrote:
> I have read thru the zope book and various how-to's and examples, but 
> really need a solid peice of sample code to kick me off here;  what is 
> the best way to handle ZPT based forms, for updating and searching in a 
> MySQL database etc.
> 
> For example, I want a customer search form, taking one or more search 
> criteria, then when submitted I want to build an SQL query to find all 
> rows with ANY of the requested fields, using a LIKE match.  I seem to 
> need to intercept the values posted from the form and wrap '%' around 
> the search values, so the LIKE compare will do substring searches.
> 
> Has anybody found good examples using ZPT ?  Most of the documentation I 
> have found have a combination of DTML examples and statements about why 
> we should use ZPT instead.
>