[Zope] ZSQL questions

McDonnell, Larry lmcdonnell@protonenergy.com
Mon, 13 May 2002 15:06:02 -0400


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