Re: double entries into database when using IE - Mailing list pgsql-general
From | D A GERM |
---|---|
Subject | Re: double entries into database when using IE |
Date | |
Msg-id | 42CBD364.6020305@shepherd.edu Whole thread Raw |
In response to | Re: double entries into database when using IE (David Gagnon <dgagnon@siunik.com>) |
List | pgsql-general |
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)
pgsql-general by date: