[Zope] SQL Method running twice

[Justin Dunsworth]

I forgot to add version:

Zope 2.11.4-final, python 2.4.4, win32 and using ZMySQLDA 2.0.9

On Tue, Dec 15, 2009 at 11:34 AM, Justin Dunsworth <
justin.dunsworth at gmail.com> wrote:

> This seems to be happening on more than just one query now... is there any
> suggestion on where to look?
>
>
> On Thu, Dec 10, 2009 at 1:14 PM, Justin Dunsworth <
> justin.dunsworth at gmail.com> wrote:
>
>> Thanks for the reply... Are you suggesting that there may be an issue with
>> MySQL receiving the data from zope and the way it handles it?
>>
>> Strange thing is that I'm using the exact same method I have used
>> thousands of times over and same code layout and this is the first time I'm
>> seeing it. I've changed around a few things relating to variable names etc
>> thinking it was the case but dumbing it down to the simplest way I can still
>> is giving the error.
>>
>>  On Thu, Dec 10, 2009 at 1:03 PM, Andreas Jung <lists at zopyx.com> wrote:
>>
>>> In case of a ZODB conflict error the whole request will be repeat up to
>>> three times.
>>> If you database does not provide proper transaction support (trible
>>> check your MySQL
>>> installation and your table type useage), you're doomed. A proper RDBMS
>>> like Oracle
>>> or Postgres will behave properly and abort the transaction in case of a
>>> ZODB transaction
>>> abort.
>>>
>>> -aj
>>>
>>> Am 10.12.09 19:59, schrieb Justin Dunsworth:
>>>  > I am running into a brand new issue today that I can't, for the life
>>> > of me, figure out. I wrote a standard page to insert data into a MySQL
>>> > table using Z SQL methods from a form like I always have but for some
>>> > strange reason it's running the same query twice, thus adding a
>>> > duplicate entry.
>>> >
>>> > I have confined the original code in it's own document, checked,
>>> > double checked, and still no avail. Here's the code for the page:
>>> >
>>> > <dtml-var frame_header>
>>> > <dtml-if addnewstatus>
>>> >   <dtml-try>
>>> >     <dtml-call "RootSQLMethods.admin.Status_Add(_.None,_)">
>>> >     <dtml-call "RESPONSE.redirect(BASE2+'/statuses')">
>>> >   <dtml-except>
>>> >     <p>Error while submitting! Status not added.</p>
>>> >     <br>Error type: <dtml-var error_type>
>>> >     <br>Error value: <dtml-var error_value>
>>> >   </dtml-try>
>>> > </dtml-if>
>>> > <form action="&dtml-URL;" method="post">
>>> >   <table class="tborder" align="center" width="30%" cellspacing="0" >
>>> >     <tr><td class="tcat" align="center" colspan="2" style="font-size:
>>> > 12pt;">Add New Status</td></tr>
>>> >     <tr><td width="35%" align="right"><b>Name:</b></td><td
>>> > width="65%"><input type="text" name="name_add" size=15></td></tr>
>>> >     <tr><td width="35%" align="right"
>>> > valign="top"><b>Description:</b></td><td width="65%"><textarea
>>> > name="description_add" cols=25 rows=4></textarea></td></tr>
>>> >     <tr><td width="35%" align="right"><b>Sort:</b></td><td
>>> > width="65%"><input type="text" name="sort_add" value="5"
>>> size=1></td></tr>
>>> >     <tr><td align="center" colspan="2"><hr></td></tr>
>>> >     <tr>
>>> >       <td><input type="hidden" name="addnewstatus" value="1"></td>
>>> >       <td>
>>> >         <button class="button" onclick="this.form.submit()">Add
>>> > Status</button>&nbsp;&nbsp;
>>> >         <button class="button" onclick="window.location = '<dtml-var
>>> > BASE2>/statuses'; return false;">Cancel</button>
>>> >       </td>
>>> >     </tr>
>>> >   </table>
>>> > </form>
>>> > <dtml-var frame_footer>
>>> >
>>> > I can run the SQL Method by itself and it works just fine (only
>>> > inserting it once) but when run as a separate page it adds the two.
>>> >
>>> > Any assistance is appreciated
>>> >
>>> >
>>> > _______________________________________________
>>> > Zope maillist  -  Zope at zope.org
>>> > https://mail.zope.org/mailman/listinfo/zope
>>> > **   No cross posts or HTML encoding!  **
>>> > (Related lists -
>>> >  https://mail.zope.org/mailman/listinfo/zope-announce
>>> >  https://mail.zope.org/mailman/listinfo/zope-dev )
>>> >
>>>
>>>
>>> --
>>> ZOPYX Ltd. & Co KG          \  zopyx group
>>> Charlottenstr. 37/1          \  The full-service network for your
>>> D-72070 Tübingen              \  Python, Zope and Plone projects
>>> www.zopyx.com, info at zopyx.com  \  www.zopyxgroup.com
>>> ------------------------------------------------------------------------
>>> E-Publishing, Python, Zope & Plone development, Consulting
>>>
>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope/attachments/20091215/c0f10516/attachment.html