var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
On the child table , i have a FK(staffID) (allow null) that references the parent table via PK(staffID)(NOT NULL).
I specified the rules below, yet I cant UPDATE or DELETE a row in the parent table.
ON DELETE SET NULL,
ON UPDATE CASCADE,
LIFT ME UP PLEASE!!!!!!
Last edited by mysql_Juli; 06-20-07 at 04:03.
could you do a SHOW CREATE TABLE for both tables please
rudy.ca | @rudydotca
Buy my SitePoint book: Simply SQL
What is the error you are getting? Are you using InnoDB tables? As rudy suggests, please post your CREATE TABLE DDL.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors