RE: [PEAR] Oracle and numRows
| From: | Dimoff, Steve | 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