Re: Oracle OCIBindByName Problem

Hi all I've changed the query to this. But still no luck. I've also tried adding logon_id to the select list, and defining $sLogon before the OCIBindByName call. $custStmt = OCIParse($oradb,'SELECT co_code, cust_type, customer_flags, ' . 'email_address, user_view FROM customer ' . 'WHERE logon_id = :logonid'); OCIBindByName($custStmt,':logonid',&$sLogon,32); $sLogon = 'LANG'; var_dump(OCIExecute($custStmt)); var_dump(OCIFetchInto($custStmt,$aCustRec)); var_dump($aCustRec); ?> After my first email i started writing a table viewer script. Fully expecting it not to work, i started using bind variables. But it worked perfectly. I'm connecting to the same database as the same user. The interesting bits are below. $tablesStmt = OCIParse($oradb,'SELECT * FROM ALL_TABLES WHERE OWNER = :owner'); OCIBindByName($tablesStmt,':owner',$sOwner,32); $colsStmt = OCIParse($oradb,'SELECT * FROM ALL_TAB_COLUMNS ' . 'WHERE OWNER = :owner AND TABLE_NAME = :tab'); OCIBindByName($colsStmt,':owner',$sOwner,32); OCIBindByName($colsStmt,':tab',$sTable,32); foreach($aSchemas as $sOwner) { echo "<H1>{$sOwner}</H1>\n"; OCIExecute($tablesStmt); while(OCIFetchInto($tablesStmt,$aTable,OCI_ASSOC+OCI_RETURN_NULLS)) { $sTable = $aTable['TABLE_NAME']; echo "{$sTable}\n"; OCIExecute($colsStmt); while(OCIFetchInto($colsStmt,$aCol,OCI_ASSOC+OCI_RETURN_NULLS)) { echo ' ' . str_pad($aCol['COLUMN_NAME'],34), data_type($aCol), $aCol['NULLABLE'] == 'N' ? ' NOT NULL' : '', "\n"; } echo "\n"; } } How come this script works, but the top one doesn't? Thanks Lang Jadiel Flores wrote: > Have u tried using: > OCIBindByName($custStmt,':logonid',$sLogon,4); > instead of: > OCIBindByName($custStmt,':logonid',&$sLogon,4); > ??? > (the difference if in the & in the 3rd parameter) > > > > Jadiel Flores > ------------------------- > http://www.abargon.com > jflores@abargon.com > (52-55) 52-29-80-34