Steve, would there still be a need for a html form, presented to the user, to be previously filled out, before the "call" method will work? I have just tried to make it a simple as possible, but if I have a step too much, please have a look and tell me: http://groucho.med.yale.edu:8080/lamdi/database/gadfly_demo/manage Maybe somebody will tell me why in the above example it is possible for anonymous to insert data , but when anonymous queries the database, a password is needed? I thought that both are "Database Methods" and would be covered under the security settings with the same item "Use Database Methods"? Stefan Harms
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 )
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- Stefan Harms LAMDI - Linux Anesthesia Modular Devices Interface http://gasnet.med.yale.edu/lamdi/