RE: [PEAR] Oracle and numRows

From: Date: Tue, 16 Dec 2003 13:17:40 +0000
Subject: RE: [PEAR] Oracle and numRows
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-9564@lists.php.net to get a copy of this message
Well... that worked, however now I'm getting Undefined index errors. [11 rows returned] <---- NO LONGER SAYS OBJECT! BUT.... Notice: Undefined index: RUR_ID in /www/htdocs/userregresults.php on line 51 Notice: Undefined index: EMAIL in /www/htdocs/userregresults.php on line 54 Notice: Undefined index: GENDER in /www/htdocs/userregresults.php on line 58 Notice: Undefined index: AGE in /www/htdocs/userregresults.php on line 62 Notice: Undefined index: P_CODE in /www/htdocs/userregresults.php on line 66 Notice: Undefined index: P_TOWN in /www/htdocs/userregresults.php on line 70 Notice: Undefined index: RUR_ID in /www/htdocs/userregresults.php on line 51 That's what I get when I changed the following: $db = DB::connect($dsn); is now: $db = DB::connect($dsn, array('optimize' => 'portability')); When I tried "$db->setOption('optzimize', 'portability');" I got no errors, but still got the "Object" rows returned. Thanks, Steve -----Original Message----- From: Lukas Smith [mailto:smith@backendmedia.com] Sent: Tuesday, December 16, 2003 8:12 AM To: 'Dimoff, Steve'; pear-general@lists.php.net Subject: RE: [PEAR] Oracle and numRows > From: Dimoff, Steve [mailto:sdimoff@accipiter.com] > Sent: Tuesday, December 16, 2003 2:07 PM > To: 'Lukas Smith'; Dimoff, Steve; pear-general@lists.php.net > Subject: RE: [PEAR] Oracle and numRows >> You need to set your options accordingly: >> $this->options['optimize'] == 'portability' > Should the variable be $this or something else? Err .. I was just quoting the source. When you can pass DB options at connect time. $db =& DB:connect($dsn, array('optimize' => 'portability')) Alternatively you can set the option at a later point in time: $db->setOption('optzimize', 'portability'); Regards, Lukas -- PEAR General Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

« previous php.pear.general (#9564) next »