Re: [PHP4BETA] OCIParse & OCIExecute

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