Howdy Folks ---- I hope this is not too much information.
I have mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386) I have multiple tables. All are innoD Tables. All AI on a Primary key integer All Columns are varchar 255 that are not keys. Table VCS_PO_NUMBER Has a one to many relationship with. Table BOARD_SERIAL_NUMBER Has a one to many relationship with the following tables: INSERT INTO BOARD_TYPE INSERT INTO RECIEPT_INSPECTION INSERT INTO PCB_MANUFACTURER I originally was taking form data and using many cold fusion use <CFINSERT> to write the information into the tables. And received this error: Error Executing Database Query. General error: Cannot add a child row: a foreign key constraint fails The error occurred in /home/httpd/vhosts/vistasystemsproductions.net/httpdocs/recieve_boards_actio n.cfm: line 10 8 : <cfinsert datasource="productiontrack" 9 : tablename="BOARD_SERIAL_NUMBER" 10 : formfields="BOARD_SERIAL_NUMBER" 11 : > 12 : _____ SQL insert into BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) values ( (param 1) ) So now I thought I would wirite the insert statements in SQL instead of CF. I currently am failing with the following: mysql> INSERT INTO VCS_PO_NUMBER (VCS_PO_NUMBER) VALUES(899234), -> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) VALUES(36534), -> INSERT INTO BOARD_TYPE (BOARD_TYPE) VALUES(INPUT MODULE N12310), -> INSERT INTO RECIEPT_INSPECTION (RECIEPT_INSPECTION_NAME) VALUES(BILlTHOMAS), -> INSERT INTO PCB_MANUFACTURER (PCB_MANUFACTURER_COMPANY_NAME) VALUES(A); ERROR 1064: You have an error in your SQL syntax near 'INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) VALUES(36534), INSERT INTO' at line 2 Any help ideas recommendations are appreciated. Thanks, Todd