[Zope] Server Uptime

Rob Page rob.page@digicool.com
Sat, 31 Jul 1999 13:14:18 -0400


> How do I design an input screen for a database?  I have 
> installed Zope and mysql database and am able to query the 
> data (just like the examples).
> Thanks in advance!!!
> Great product!!!

Here's a really basic (and untested) example...

ZSQLMethod:  sqlInsertACustomer

INSERT INTO customers 
(
  lastname,
  firstname, 
  phone, 
  email
)

VALUES 

(
  <!--#sqlvar lastname  type=string-->, 
  <!--#sqlvar firstname type=string-->, 
  <!--#sqlvar phone     type=string-->, 
  <!--#sqlvar email     type=string-->, 
)

DTMLDocument:  frmNewCustomer

<!--#var standard_html_header-->
<FORM METHOD="GET" ACTION="insertNewCustomer">
  <INPUT TYPE="lastname" NAME=""><BR>
  <INPUT TYPE="firstname" NAME=""><BR>
  <INPUT TYPE="phone" NAME=""><BR>
  <INPUT TYPE="email" NAME=""><BR>

  <INPUT TYPE="SUBMIT" VALUE=" Add Customer ">
</FORM>
<!--#var standard_html_footer-->

DTMLDocument:  insertNewCustomer

<!--#var standard_html_header-->
<!--#call sqlInsertACustomer-->
<p>Thanks for inserting a customer into the database...</p>
<!--#var standard_html_footer-->


--Rob