What if you take the LIMIT 1 out of the SQL?

Jb.

-----Original Message-----
From: techmike [mailto:[EMAIL PROTECTED]
Sent: 01 June 2004 20:28
To: CF-Talk
Subject: deleting db entries..

I know its advised against deleting database entries, but where am I going
wrong here?

This statement works, but deletes all table entries rather than the id of
the one specfied..

The only thing I can think of is it is a query inside of another query..

Total brainfart here..

<cfquery datasource="mysql">
DELETE FROM table_name
WHERE id = #entrytodelete# LIMIT 1
</cfquery>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to