Re: double entries into database when using IE

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(at)overlandstorage(dot)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(at)siunik(dot)com> To: D A GERM <dgerm(at)shepherd(dot)edu>
>> Sent by: cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
>> Subject: Re: [GENERAL] double entries into database when using IE
>>
>> pgsql-general-owner(at)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 what soap is for" (Peter, Family Guy)