Hi Tim, You can just "call" the method: Here is a ZSQL method: insert into customers (cust_id, company_name, address1, address2, city, state, zip, phone, contact_name, contact_email) values ( NULL, <!--#sqlvar company_name type=string-->, <!--#sqlvar address1 type=string-->, <!--#sqlvar address2 type=string-->, <!--#sqlvar city type=string-->, <!--#sqlvar state type=string-->, <!--#sqlvar zip type=string-->, <!--#sqlvar phone type=string-->, <!--#sqlvar contact_name type=string-->, <!--#sqlvar contact_email type=string--> ) and here is the DTML to use it to add a customer.... <!--#var standard_html_header--> <!-- bare bones.. let's get the data in there... --> <!--#call "insertCustomer(company_name=company_name, address1 = company_address1, address2 = company_address2, city = company_city, state = company_state, zip = company_zip, phone = main_phone, contact_name = contact_name, contact_email = contact_email)"--> <center> <table width=80%> <tr><td><h2>Thanks! We have captured your information. We'll be contacting you at &dtml-contact_email;.</h2> </td></tr> </table> </center> <!--#var standard_html_footer--> -steve
"Tim" == Timothy Wilson <wilson@visi.com> writes:
Tim> Hi everyone, Tim> I've got Ross's PostgreSQL DA installed and working. Now I'm Tim> working on creating a form so I can insert records into the Tim> database through the Web. The ZSQL method tests out Tim> perfectly, I just need a form. The Z Search Interface wizard Tim> works great for generating forms to retrieve data, I just Tim> wish there was one to generate forms for putting data in. Tim> I thought I could cheat by looking at the HTML for the SQL Tim> test form. Here's what I get in the <form> portion Tim> (qry_insert_alum is my ZSQL method): Tim> <form Tim> action="http://www.mysite.foo/qry_insert_alum/manage_test" Tim> method="get"> Tim> I doubt that 'manage_test' is really the action that I Tim> want. What should be there? Tim> -Tim Tim> -- Timothy Wilson | "The faster you | Check out: Henry Sibley Tim> H.S. | go, the shorter | http://slashdot.org/ W. St. Paul, Tim> MN, USA | you are." | http://linux.com/ wilson@visi.com | Tim> -Einstein | http://www.mn-linux.org/ Tim> _______________________________________________ Zope maillist Tim> - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope Tim> ** No cross posts or HTML encoding! ** (Related lists - Tim> http://lists.zope.org/mailman/listinfo/zope-announce Tim> http://lists.zope.org/mailman/listinfo/zope-dev )