Re: [fw-db] Zend_Db_Select & Oracle problem

That worked thanks. But I had to do this:
$config = new Zend_Config_Ini(APPLICATION_PATH . "/config.ini",
"runzheimer");
$this->db = Zend_Db::factory($config->db);

I was thinking you meant:
$this->db = Zend_Db::factory($config->db);

mikaelkael wrote:
>
> Hi,
>
> Like this:
>
> [runzheimer]
> db.adapter = PDO_OCI
> db.params.host = vcp.web.fedex.com
> db.params.username = runzheimer
> db.params.password = runzheimer
> db.params.dbname = vcpdb
> db.params.options.autoQuoteIdentifiers = false
>
> You can use 'params' instead of 'config' to be able to do like this:
> $db = Zend_Db::factory($my_zend_config_object);
>
> See
> http://framework.zend.com/manual/en/zend.db.html#zend.db.adapter.connecting.factory-config
>
> Mickael
>
>
> 411161 a écrit :
>> I think I see however that brings up a few questions.
>>
>> My config.ini looks like this:
>> [runzheimer]
>> db.adapter = PDO_OCI
>> db.config.host = vcp.web.fedex.com
>> db.config.username = runzheimer
>> db.config.password = runzheimer
>> db.config.dbname = vcpdb
>>
>> Will my connection now have to look like it does below, or is there a way
>> to
>> just incorporate the
>> Zend_Db::AUTO_QUOTE_IDENTIFIERS => true??
>>
>>
>>
>> $options = array(
>> Zend_Db::AUTO_QUOTE_IDENTIFIERS => false
>> );
>>
>> $params = array(
>> 'host' => '127.0.0.1',
>> 'username' => 'webuser',
>> 'password' => 'xxxxxxxx',
>> 'dbname' => 'test',
>> 'options' => $options
>> );
>>
>> $db = Zend_Db::factory('Pdo_Mysql', $params);
>>
>>
>>
>>
>> 411161 wrote:
>>
>>> Not sure what I am doing wrong.
>>>
>>> //This works
>>> $sql = 'SELECT * FROM runz_miles WHERE empl_no = 31713';
>>> $this->view->result = $this->db->fetchAll($sql);
>>>
>>> //This does not
>>> //$select = $this->db->select()
>>> $select= $this->db->select()->from( 'runz_miles',
>>> 'EMPL_NO')->where('empl_no = ?', 31713);
>>> echo $select->__toString();
>>> //print_r($this->db->fetchAll($select));
>>> This gives me table does not exist.
>>>
>>> echo $select->__toString(); gives me:
>>> SELECT "runz_miles"."EMPL_NO" FROM "runz_miles" WHERE (empl_no = 31713)
>>> EMPL_NO should not be prefixed with runz_miles which is the table name.
>>>
>>> Here was my connection init()
>>> function init(){
>>>
>>> $config = new Zend_Config_Ini(APPLICATION_PATH . "/config.ini",
>>> "runzheimer");
>>> $this->db = Zend_Db::factory($config->db->adapter,
>>> $config->db->config->toArray());
>>> $this->db->getConnection();
>>> }
>>>
>>>
>>>
>>>
>>
>>
>
>
>
>

--
View this message in context: http://www.nabble.com/Zend_Db_Select---Oracle-problem-tp19763934p19767034.html
Sent from the Zend DB mailing list archive at Nabble.com.