Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2001-02-01 : 04:09:31
|
| Ok - Im going to loose all cred here, but this is worth a post just to hear any similar stories to the problem we have been troubleshooting here for the last day or 2!One of our developers has been having this problem where his data was being deleted for no apparent reason. We troubleshooted server side and found it wasnt any stored procs or any IMPLICIT TRANSACTIONS set on so we turned our focus on to the ASP pages.The code all looked fine and is pretty much cut and paste stuff that we have been building for ages - So we were pretty much bewildered as to how the data was being deleted.We nailed it down to one page where upon selecting records to view you would suddenly loose all data - (no rocket scientist stuff - i thought ok, there must be some function that is hiding that deletes all records). Nup, no such luck. we rewrote the page line by line and nailed it down to this one line that is in a loop<% do while not rs.eof<a href="theatres_delete.asp?ID=<%=rsTheatres("theatre_id")%>">DELETE</a><br><% rs.movenextwend %>Now here is the good part! The link "theatres_delete.asp" is a page that deletes the record with whatever id is passed. But as we all know, you have to click on the link in the browser to load the page which deletes the file........not anymore - Artificial Intelligence is upon us! The records were being deleted automatically without having to click on the LINK! thats ridiculous you are saying??? - Of course it is. thats why I changed the link to read "delete.asp" just to make sure Im not going NUTS! (as there was no such page called delete.asp).Upon doing so - no records were deleted.So we ended up creating another delete.asp page that asks the user if they wish to delete which upon doing so loads another .asp page. this is how we stayed a step ahead of our PSYCHO server.But Ill probably come in tommorow and it will have worked that out as well!Maybe Ive been coding for too long...But I have come to the solution that our server is possesed! |
|
|
|
|
|
Artificial Intelligence - the weirdest thing!