php y sql server 2005
Publicado por Jorge (1 intervención) el 15/09/2015 22:52:02
Estimados, necesito de sus ayuda me aparece este error al tratar de insertar un registro
INSERT INTO CONTACTO (ID ,ACCT_ID,ADDR_1,ADDR_2,ADDR_3,ADDR_NAME,ALT_NAME,ALT_ADDR_1,ALT_ADDR_2,ALT_ADDR_3 ,ALT_COUNTRY,ALT_CITY,ALT_STATE,ALT_ZIPCODE,BIRTH_DATE,BUS_PHONE,CITY,CONTACT_NO,COUNTRY,CREATE_DATE ,CREATOR,CUST_ID,EMAIL_ADDR,FAX_PHONE,FIRST_NAME,FOLLOW_UP,FOLLOW_UP_DATE,FOLLOW_UP_TYPE,GENDER,HOME_PHONE ,HONORIFIC,MIDDLE_INITIAL,LAST_NAME,MOBILE_PHONE,NICK_NAME,OTHER_PHONE,OWNER,REPORTS_TO_ID,SEMINAR_INVITE,SEND_NEWS ,SEND_PROMO,SOC_SEC_NBR,STATE,TIME_ZONE,TITLE,URL,USER_T1,USER_T2,USER_T3,USER_T4 ,USER_T5,USER_D1,USER_D2,USER_D3,VENDOR_ID,WEB_PASSWORD,WEB_USER_ID,ZIPCODE,COMMENTS,LAST_MODIFIED ,LAST_USER,USER_N1,USER_N2,USER_N3,USER_N4,USER_N5,INACTIVE_CONTACT,ACCT_PRIMARY,PROPER_NAME,USER_T6 ,USER_T7,USER_T8,USER_T9,USER_T10,USER_T11,USER_T12,USER_T13,USER_T14,USER_T15,USER_T16 ,USER_T17,USER_T18,USER_T19,USER_T20,USER_T21,USER_T22,USER_T23,USER_T24,USER_T25,USER_T26 ,USER_T27,USER_T28,USER_T29,USER_T30,USER_N6,USER_N7,USER_N8,USER_N9,USER_N10,USER_N11 ,USER_N12,USER_N13,USER_N14,USER_N15,USER_D4,USER_D5,AREA_ID,BRANCH_ID,BUS_UNIT_ID,DIVISION_ID ,RATING,RATING_COMMENTS,SALESREP_ID,SUB_AREA_ID,TERRITORY,TYPE,DO_NOT_CONTACT,DO_NOT_EMAIL,DO_NOT_PHONE,DO_NOT_MAIL ,DO_NOT_FAX,COMMENTS_BIN,PREF_CONTACT,SALUTATION) VALUES( '01967','','','','','','','','','', '','','','','2015-09-15','','',0,'','2015-09-15', 'LECTURA','T','P','','T',0,'2015-09-15','','','', '','','T','','','','','',0,0, 0,'','','','T','','','','','', '','2015-09-15','2015-09-15','2015-09-15','','','','','','2015-09-15', '',1,1,1,1,1,0,0,'','', '','','','','','','','','','', '','','','','','','','','','', '','','','',1,1,1,1,1,1, 1,1,1,1,'2015-09-15','2015-09-15','','','','', 0,'','','','','','2015-09-15','2015-09-15','2015-09-15','2015-09-15', '2015-09-15','','','')
solo me muestra este mensaje
Se terminó la instrucción.
luego ejecuto para verificar si se inserto el registro select * from contacto
y no me guarda el registro.
INSERT INTO CONTACTO (ID ,ACCT_ID,ADDR_1,ADDR_2,ADDR_3,ADDR_NAME,ALT_NAME,ALT_ADDR_1,ALT_ADDR_2,ALT_ADDR_3 ,ALT_COUNTRY,ALT_CITY,ALT_STATE,ALT_ZIPCODE,BIRTH_DATE,BUS_PHONE,CITY,CONTACT_NO,COUNTRY,CREATE_DATE ,CREATOR,CUST_ID,EMAIL_ADDR,FAX_PHONE,FIRST_NAME,FOLLOW_UP,FOLLOW_UP_DATE,FOLLOW_UP_TYPE,GENDER,HOME_PHONE ,HONORIFIC,MIDDLE_INITIAL,LAST_NAME,MOBILE_PHONE,NICK_NAME,OTHER_PHONE,OWNER,REPORTS_TO_ID,SEMINAR_INVITE,SEND_NEWS ,SEND_PROMO,SOC_SEC_NBR,STATE,TIME_ZONE,TITLE,URL,USER_T1,USER_T2,USER_T3,USER_T4 ,USER_T5,USER_D1,USER_D2,USER_D3,VENDOR_ID,WEB_PASSWORD,WEB_USER_ID,ZIPCODE,COMMENTS,LAST_MODIFIED ,LAST_USER,USER_N1,USER_N2,USER_N3,USER_N4,USER_N5,INACTIVE_CONTACT,ACCT_PRIMARY,PROPER_NAME,USER_T6 ,USER_T7,USER_T8,USER_T9,USER_T10,USER_T11,USER_T12,USER_T13,USER_T14,USER_T15,USER_T16 ,USER_T17,USER_T18,USER_T19,USER_T20,USER_T21,USER_T22,USER_T23,USER_T24,USER_T25,USER_T26 ,USER_T27,USER_T28,USER_T29,USER_T30,USER_N6,USER_N7,USER_N8,USER_N9,USER_N10,USER_N11 ,USER_N12,USER_N13,USER_N14,USER_N15,USER_D4,USER_D5,AREA_ID,BRANCH_ID,BUS_UNIT_ID,DIVISION_ID ,RATING,RATING_COMMENTS,SALESREP_ID,SUB_AREA_ID,TERRITORY,TYPE,DO_NOT_CONTACT,DO_NOT_EMAIL,DO_NOT_PHONE,DO_NOT_MAIL ,DO_NOT_FAX,COMMENTS_BIN,PREF_CONTACT,SALUTATION) VALUES( '01967','','','','','','','','','', '','','','','2015-09-15','','',0,'','2015-09-15', 'LECTURA','T','P','','T',0,'2015-09-15','','','', '','','T','','','','','',0,0, 0,'','','','T','','','','','', '','2015-09-15','2015-09-15','2015-09-15','','','','','','2015-09-15', '',1,1,1,1,1,0,0,'','', '','','','','','','','','','', '','','','','','','','','','', '','','','',1,1,1,1,1,1, 1,1,1,1,'2015-09-15','2015-09-15','','','','', 0,'','','','','','2015-09-15','2015-09-15','2015-09-15','2015-09-15', '2015-09-15','','','')
solo me muestra este mensaje
Se terminó la instrucción.
luego ejecuto para verificar si se inserto el registro select * from contacto
y no me guarda el registro.
Valora esta pregunta
0
