Обсуждение: Re: double entries into database when using IE
Hi,
If a web page has JavaScript called on a submit button, like
'onClick="someFunction();", and the function does some stuff, then does a
form.submit(), and DOES NOT REMEMBER TO RETURN FALSE, then the browser is
supposed to go ahead and submit the form. So, something like that could
possibly happen, but only if the JavaScript is incorrectly written, as far
as I know. Although, once a submit is done, it would be a gray area as to
whether the form data would still be available for the second submit.
I use JavaScript in forms all the time to interact with a PostgreSQL
database, and don't have any issues like this with debugged code, using
IE6.
Susan
David Gagnon
<dgagnon@siunik.com> To: D A GERM <dgerm@shepherd.edu>
Sent by: cc: Postgresql-General <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] double entries into database when using IE
pgsql-general-owner@pos |-------------------|
tgresql.org | [ ] Expand Groups |
|-------------------|
07/05/2005 02:24
PM
Hi,
I have seen IE posting request twice to the server when you post using a
button that use javascript. Per example, if you have a submit button
and call a javascript that actually post the form... IE will still do
the post attached to the submit button. So you will have 2 submits....
It's stupid but it's true.
It's happen on some version of IE6 I think .. not all for what I remember.
You can search the web for the solution ... I don't remember what I did
or if I actually did something to solve the problem.
/David
P.S.: This is quite OT for the postgresql mailing list .. you don't think ?
D A GERM wrote:
> I am having a problem when a browser dumps data into a table.
> When the browser is Firefox , it works perfect; when the browser is
> IE, it dumps 2 entries into the table just thousandths of a second apart.
>
> What could be causing this? Is this an issue with IE, Apache or Postgres.
>
> Thanks in advance for any help.
>
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
----------------------------------------------------------------------------------------------
See our award-winning line of tape and disk-based
backup & recovery solutions at http://www.overlandstorage.com
----------------------------------------------------------------------------------------------
SCassidy@overlandstorage.com wrote:
Hi, If a web page has JavaScript called on a submit button, like 'onClick="someFunction();", and the function does some stuff, then does a form.submit(), and DOES NOT REMEMBER TO RETURN FALSE, then the browser is supposed to go ahead and submit the form. So, something like that could possibly happen, but only if the JavaScript is incorrectly written, as far as I know. Although, once a submit is done, it would be a gray area as to whether the form data would still be available for the second submit.
I think this thread discuss the problem .. like they say I started having the problem with some version of IE6 but not IE5.
http://forums.devshed.com/showthread.php?t=50160&page=1&pp=15
http://www.tfug.org/pipermail/tfug/2004-October/007785.html
They don't give the answer but when they talk
here is what it might be:
<input class="input" type="submit " name="Submit" value="Submit" onClick="javascript:submitit();">
if you use javascript to submit the form
do not use a button type of submit.........it will submit twice
correct code
<input class="input" type="button " name="Submit" value="Submit" onClick="javascript:submitit();">
<input class="input" type="submit " name="Submit" value="Submit" onClick="javascript:submitit();">
if you use javascript to submit the form
do not use a button type of submit.........it will submit twice
correct code
<input class="input" type="button " name="Submit" value="Submit" onClick="javascript:submitit();">
Like SCassidy said .. maybe returing FALSE will solve the problem .. but I remember having tried this without success...
It's all what I know :-)
I use JavaScript in forms all the time to interact with a PostgreSQL database, and don't have any issues like this with debugged code, using IE6. Susan David Gagnon <dgagnon@siunik.com> To: D A GERM <dgerm@shepherd.edu> Sent by: cc: Postgresql-General <pgsql-general@postgresql.org> Subject: Re: [GENERAL] double entries into database when using IE pgsql-general-owner@pos |-------------------| tgresql.org | [ ] Expand Groups | |-------------------| 07/05/2005 02:24 PM Hi, I have seen IE posting request twice to the server when you post using a button that use javascript. Per example, if you have a submit button and call a javascript that actually post the form... IE will still do the post attached to the submit button. So you will have 2 submits.... It's stupid but it's true. It's happen on some version of IE6 I think .. not all for what I remember. You can search the web for the solution ... I don't remember what I did or if I actually did something to solve the problem. /David P.S.: This is quite OT for the postgresql mailing list .. you don't think ? D A GERM wrote:I am having a problem when a browser dumps data into a table. When the browser is Firefox , it works perfect; when the browser is IE, it dumps 2 entries into the table just thousandths of a second apart. What could be causing this? Is this an issue with IE, Apache or Postgres. Thanks in advance for any help.---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster ---------------------------------------------------------------------------------------------- See our award-winning line of tape and disk-based backup & recovery solutions at http://www.overlandstorage.com ---------------------------------------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Thank you all. I changed the type to button and added the onClick="return(myFunction())". I did some tests this morning and the double posts seem to stop. The duplicate entries were a thousandth to a ten thousandth off in the time stamp, but now there's only the one entry as should be. Thank you again. David Gagnon wrote: > > > > > SCassidy@overlandstorage.com wrote: > >>Hi, >> >>If a web page has JavaScript called on a submit button, like >>'onClick="someFunction();", and the function does some stuff, then does a >>form.submit(), and DOES NOT REMEMBER TO RETURN FALSE, then the browser is >>supposed to go ahead and submit the form. So, something like that could >>possibly happen, but only if the JavaScript is incorrectly written, as far >>as I know. Although, once a submit is done, it would be a gray area as to >>whether the form data would still be available for the second submit. >> >> > > I think this thread discuss the problem .. like they say I started > having the problem with some version of IE6 but not IE5. > http://forums.devshed.com/showthread.php?t=50160&page=1&pp=15 > http://www.tfug.org/pipermail/tfug/2004-October/007785.html > > They don't give the answer but when they talk > > here is what it might be: > > <input class="input" type="submit " name="Submit" value="Submit" > onClick="javascript:submitit();"> > > if you use javascript to submit the form > > do not use a button type of submit.........it will submit twice > > correct code > > <input class="input" type="button " name="Submit" value="Submit" > onClick="javascript:submitit();"> > > Like SCassidy said .. maybe returing FALSE will solve the problem .. > but I remember having tried this without success... > > It's all what I know :-) > > > >>I use JavaScript in forms all the time to interact with a PostgreSQL >>database, and don't have any issues like this with debugged code, using >>IE6. >> >>Susan >> >> >> >> >> David Gagnon >> <dgagnon@siunik.com> To: D A GERM <dgerm@shepherd.edu> >> Sent by: cc: Postgresql-General <pgsql-general@postgresql.org> >> Subject: Re: [GENERAL] double entries into database when using IE >> >> pgsql-general-owner@pos |-------------------| >> tgresql.org | [ ] Expand Groups | >> |-------------------| >> >> 07/05/2005 02:24 >> PM >> >> >> >> >> >> >>Hi, >> >>I have seen IE posting request twice to the server when you post using a >>button that use javascript. Per example, if you have a submit button >>and call a javascript that actually post the form... IE will still do >>the post attached to the submit button. So you will have 2 submits.... >>It's stupid but it's true. >> >>It's happen on some version of IE6 I think .. not all for what I remember. >> >>You can search the web for the solution ... I don't remember what I did >>or if I actually did something to solve the problem. >> >>/David >> >>P.S.: This is quite OT for the postgresql mailing list .. you don't think ? >> >> D A GERM wrote: >> >> >> >>>I am having a problem when a browser dumps data into a table. >>>When the browser is Firefox , it works perfect; when the browser is >>>IE, it dumps 2 entries into the table just thousandths of a second apart. >>> >>>What could be causing this? Is this an issue with IE, Apache or Postgres. >>> >>>Thanks in advance for any help. >>> >>> >>> >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 4: Don't 'kill -9' the postmaster >> >> >> >> >> >> >> >>---------------------------------------------------------------------------------------------- >>See our award-winning line of tape and disk-based >>backup & recovery solutions at http://www.overlandstorage.com >>---------------------------------------------------------------------------------------------- >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 6: Have you searched our list archives? >> >> http://archives.postgresql.org >> >> >> > -- D. Aaron Germ Scarborough Library, Shepherd University (304) 876-5423 "Well then what am I supposed to do with all my creative ideas- take a bath and wash myself with them? 'Cause that is whatsoap is for" (Peter, Family Guy)