Maybe you have the query in a loop?
-----Original Message-----
From: Ang�l Stewart [mailto:[EMAIL PROTECTED]]
Sent: May 2, 2001 11:54 AM
To: CF-Community
Subject: Disaster with delete statement! AIEEEEE!!
Tell me peeples..maybe I'm going nuts..but what does this do?:
<CFQUERY name="WipeRecord" dataSource="CGANEWS">
DELETE FROM tblNews
WHERE tblNews.ID = #ID#
</CFQUERY>
And what does this mean?
Queries
WipeRecord (Records=0, Time=10ms)
SQL DELETE FROM tblNews
WHERE tblNews.ID = 485
------------------------------------------------------------------------
----
----
Execution Time
10 milliseconds
Doesn't that mean that it deleted ONE record where the ID was 485???
So..umm..then..
WHY DID IT DELETE THE ENTIRE TABLE OF NEWS RECORDS!!??
!_!
-Gel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
