[CDBI] Cascading Update
kingsley at kingsleysoftware.com
Mon Feb 6 22:20:28 GMT 2006
Jay Hargreaves writes:
> 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.
Hi Jay -- Separate your notion of ID and primary key, and allow users
to modify a non-primary-key field named "ID". Better yet, name the
field something other than "ID".
Generally, it's best to keep primary keys behind the scenes, away from
More information about the ClassDBI