ASP Transactions and MySQL

Has anyone successfully written an ASP page in JScript that implements transactions with a mySQL database?

Please let me know - I'm having difficulty doing this.

Thanks.

What is your problem? We can probably help if you give some more detail.

Here's the quick version:

a user fills out an HTML form, presses submit.

The information in the form gets written to three tables. We use three sql insert statements with one ADODB.Command object.

99% of the time all three files get populated. Sometimes only one gets populated, and we never know until the user tries to access data from all three files and no record is returned. (All three files have to be there or else the rs is EOF.)

I thought wrapping the entire process in a transaction might help, but I can't get it to work.

I'm not sure why the other two inserts are not being inserted in those rare instances. There is no common thread (so far) between the failures. I can post a very simple version of the code I'm using for the transaction if that would help.

Thanks for writing back.

Code would help. The code for the inserts might be useful too, on the chance we could find the reason they didn't work.
Question about the failed entries- if you immediately retry the exact same thing, does it work then? Cause it seems you could do a quick check for eof, and if the statement failed, just have the code run it again, until it works. JUst a thought.