Re: [PHP4BETA] OCIParse & OCIExecute

On Fri, Apr 21, 2000 at 12:03:11PM +0200, thies@digicol.de wrote: > On Fri, Apr 21, 2000 at 12:55:25PM +0300, Vadim Tkachenko wrote: > > <? > > $c1 = ocilogon("xxxxx","xxxx"); > > echo OCIServerVersion($c1)."\n"; > > > > $stmt=OCIParse($c1,"SELECT VEND_CODE,VEND_NAME FROM manuf WHERE > > VEND_CODE=:vendcod"); > > OCIDefineByName($stmt,"VEND_CODE",&$VEND_CODE); > > OCIDefineByName($stmt,"VEND_NAME",&$VEND_NAME); > > > > OCIBindByName($stmt,":vendcod",&$vendcod,32); > > $vendcod="P-1"; > > > > > > OCIExecute($stmt); > > if (OCIFetch($stmt)){ > > echo "Found record!\n"; > > echo "$VEND_CODE $VEND_NAME\n"; > > }else{ > > echo "Records not Found"; > > }; > > > > > > OCIFreeStatement($stmt); > > OCILogOff($c1); > > ?> > > i don't have a manf table:( > > but i do have scott/tiger loaded - please adjust you testcase > to one of his tables. i've tried with scott/tiger - works for me.... plz try my script against your DB! tc > > > > > > please send a complete 20 line testcase of your problem to > > > me. > > > > > > > -- > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" > Digital Collections Phone +49 40 235350 Fax +49 40 23535180 > Hammerbrookstr. 93 20097 Hamburg / Germany > > -- > PHP 4.0 Beta Mailing List <http://www.php.net/version4/> > To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net > For additional commands, e-mail: php4beta-help@lists.php.net > To contact the list administrators, e-mail: php4beta-admin@lists.php.net -- Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany

Attachment: [application/x-httpd-php] ociparse.php