EasyCFM.COM ColdFusion Forums / MySQL Related Issues / mysql state question

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: mysql state question

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

specific
12-13-2007 @ 2:03 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 897
Joined: Apr 2006

i know it is forum of cf but i have an mysql question which is causing
me trouble, i am using both phpmyadmin and mysql gui for my work..

my problem is when i try to enforce the on cascade delete functionality
i run into this error:



ALTER TABLE properties_details ADD FOREIGN KEY ( suburb_id )
REFERENCES suburbs( suburb_id ) ON DELETE CASCADE ;


the suburb_id in the properties_details table is the foriegn key and inj
the suburb table it is the primary key..

so when i run it, it gives me this error:

MySQL said:

#1005 - Can't create table '.\realestatenz\#sql-1698_14.frm' (errno:
150)

has anybody have experience in it

please let me know thanks

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The Door to Coldfusion Community Will Remain Open Till World Ends

Want a Web Portal Contact Me

randhawaz81@gmail.com

<cf_visitwebsite>

http://portal.randhawaworld.com/

</cf_visitwebsite>


Website Designed and Developed by Pablo Varando.