Hi, This was the only way I was able to get this to work. <form action="http://proton-80556:8080/intranet/input_test/manage_test" method="get"> input_test is the zsql. I tried this method <form name="form1" method="post" action="input_test"> but this is where the next thing I see is this zsql method in test mode. Any sugesstions, thanks ahead of time. -----Original Message----- From: Jon Erickson [mailto:jon.erickson@neicoltech.org] Sent: Monday, May 13, 2002 1:23 PM To: McDonnell, Larry Subject: Re: [Zope] ZSQL questions On Mon, 2002-05-13 at 10:50, McDonnell, Larry wrote:
Hi,
First I want to thank the people who helped me get this populating form thing working (Colin Fox, Tom Passin, and Jon Erickson). I have a couple
No problem!
questions on how ZSQL methods and their behavior. From a form I created, I input the data and hit the submit button. Under superuser the data is added to the db but if I am not superuser, the ZSQL method the you would see in test mode appears where you would need to file in the data again. Why does it work under superuser and no where else? Is it a permission thing?
Also on the same subject, how do I suppress the message telling me "no data matched" while it is adding a new record to the db? Thanks.
How are you calling the zsql method that inserts the data? It sounds like you may be trying to pass the form variables directly to the zsql method (which isn't the best way to do it). Does your forms' "action" variable reference a ZSQL method? Jon
On Mon, 2002-05-13 at 14:06, McDonnell, Larry wrote:
Hi,
This was the only way I was able to get this to work.
<form action="http://proton-80556:8080/intranet/input_test/manage_test" method="get"> input_test is the zsql.
I tried this method <form name="form1" method="post" action="input_test"> but this is where the next thing I see is this zsql method in test mode. Any sugesstions, thanks ahead of time.
Try this: <form action="form_handler" method="POST"> A very simple form_handler would be a dtml method like so: ---------------------------------------------- <dtml-var standard_html_header> <dtml-call expr="zsql_method_name(REQUEST)"> <dtml-var standard_html_footer> ---------------------------------------------- When the form is posted (user clicks on submit) the form variables are stored in the REQUEST object, which you can pass to a zsql method. You will need to make sure that the form variable names match that of your zsql method arguments. Jon
[McDonnell, Larry]
This was the only way I was able to get this to work.
<form action="http://proton-80556:8080/intranet/input_test/manage_test" method="get"> input_test is the zsql.
I tried this method <form name="form1" method="post" action="input_test"> but this is where the next thing I see is this zsql method in test mode.
Any
sugesstions, thanks ahead of time.
If you use Netscape 4.x on Windows, there is a problem with POST (at least up to Zope 2.3.3, I don't know about the more recent versions). I've never been able to track down the reason or a work-around (there are a few threads in the list archives about this). It's not exactly the same as what you are describing, but it's worth trying another browser. Also, does it work when you use a GET instead of a POST? You certainly do not want to call manage_test in a production page! Cheers, Tom P
participants (3)
-
Jon Erickson -
McDonnell, Larry -
Thomas B. Passin