[Zope] Z SQL Method question

[Thomas Bennett]

With a lack of information here I'll answer based fully on assumption based on 
dtml. 

 In your form the action should go to a dtml method.

<form action="optional_path_to/some_method" ...>

The dtml method should have a call to your Z SQL Method

<dtml-call my_sql_method>

And then you can add anything in the dtml method which will be viewed as the 
response page to the user that submitted the form.  You can also do some 
validation here if needed, with conditional statements.   I usually add a 
redirect under the dtml-call to go to a different response page to the user 
because if the user reloads the page with the dtml-call it will send the data 
to the database again unless there is a conflict like unique fields etc..

or

Are you using ZPT?

Thomas

On Friday 26 May 2006 08:54, Martin Koekenberg wrote:
> Hello,
>
> Who has experience with Z SQL Method.
> I Created a from to enten some data into MySQL server. I used Z SQL Method
> to write the dat into the databse. Everytime I submit the form I get a
> screen with the field in my Z SQL Method component.
>
> How can I write the dat from a form into my database at once by using Z SQL
> Method ?
> I tested the database connetion, that is working.
>
> Regards,
>
> Martin Koekenberg

-- 
====================================================================
Thomas McMillan Grant Bennett		Appalachian State University
Computer Consultant III			P O Box 32026
University Library				Boone, North Carolina 28608
(828) 262 6587

An important measure of effort in coding is the frequency with which you write 
something that doesn't actually match your mental representation of the 
problem, and have to backtrack on realizing that what you just typed won't 
actually tell the language to do what you're thinking. -Eric Raymond

Library Systems Help Desk: http://linux.library.appstate.edu/help
====================================================================