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