CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Would this script delete records?

Print topic Send  topic

Author Message
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
View profile  Send private message
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
View profile  Send private message
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
View profile  Send private message
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.
View profile  Send private message
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.
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.