You are not logged in Log in Join
You are here: Home » Members » Ioan's Zope Documents » SQL Forms

Log in
Name

Password

 
 

Folder icon SQL Forms

SQL Forms

This is a Zope wizard!
This is a front end for managing SQL tables.
From Zope interface you design your SQL table,
then create the table and that's all.
The result is that you can add/list/edit your data
by web in one minute, right after you design field list.

Honeyd CC - Honeyd Control Center is a zope application
based on one SQL Forms object
and some SQL Forms Reporter objects.


I saw that sql forms + reporter are good for
admin purposes only (you can quick create, fill and
list tables and also you can quick learn dtml
programming looking into generated methods).

But to do a nice application you must build your own.
My generated sql forms are available quick but also are ugly (standard html forms).

Download and install the demo file!

Features

  • Automatically generate list,add,edit methods
  • You have special fields (non SQL fields) with incremental values,
    useful for primary key and made in a portable SQL format
  • Select security check script for each list,add,edit method
  • edit fields, create/drop table
  • Change fields display order
  • use standard HTML form fields and some new fields (select, list and date) to fill the forms
  • list and select fields are build from other SQL tables (by a query)

Common mistakes

  • Avoid to use reserved SQL fieldnames such as id,name,date,type,int,file,text,user,all
  • Check sql field size (avoid to be too small) or data will be truncated
  • Update options but don't edit directly the list,add,edit methods
  • Update options when you get an error
  • Avoid to use invalid names or chars into names (like " or ')

     Title   Type   Size   Modified   Status 
     3.1 Edit object Software Release   2003-06-10 published
     3.2 Edit object Software Release   2003-06-10 published
     3.3 Edit object Software Release   2003-06-10 published
     3.4 Edit object Software Release   2003-06-10 published
     3.5 Edit object Software Release   2003-06-10 published
     demo Edit object Software Release   2003-10-17 published