electofaysal
Posts: 7
|
Posted: 07/14/2004, 6:44 AM |
|
Hi.
ok here is the problem.
As you all see ... in the directory maintenance example ... we can edit any category in a directiry ... and its sub categories etc etc.
I want to integrate some support such that when a user deletes a parent category ... all the sub-categories within it delete also ... any ides what needs to be done and where ? All help would be appreciated.
Basically ... something that checks checks records with the same parent_id and deletes them also
DELETE from cat WHERE parent_id="cat_id" should be the sql ... but how do i implement it ?
|
|
|
klwillis
Posts: 428
|
Posted: 07/14/2004, 9:26 AM |
|
:::
Assuming the deletion of the parent category is successful,
you could place custom record deletion code within the
'After Delete' event:
DBDirectory.Execute ("delete from cat where parent_id = cat_id");
(DBDirectory is defined as one of your project database connections)
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
|
|
electofaysal
Posts: 7
|
Posted: 07/30/2004, 12:51 AM |
|
cn someone give me a run down of this in PHP ?
|
|
|
Don Safar
|
Posted: 07/30/2004, 7:57 AM |
|
In ccs help do search on "custom sql"
"electofaysal" <electofaysal@forum.codecharge> wrote in message
news:54109fdef3ece8@news.codecharge.com...
> cn someone give me a run down of this in PHP ?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|