From:             [EMAIL PROTECTED]
Operating system: W2000
PHP version:      4.0.4
PHP Bug Type:     COM related
Bug description:  Insert sentence error

$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-YYYY'))


// 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-YYYY'),
to_date('12-1-2001','DD-MM-YYYY,
 'oooo',
 '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.




-- 
Edit Bug report at: http://bugs.php.net/?id=10053&edit=1



-- 
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]

Reply via email to