Hello Everyone, I am using the code shown in the attached file to update a long text field. It works perfectly fine except for when the field is null. It then give me the Cursor Operation Conflict error message. Any ideas on how to solve this problem. Thanks, Joe
Joe HoodOP
@Reply 3 years ago
Kevin Yip
@Reply 3 years ago
Cursor-related errors most likely have to do with the cursor options you set at the end of the rs.Open statement. Try using different options. Richard's courses probably cover this more than I can do here. Your current options are 0 (default), 3. Try 1, 2, which is a different cursor and record-lock mechanism.
My advice is to avoid using recordsets to update tables in ASP. Use recordsets only for viewing records, so you can use a less restrictive cursor and locking method. To update data, use update queries, which don't involve cursors and won't cause the headache you see now. E.g.:
Conn.Execute "UPDATE Table1 SET A=B, C=D WHERE ID=1;"
Conn.Execute "INSERT INTO Table2 SELECT E, F, G;"
Joe HoodOP
@Reply 3 years ago
Thanks Kevin, I will give your suggestions a try and let you know how it works out.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Active Server Pages Forum.
