confusing error in straightforward INSERT statement
Posted: Mon Jun 24, 2002 10:57 pm
The following MySQL command almost works:
їcode]INSERT INTO employee_info (co_id,co_em_id,em_first_name,em_last_name,em_start_date,em_pos,em_start_date_co,em_addr_1,em_addr_2,em_city,em_prov_id,em_pc,em_fax,em_phone,em_dob,em_email,em_sex,em_status_co,em_pcc,em_fcc,em_ei,em_status_sys) VALUES ('4','2943','Caleb','Alpen',CURDATE(),'Trucker','2001-9-18','Addrss line 1','address ln 2','city','1','S0C 0S0','3063825340','3264425340','1937-03-13','csg@test.com','M','2','123','123','1.3','1')ї/code]
For some weird reason the em_fax field always shows up in the database as 2147483647 instead of the number it's supposed to put in! em_fax is set up exactly the same as em_phone and em_phone inserts just fine. There are no associated error messages, and this statement is PHP generated by a form -- I just echoed it to the browser so I could cut and paste it.
Any suggestions?
їcode]INSERT INTO employee_info (co_id,co_em_id,em_first_name,em_last_name,em_start_date,em_pos,em_start_date_co,em_addr_1,em_addr_2,em_city,em_prov_id,em_pc,em_fax,em_phone,em_dob,em_email,em_sex,em_status_co,em_pcc,em_fcc,em_ei,em_status_sys) VALUES ('4','2943','Caleb','Alpen',CURDATE(),'Trucker','2001-9-18','Addrss line 1','address ln 2','city','1','S0C 0S0','3063825340','3264425340','1937-03-13','csg@test.com','M','2','123','123','1.3','1')ї/code]
For some weird reason the em_fax field always shows up in the database as 2147483647 instead of the number it's supposed to put in! em_fax is set up exactly the same as em_phone and em_phone inserts just fine. There are no associated error messages, and this statement is PHP generated by a form -- I just echoed it to the browser so I could cut and paste it.
Any suggestions?