If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ASP > Need help ASP Delete not working

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-01-06, 14:42
MrhelpMe MrhelpMe is offline
Registered User
 
Join Date: Apr 2006
Posts: 140
Angry Need help ASP Delete not working

Hello again,

I am running a delete(to wipe out current data in database table) and then doing an insert all in the same asp page and then receiving

Code:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E31)
[Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation
Here is what I tried to do to troubleshoot. Unchecked enable query timeout on oracle odbc, added a <% Server.ScriptTimeOut = 900 %> to my page but these did not make any difference.

What did work was if I commented out my insert statement and just left my
Code:
delete from table x
it worked. Also note that I tried to delete the majority of the records in the database because I thought it may have an issue with it being too full. So now I am left with 82 records and it is still not working. Any ideas?
Reply With Quote
  #2 (permalink)  
Old 11-02-06, 16:40
Reghardt Reghardt is offline
Registered User
 
Join Date: Aug 2006
Location: San Francisco, CA
Posts: 136
Two things:

1. If the insert statement is giving you the error, please post the insert statement so that we can look at it

2. delete from table x - will delete all the rows in the table, you should probably add a where clause
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On