• Welcome to The Network People Support Forums. Please login or sign up.
December 04, 2021, 08:55:57 PM


Started by shaun, June 22, 2005, 04:33:27 PM

Previous topic - Next topic


Is option some where i'm not seeing that will tell nictool to stop setting deleted=1 and to just remove the row from the db?

a quick count on just my records table today showed over 8 Million rows with deleted=1  Shocked


be SURE you did you query correct:

select * from nt_zone_record where deleted='1';
select * from nt_zone_record where deleted=1;

how I clear it:
delete from nt_zone_record where deleted='1';
delete from nt_zone_record where deleted=1;

I've deleted my nictool DB atleast twice now by making that mistake. (thankfully I run select * first)
--- May this post be indexed by spiders, and archived for all to see as my internet epitaph.
http://FPuX.com" target="_blank">http://FPuX.com


thanks for the replay/info, luckily i always wrap my query statments input with ''.  But i can see why you posted that with my above post  Very Happy

Oh well, guess i'll write up a cron job or somthing that goes through a cleans the db.