This hurts to look at. Is that the entire table? Or are there
additional fields that make those rows unique? If it's the entire table,
why do you have identical rows, and why do you want to retain them? If
there's more to the table, extend your 'where' clause to identify the
unique row that you want to delete.
I suppose you could delete all of these rows and then reinsert one, with
a CFTRANSACTION around the delete and insert.
Also, if the id's are numeric, omit the quotes.
-David
On Wed, 27 Sep 2000 13:58:57 -0500 Gavin Myers
<[EMAIL PROTECTED]> writes:
> here's what i'm doing
>
> delete from class_registration
> where users_id='123123'
> and class_id='4242424'
>
> here's what the table looks like
>
> name users_id class_id
> gavin 123123 4242424
> gavin 123123 4242424
> gavin 123123 4242424
> gavin 123123 4242424
>
> what i want to do is delete only 1 of those rows
>
> suggestions?
>
> thanks,
> Gavin
________________________________________________________________
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
