How to insert two tables using aspsmart upload

[yatie]

I have problem in inserting data to two databases. One table has successfull insert but another one fail. Error : syntax error in insert into statement. I'm very sure that it is not error in syntax but are there other syntax must we use when we use <form enctype="multipart/form-data">. Because it can't recognise request.form.

Please help me...thank you...

[jhardman]

I have never used ASPSmart upload, but can you print your "insert into" statement before executing? Sometimes this clarifies where the problem is.

You say you believe that using this particular enctype might be confusing your script. You only need enctype="multipart/form-data" if you are uploading whole binary files. Is this something you need?

Third, you say the first page inserts satisfactorily, but the second fails. Are these done by two different scripts one after the other, or is this one long concatenated script? If you have these two inserts on two different script pages then it is likely the form data is posted to the first page and not the second. Let me know if this helps.

Jared