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

Reply via email to