duplicate database entries sql server 2008

[Irvin Wilson]

Just had an issue where every database insert appears to have an
immediate duplicate entry. Additionally there is a field in the
affected tables with a default value of "1" in a tinyint field. The
first entry of each dupe has "0" and the second one has "1" in this
field. Could be a sql server problem I suppose. I am going to search
that now. Wondering if anyone has seen this or has ideas as to
possible source of problem. Thank you!

[John Whish]

I'm using MS SQL Server 2008 on a Railo project at the moment and
haven't seen that issue. Do you have any triggers in the database?
Also does the debugging show multiple inputs?

I am running Railo development version as there is an issue with the
current stable and with bigint in MSSQL 2008.

[Irvin Wilson]

No triggers. If I have issue again I'll turn on debugging. After
looking around I really haven't gotten any closer to figuring it out.
Seems like it has to be sql server issue but is such a big error I
can't imagine how that could be the case. I'll post update if happens
again or i figure it out.

[Brad Wood]

Have you used SeeFusion or a similar tool to confirm that the pages aren't somehow being double-submitted. I've had that happen before with a form button that has an onClick and the page is actually running twice without realizing it.

Thanks!

~Brad

Sent from my ASUS Eee Pad