Disaster with delete statement! AIEEEEE!!

[Ang�l Stewart]

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/cf-community@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists