Re: double entries into database when using IE - Mailing list pgsql-general

From David Gagnon
Subject Re: double entries into database when using IE
Date
Msg-id 42CB1C35.1080205@siunik.com
Whole thread Raw
In response to Re: double entries into database when using IE  (SCassidy@overlandstorage.com)
Responses Re: double entries into database when using IE
List pgsql-general




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
 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Custom C function shutdown-signaling
Next
From: Roy Souther
Date:
Subject: How can I make SELECT return tuple numbers?