Peter J. Boettcher — Wed, 21 Mar 2001 02:56:18 +0000

Ok, just wanted to make sure. Is this SQL statement in an ASP page? I'm just wondering what's with the %%, you don't need to use those unless you're using LIKE.

Try this:

DELETE FROM CUSTOMERS
WHERE IdentityField = 'PassedValue'

Just replace IdentityField with the column in your table which represents the number of the record you want to delete. PassedValue is the value you're passing to the select statement.

moto — Wed, 21 Mar 2001 00:57:22 +0000

Yea, I know - just learning! What I really want to do, though, is be able to input the records unique identifier which then prevents the record from being shown on the web page. This allows the administrator to have access to records in the future...

Peter J. Boettcher — Tue, 20 Mar 2001 18:41:18 +0000

moto,

You definitely should NOT be deleting records by First name, as you know many people have the same first name

Modify the table so it has an identity field, or a unique identifier. Then delete by using this field instead.