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
