Waspman
Posts: 948
|
Posted: 05/20/2011, 3:11 AM |
|
DBConnection1.Execute ("UPDATE orders SET Despatched=1, item_despatched = '"& orders1.Despatched.Value &"' where cart_session_id='"& Request.QueryString("cartID") &"'")
Yeah I know it says update, but I'm having problems with records being unexpectedly deleted and this is the only script I use that does anything to the table on mass.
Silly question I know, but I'm desperate to find the cause of this problem
Thanks
_________________
http://www.waspmedia.co.uk |
|
|
Oper
Posts: 1195
|
Posted: 05/21/2011, 11:41 AM |
|
you will have to keep looking, casue your problem is not there.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
Waspman
Posts: 948
|
Posted: 05/21/2011, 1:04 PM |
|
Thought as much...just a stab in the dark.
I'm starting thing it could be someone doing it. It doesn't happen all the time, I can go weeks a no records going missing, then all of a sudden a 100 random records will be deleted. ?
_________________
http://www.waspmedia.co.uk |
|
|
Rocket
Posts: 45
|
Posted: 08/28/2011, 10:56 PM |
|
Do you have any Triggers that fire in an Update event in your DB system?
In all my years with MySQL and MSSQL, I have never seen and update clause delete records, HOWEVER, I have seen systems that delete records based on an update trigger.
Just a thougt.
|
|
|
andrewi
Posts: 162
|
Posted: 08/29/2011, 11:20 AM |
|
If you think someone else might be (maliciously) deleting records, then you may be giving them the opportunity for SQL injection by placing a value from Request.QueryString directly into theSQL.
|
|
|
|