[Zope-DB] Creating Search Interfaces to MySQL Databases

[Charlie Clark]

Dear Paul,

thank you very much for your e-mail. I'm replying to the list as this _is_ 
the place to ask. I'm really not a DB, Zope or Python guru and have learned 
a lot from this list but it's very nice to be asked!

What exactly is the error you get when you try to add a search interface? Is 
your DB connection working properly?

You might want to look at zetadb and ZNolkSQL (or similar) which have 
appeared in the meantime.

Come back to the list if you still have problems.

Good luck!

Charlie Clark

On 2004-03-22 at 00:50:28 [+0100], you wrote:
> Hi Charlie,
> 
> I just read a post that you put on Zope-DB over a year ago, and I am
> having the exact same problems you originally mentioned.  I have a fully
> developed DB but cannot seem to get any of the Z Search Interfaces to work
> to query results.  Any tips?  Here's the post you originally placed.
> Thanks, Paul Resnikoff
> 
> ___
> 
> http://mail.zope.org/pipermail/zope-db/2003-January/001321.html
> 
> On 2003-01-14 at 17:58:35 [+0100], Deb B. wrote:
> > I am running Zope 2.5.x and have built several databases in MySQL. I have
> > successfully built interfaces to ADD, EDIT, LIST information in the MySQL
> > databases through the site, but can't seem to determine the best route
> > (or any route) for building database SEARCH interfaces for my users. I
> > don't always want to build custom reports for them--I want to give them
> > the flexibility to search on the MySQL databases via the browser too.
> > Does anyone know the right HTML/DTML, etc. code for a search box and
> > advanced search interface that would allow this? I also need to know how
> > to structure the results pages.
> >
> > Thanks! (BTW, I'm not a programmer...just a sole IT person for a small
> > company...so please respond accordingly--translation, "in detail and in
> > plain english"...lol.)
> 
> Hi Deb,
> 
> Zope comes with "Wizards" to help you do just want you want. Just add a "Z
> search interface" into a folder and follow the instructions and the bits
> you need will be created automatically. I suggest you choose pagetemplates
> rather than DTML.
> 
> You will have already needed to create a couple of ZSQL-methods to work
> with.
> 
> Hope that gets you started. Come back if you're stuck
> 
> Charlie
-- 
Charlie Clark
eGenix.com

Professional Python Services directly from the Source
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::