Re: Insert query in Oracle database using php and COM

Have you tried with PHP 4.0.5 RC1 from http://php4win.de ? There were many COM bugs in PHP 4.0.4 and earlier. Best of luck -- John "Julian" <julian.gonzalez@iconmedialab.es> wrote in message news:99vl70$aqu$1@toye.p.sourceforge.net... > i did this : > > $oConn = new COM("ADODB.Connection"); > $oConn ->ConectionString = > <<<<<<<<string>>>>>>>> ; > > the next command works fine: > > $oConn->Execute( "insert into Paciente > (nid,nombre,Apell1,Apell2,Sexo,NHisto,FNac) values > (10042,'wfcwsfvwsvcsw','ewfrewfrew','dsfdsfsf','Hombre','121219',to_date('12 > /1/1980','MM-DD-YYYY')) "); > > > but if i execute this one the php fails with an error of memory: > > $oConn->Execute("insert into Peticion > (NID,NPet,NPac,Diagnostico,FPet,Medico,Servicio,FPetFin,nidPass,obsPet,obsIn > f,codSer,itt) values > > (10060,'56',10040,3,to_date('29-03-2001','DD-MM-YYYY'),'Julian','urgencias > > ',to_date('12-1-2001','DD-MM-YYYY'),1,'oooo','ttt','urgencias > ','vv')"); > > > > if i copy into a sql tool and execute it works fine!!!!. > > Somebody knows why? > > Regards > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >