[rt-users] Deleting tickets 2

[Steve Poirier]

Well i wrote the script and it work in MySQL. Thats the important thing for
me because the programmers who write 'nice code' here are very very busy :-)
but thanks for the advice.


__
Steve Poirier
Project Manager
Inet Technologies Inc.


----- Original Message -----
From: "Vivek Khera" <khera at kcilink.com>
To: <rt-users at lists.fsck.com>
Sent: August 6, 2001 10:17
Subject: Re: [rt-users] Deleting tickets 2


> >>>>> "SP" == Steve Poirier <steve at inet-technologies.com> writes:
>
> SP> Thanks! So, what i need to do is:
> SP> select id from Tickets where Status='dead';
>
> SP> You delete the Tickets where status is dead
>
> Wow... pretty complex.  Foreign keys would make this much easier.
> Just declare a foreign key with ON DELETE CASCADE on the tables that
> link back to ticket ID, then deleting the ticket ID in that table
> would cascade the delete across to the other tables.  I guess this
> wouldn't work in MySQL, though...
>
> --
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Vivek Khera, Ph.D.                Khera Communications, Inc.
> Internet: khera at kciLink.com       Rockville, MD       +1-240-453-8497
> AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>