[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-windows
Subject:    [PHP-WIN] Insert query in Oracle database using php and COM
From:       "Julian" <julian.gonzalez () iconmedialab ! es>
Date:       2001-03-29 15:45:04
[Download RAW message or body]

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

[prev in list] [next in list] [prev in thread] [next in thread]