[PHP-DEV] Bug #10053 Updated: Insert sentence error
ID: 10053 Updated by: phanto Reported By: [EMAIL PROTECTED] Old-Status: Feedback Status: Closed Bug Type: COM related Operating system: PHP Version: 4.0.4 Assigned To: Comments: no response Previous Comments: --- [2001-05-07 12:46:12] [EMAIL PROTECTED] Does this problem persist with PHP 4.0.6-dev? There have been a lot of changes to ext/com recently, including improtant fixes after the PHP 4.0.5 release that will be included in PHP 4.0.6. --- [2001-03-29 09:47:19] [EMAIL PROTECTED] $oConn = new COM(ADODB.Connection); // Data Base: ORACLE 8.0 // insert query: it works fine!!! insert into Pact (nid,name,Apell1,Apell2,Sexo,NHisto,FNac) values (10040,'qwrwfcdf','qeqwe','qewqwe','Hombre','121217',to_date('12/12/1999','MM-DD-')) // insert query: it does not works: php error memory insert into Pet (NID,NPet,NPac,Diagnostico,FPet,Medico,Servicio,FPetFin,nidPass,obsPet,obsInf,codSer,itt) values (10060,'56',10040,3, to_date('29-03-2001','DD-MM-'), to_date('12-1-2001','DD-MM-, '', 'ttt', 'urgencias ', 'vv') If i copy this query (generated by my php code), and paste into a SQL editor that work for make queries into data bases and i execute it, it works fine. Maybe a problem of lenght?. I hope i was wrong. --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=10053edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #10053 Updated: Insert sentence error
ID: 10053 Updated by: sbergmann Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Feedback Bug Type: COM related Operating system: PHP Version: 4.0.4 Assigned To: Comments: Does this problem persist with PHP 4.0.6-dev? There have been a lot of changes to ext/com recently, including improtant fixes after the PHP 4.0.5 release that will be included in PHP 4.0.6. Previous Comments: --- [2001-03-29 09:47:19] [EMAIL PROTECTED] $oConn = new COM(ADODB.Connection); // Data Base: ORACLE 8.0 // insert query: it works fine!!! insert into Pact (nid,name,Apell1,Apell2,Sexo,NHisto,FNac) values (10040,'qwrwfcdf','qeqwe','qewqwe','Hombre','121217',to_date('12/12/1999','MM-DD-')) // insert query: it does not works: php error memory insert into Pet (NID,NPet,NPac,Diagnostico,FPet,Medico,Servicio,FPetFin,nidPass,obsPet,obsInf,codSer,itt) values (10060,'56',10040,3, to_date('29-03-2001','DD-MM-'), to_date('12-1-2001','DD-MM-, '', 'ttt', 'urgencias ', 'vv') If i copy this query (generated by my php code), and paste into a SQL editor that work for make queries into data bases and i execute it, it works fine. Maybe a problem of lenght?. I hope i was wrong. --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=10053edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]