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

Log in
Name

Password

 
 


Dublin Core Elements

The Dublin Core metadata element set is a standard for cross-domain information resource description.
Element Description Value
Identifier resource ID http://old.zope.org/Members/Ioan/SQLForms
Title resource name SQL Forms
Description resource summary <h1>SQL Forms</h1> This is a Zope wizard!<br> This is a front end for managing SQL tables.<br> From Zope interface you design your SQL table,<br> then create the table and that's all.<br> The result is that you can add/list/edit your data<br> by web in one minute, right after you design field list.<br> <br> <font color="green"> Honeyd CC - <a href="http://www.zope.org/Members/Ioan/HoneydCenter/">Honeyd Control Center</a> is a zope application<br> based on one <a href="http://www.zope.org/Members/Ioan/SQLForms/">SQL Forms</a> object<br> and some <a href="http://www.zope.org/Members/Ioan/SQLFormsReporter/">SQL Forms Reporter</a> objects.<br> </font> <br><hr> <font color="red"> I saw that sql forms + reporter are good for<br> admin purposes only (you can quick create, fill and<br> list tables and also you can quick learn dtml<br> programming looking into generated methods).<br> </font> <br> But to do a nice application you must build your own.<br> My generated sql forms are available quick but also are ugly (standard html forms).<br> <hr> Download and install the demo file! <br> <br> <h2>Features</h2> <ul> <li>Automatically generate <u>list,add,edit</u> methods <li>You have special fields (non SQL fields) with incremental values,<br> useful for primary key and made in a portable SQL format <li>Select security check script for each <u>list,add,edit</u> method <li>edit fields, create/drop table <li>Change fields display order <li>use standard HTML form fields and some new fields (select, list and date) to fill the forms <li>list and select fields are build from other SQL tables (by a query) </ul> <h2>Common mistakes</h2> <ul> <li>Avoid to use reserved SQL fieldnames such as 'id','name','date','type','int','file','text','user','all' <li>Check sql field size (avoid to be too small) or data will be truncated <li>Update options but don't edit directly the <u>list,add,edit</u> methods <li>Update options when you get an error <li>Avoid to use invalid names or chars into names (like " or ')
Creator resource creator Ioan
Date default date 2003-10-17 13:20:54
Format resource format text/html
Type resource type Software Package
Subject resource keywords Developer, Examples, External Access, Helpers, Visual
Contributors resource collaborators
Language resource language
Publisher resource publisher No publisher
Rights resource copyright


Additional Zope Elements

Element Description Value
CreationDate date resource created 2003-06-10 08:23:34
ModificationDate date resource last modified 2003-10-17 13:20:54
EffectiveDate date resource becomes effective None
ExpirationDate date resource expires None

Backlinks: via Google / Technorati