<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>duplicate or 'echoing' REQUEST?</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Jim,</FONT></DIV>
<DIV><FONT face=Arial size=2>Your post poses a rather interesting
question. One that eliminates the logical conclusion: that multiple
calls to, say, a zSQL method are attempting to add duplicate primary
keys.</FONT></DIV>
<DIV><FONT face=Arial size=2>I have, therfore no idea other than to challenge
your assertion that this has been eliminated as the culprit.</FONT></DIV>
<DIV><FONT face=Arial size=2>You might consider adding a Javascript function
that does something like:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> function Process() {</FONT></DIV>
<DIV><FONT face=Arial size=2> if
document.forms[0].Clicked <> 1 {<BR>
document.forms[0].Clicked =
1 <BR>
document.forms[0].submit();<BR> }</FONT></DIV>
<DIV><FONT face=Arial size=2> }</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I've run into this, that was the
solution.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Best luck,</FONT></DIV>
<DIV><FONT face=Arial size=2>David</DIV>
<DIV><BR></DIV></FONT>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=jabramson@wgen.net href="mailto:jabramson@wgen.net">Jim Abramson</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=zope@zope.org
href="mailto:zope@zope.org">zope@zope.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, August 31, 2004 1:35
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Zope] duplicate or 'echoing'
REQUEST?</DIV>
<DIV><BR></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>Hi there,</FONT> </P>
<P><FONT face=Arial size=2>Running 2.6.0 we have a curious intermittent
syndrome involving what we _suspect_ to be multiple identical incoming POST
requests.</FONT></P>
<P><FONT face=Arial size=2>To be honest, this could be any number of things
happening…however the most obvious one (user clicking submit twice on the same
form) has been eliminated, after quite a bit of testing on various browsers
(clicking submit as many times as possible before the current html page/form
"leaves" does not reproduce the issue).</FONT></P>
<P><FONT face=Arial size=2>The problem ends up manifesting with unique-key
violations from the external rdbms, where it's trying to update or insert some
row twice in succession. Or, more annoyingly, quiet double-insertion of
some submitted data.</FONT></P>
<P><FONT face=Arial size=2>Before we turn zope upside down and shake the hell
out of it, has anyone out there experienced a similar situation, or know of a
programming or configuration error that might lead one to expect this
behavior?</FONT></P>
<P><FONT face=Arial size=2>Thanks for any advice,</FONT> </P>
<P><FONT face=Arial size=2>Jim</FONT> </P><BR>
<P>
<HR>
<P></P>_______________________________________________<BR>Zope maillist
-
Zope@zope.org<BR>http://mail.zope.org/mailman/listinfo/zope<BR>**
No cross posts or HTML encoding! **<BR>(Related lists -
<BR> http://mail.zope.org/mailman/listinfo/zope-announce<BR> http://mail.zope.org/mailman/listinfo/zope-dev
)<BR></BLOCKQUOTE></BODY></HTML>