On Thu, Mar 23, 2006 at 04:17:44PM +0000, [EMAIL PROTECTED] wrote: > Lots of ways round this. Instead of deleting records, add a boolean > "deleted" flag. All selects then need to add "and deleted = 0". But you can > find a (random) deleted row with "select id from table where deleted = 1 > limit 1". If this returns a result, use update to re-populate that record, > clearing the deleted flag. If it returns nothing, use insert to create a > new record.
Great idea!! Many thanks!!! -- Best regards, saf http://Trashmail.net/
signature.asc
Description: Digital signature
