Posted by Richard Lynch on 03/04/05 20:57

Jed R. Brubaker wrote:
> Thank you both for your responces.
>
> Unfotuantely there is no form that instantiates this action. So the double
> submit (while a good idea), is not possible.
>
> As for some sample code, it is part of a rather complicated system that
> makes a number of changes but essentailly what is going on is this:
>
> 1. Grab all items that we need to do some shipping stuff to.
> 2. Foreach through the items, giving each item number to a function to
> assign it to a customer and create a mailling label.
>
> That simple!
>
> The interesting this is this - the duplicate record is inserted into the
> mailing labels queue. I can see it long before I grab the data for output
> to
> labels. Moreover, I can tell that the problem isn't in the original item
> select statement because the function (executed for each item) would have
> created different insert times in the database based on the now( ).

Show us code excerpts.

We can't second-guess from your description, as good as it is.

Pin-point the code that is doing the double insert, and print out some
debugging info there.

--
Like Music?
http://l-i-e.com/artists.htm

[Back to original message]