[CDBI] Cascading Update
jay at rigadon.com
Mon Feb 6 22:54:25 GMT 2006
Thanks for your reply James - I'm talking about the NewsCategory.id and
so yes I'm talking about modifying a primary key. There must be some way
to do this?
> Jay Hargreaves wrote:
>> I've created an admin script to allow users to create/modify/delete
>> News and NewsCategories entries. But I am having trouble when updating
>> the NewsCategories entry with a new ID. If I just change the ID in the
>> object and do an update nothing happens - perhaps I have missed
>> something as this seems the obvious way to do this.
> I'm confused, NewsCategories has many News? And so, you are trying to
> update News.NewsCategory_id ? or NewsCategory.id? In the latter case,
> it /sounds/ like you're trying to muck with a primary key which is bound
> to "not work" and in the former case, you could write an after update
> trigger to handle updating the news category ids in News with a
> different NewsCategory.id (assuming that the intent is to change the
> category the news item belongs to). Sorry if I've read your question
> - James
bingo, bango, bosh...
More information about the ClassDBI