RE: deleting db entries..

2004-06-02 Thread techmike
TED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Tue, 1 Jun 2004 18:16:36 -0400 Subject: RE: deleting db entries.. > > I know its advised against deleting database entries, but > > where am I going wrong here? > > There's absolutely nothing wrong with deleting unwan

RE: deleting db entries..

2004-06-01 Thread Dave Watts
> I know its advised against deleting database entries, but > where am I going wrong here? There's absolutely nothing wrong with deleting unwanted database records. > This statement works, but deletes all table entries rather > than the id of the one specfied.. > > The only thing I can think o

Re: deleting db entries..

2004-06-01 Thread Bryan Stevenson
well you shouldn't need the "limit 1", but I'm guessing that the value of "#entrytodelete#" is not correct...tell us what it is ;-) BTW...who said deleting database entries was a bad idea? It can be if you need to maintain a history of some kind (in which case you set a flag to indicate the record

RE: deleting db entries..

2004-06-01 Thread John Beynon
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,