<HTML>
<HEAD> <META http-equiv=Content-Type content="text/html; charset=utf-8">
<STYLE title="table borders">.htmtableborders, .htmtableborders td,
.htmtableborders th {border : 1px dashed lightgrey ! important;} </STYLE>
<STYLE type=text/css>html, body { border: 0px; } span.macro, span.macro ul,
span.macro div, span.macro p {background : #CCCCCC;} </STYLE> <STYLE
type=text/css> p{margin-bottom: 0.15em;margin-top:
0.15em;}body{font-family:tahoma;font-size:10pt;}; </STYLE> </HEAD> <BODY>
<FONT style="FONT-SIZE: 10pt; FONT-FAMILY: tahoma"> <DIV> Hello
Thomas,</DIV> <DIV>Thanks for your response.</DIV> <DIV> </DIV> <DIV>
Onthis moment my databse writing is based on DTML.</DIV> <DIV>
</DIV> <DIV>The problem is that when I test this Z MySQL
Method it's working.</DIV> <DIV> </DIV> <DIV>Arguments:</DIV> <DIV>
ID:int=1<BR>voornaam:string=""<BR>achternaam:string=""</DIV> <DIV>
</DIV> <DIV>Query:</DIV> <DIV>INSERT INTO users SET<BR>ID =
1234567894,<BR>voornaam = 'Martin',<BR>achternaam = 'Koekenberg'<BR></FONT>
<BR>Everything is writen in the database.</DIV> <DIV> </DIV> <DIV>Now
the following....</DIV> <DIV>I submit a form (build with formulator).</DIV>
<DIV>The action point to a dtml Method witch calls the above Z MySQL Method
(dtml-call write_user).</DIV> <DIV> </DIV> <DIV>Nothing is
happening........</DIV> <DIV> </DIV> <DIV>I'm doing something wrong,
but what......</DIV> <DIV> </DIV> <DIV>The next step is to remove the
valuea and replace them with a <dtml-sqlvar ..........</DIV> <DIV>and
replace the <dtml-call write_user with <dtml-call
write_user(field_id,field_voornaam,field_acyternaam</DIV> <DIV> </DIV>
<DIV>Can you help me withe the next step.... I't the first time that I use
MySQL/Zope and Z MySQL Method.</DIV> <DIV> </DIV> <DIV>Regards,</DIV>
<DIV> </DIV> <DIV>Martin Koekenberg</DIV> <BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT:
#000000 2px solid; MARGIN-RIGHT: 0px">-----Original Message-----<BR>From:
Thomas Bennett <bennetttm@appstate.edu><BR>To: zope@zope.org<BR>Date:
Fri, 26 May 2006 09:16:24 -0400<BR>Subject: Re: [Zope] Z SQL Method
question<BR><BR> <DIV style="FONT-FAMILY: monospace, courier new, courier">
With a lack of information here I'll answer based fully on assumption based
on <BR>dtml. <BR><BR> In your form the action should go to a dtml
method.<BR><BR><form action="optional_path_to/some_method" ...><BR><BR>
The dtml method should have a call to your Z SQL Method<BR><BR><dtml-call
my_sql_method><BR><BR>And then you can add anything in the dtml method
which will be viewed as the <BR>response page to the user that submitted the
form. You can also do some <BR>validation here if needed, with
conditional statements. I usually add a <BR>redirect under the
dtml-call to go to a different response page to the user <BR>because if the
user reloads the page with the dtml-call it will send the data <BR>to the
database again unless there is a conflict like unique fields etc..<BR><BR>
or<BR><BR>Are you using ZPT?<BR><BR>Thomas<BR><BR>On Friday 26 May 2006
08:54, Martin Koekenberg wrote:<BR>> Hello,<BR>><BR>> Who has
experience with Z SQL Method.<BR>> I Created a from to enten some data
into MySQL server. I used Z SQL Method<BR>> to write the dat into the
databse. Everytime I submit the form I get a<BR>> screen with the field
in my Z SQL Method component.<BR>><BR>> How can I write the dat from a
form into my database at once by using Z SQL<BR>> Method ?<BR>> I
tested the database connetion, that is working.<BR>><BR>> Regards,<BR>
><BR>> Martin Koekenberg<BR><BR>-- <BR>
====================================================================<BR>
Thomas McMillan Grant Bennett Appalachian State
University<BR>Computer Consultant III
P O Box 32026<BR>University Library
Boone, North Carolina 28608<BR>(828) 262 6587<BR><BR>An
important measure of effort in coding is the frequency with which you write
<BR>something that doesn't actually match your mental representation of the
<BR>problem, and have to backtrack on realizing that what you just typed
won't <BR>actually tell the language to do what you're thinking. -Eric
Raymond<BR><BR>Library Systems Help Desk: <A target=_blank
href="http://linux.library.appstate.edu/help">
http://linux.library.appstate.edu/help</A><BR>
====================================================================<BR>
_______________________________________________<BR>Zope maillist -
Zope@zope.org<BR><A target=_blank
href="http://mail.zope.org/mailman/listinfo/zope">
http://mail.zope.org/mailman/listinfo/zope</A><BR>** No cross posts
or HTML encoding! **<BR>(Related lists - <BR> <A target=_blank
href="http://mail.zope.org/mailman/listinfo/zope-announce">
http://mail.zope.org/mailman/listinfo/zope-announce</A><BR> <A
target=_blank href="http://mail.zope.org/mailman/listinfo/zope-dev">
http://mail.zope.org/mailman/listinfo/zope-dev</A> )<BR></DIV></BLOCKQUOTE>
</BODY>
</HTML>