--
*Cherankrish*
Cherankrish@gmail.com
Skype: cherankrish
QR code :
Cheers,
David
--
View this message in context: http://zend-framework-community.634137.n4.nabble.com/safe-mod-and-zend-cache-tp2719672p2720146.html
Sent from the Zend MVC mailing list archive at Nabble.com.
i really work on this and trace it
that errror was from ZEND_DATE :-O !!
fixed by adding this :
$cache = Zend_Registry::get ( 'cache' );
$this->setOptions(array('cache' => $cache));
to my zend_date extended class :|
On Wed, Sep 29, 2010 at 11:54 PM, sina miandashti <miandashti@gmail.com>wrote:
> Dear mattew
>
> i set that before in my boot strap (index.php)
>
> $frontend = array (lifetime => 345600, automatic_seralization => true );
> $backend = array ('cache_dir' => APPLICATION_PATH . '/cache/data/' );
> $cache = Zend_Cache::factory('Core','File',$frontend,$backend);
> $cache->setOption('automatic_serialization', true);
>
>
> On Wed, Sep 29, 2010 at 11:38 PM, Matthew Weier O'Phinney <
> matthew@zend.com> wrote:
>
>> -- sina miandashti <miandashti@gmail.com> wrote
>> (on Wednesday, 29 September 2010, 11:28 PM +0330):
>> > safe mod in my server is preventing zend_cache from caching it shows
>> this
>> > exception :
>> >
>> > *Could not determine temp directory, please specify a cache_dir
>> manually*
>> > *
>> > *
>> > i talked to my webhost manager and he said they cant turn the safe mod
>> off
>> >
>> >
>> > what can i do?
>> >
>> > zend_cache not works with safemod?
>>
>> It can work with safe_mode fine -- but you need to tell Zend_Cache to
>> use a directory within your application tree. Use the "cache_dir"
>> backend option for the File backend to specify the directory.
>>
>> --
>> Matthew Weier O'Phinney
>> Project Lead | matthew@zend.com
>> Zend Framework | http://framework.zend.com/
>> PGP key: http://framework.zend.com/zf-matthew-pgp-key.asc
>>
>>
>
>
> --
> ________________
> Sincerely
> Sina Miandashti
> MuSicBasE.ir & InvisionPower.ir Admin
>
--
________________
Sincerely
Sina Miandashti
MuSicBasE.ir & InvisionPower.ir Admin
i set that before in my boot strap (index.php)
$frontend = array (lifetime => 345600, automatic_seralization => true );
$backend = array ('cache_dir' => APPLICATION_PATH . '/cache/data/' );
$cache = Zend_Cache::factory('Core','File',$frontend,$backend);
$cache->setOption('automatic_serialization', true);
On Wed, Sep 29, 2010 at 11:38 PM, Matthew Weier O'Phinney
<matthew@zend.com>wrote:
> -- sina miandashti <miandashti@gmail.com> wrote
> (on Wednesday, 29 September 2010, 11:28 PM +0330):
> > safe mod in my server is preventing zend_cache from caching it shows this
> > exception :
> >
> > *Could not determine temp directory, please specify a cache_dir manually*
> > *
> > *
> > i talked to my webhost manager and he said they cant turn the safe mod
> off
> >
> >
> > what can i do?
> >
> > zend_cache not works with safemod?
>
> It can work with safe_mode fine -- but you need to tell Zend_Cache to
> use a directory within your application tree. Use the "cache_dir"
> backend option for the File backend to specify the directory.
>
> --
> Matthew Weier O'Phinney
> Project Lead | matthew@zend.com
> Zend Framework | http://framework.zend.com/
> PGP key: http://framework.zend.com/zf-matthew-pgp-key.asc
>
>
--
________________
Sincerely
Sina Miandashti
MuSicBasE.ir & InvisionPower.ir Admin
It can work with safe_mode fine -- but you need to tell Zend_Cache to
use a directory within your application tree. Use the "cache_dir"
backend option for the File backend to specify the directory.
--
Matthew Weier O'Phinney
Project Lead | matthew@zend.com
Zend Framework | http://framework.zend.com/
PGP key: http://framework.zend.com/zf-matthew-pgp-key.asc
safe mod in my server is preventing zend_cache from caching it shows this
exception :
*Could not determine temp directory, please specify a cache_dir manually*
*
*
i talked to my webhost manager and he said they cant turn the safe mod off
what can i do?
zend_cache not works with safemod?
--
________________
Sincerely
Sina Miandashti
MuSicBasE.ir & InvisionPower.ir Admin
--
*Hector Virgen*
Sr. Web Developer
Walt Disney Parks and Resorts Online
http://www.virgentech.com
On Mon, Sep 27, 2010 at 9:45 AM, Christian Heinrich <
christian@gladbachcity.de> wrote:
> Hi,
>
> you can easily render viewscripts via
>
> <?php echo $this->render('viewscript.phtml'); ?>
>
> Maybe this helps?
>
> Regards
> Christian
>
> Hello,
>>
>> I'm working on a ZF-based application, and I've a problem... I'm using a
>> layout to define my header/footer and a view printed using
>> "echo $this->layout()->content".
>>
>> The problem is that in a controller, each page have the same structure and
>> I want to create a layout for them. I can create a new layout but in its I
>> have to write again my header/footer declarations, and I don't want because
>> if I have to change one link, I will have to change in the both layouts.
>>
>> So, my question is: is it possible to create a layout name "my_controller"
>> within I'll user "echo $this->layout()->content" and my view will be printed
>> in, and that my new layout takes place of the view in my main "layout"
>> layout?
>>
>> These files will be used to generate HTML of my pages:
>> layouts/layout.phtml > layouts/my_controller.phtml > views/my_action.phtml
>>
>> Is it possible? If not, is it possible with another way?
>>
>> Best regards,
>> Samuel ROZE.
>>
>>
>
>
you can easily render viewscripts via
<?php echo $this->render('viewscript.phtml'); ?>
Maybe this helps?
Regards
Christian
> Hello,
>
> I'm working on a ZF-based application, and I've a problem... I'm using a layout to define my header/footer and a view printed using
> "echo $this->layout()->content".
>
> The problem is that in a controller, each page have the same structure and I want to create a layout for them. I can create a new layout but in its I have to write again my header/footer declarations, and I don't want because if I have to change one link, I will have to change in the both layouts.
>
> So, my question is: is it possible to create a layout name "my_controller" within I'll user "echo $this->layout()->content" and my view will be printed in, and that my new layout takes place of the view in my main "layout" layout?
>
> These files will be used to generate HTML of my pages:
> layouts/layout.phtml > layouts/my_controller.phtml > views/my_action.phtml
>
> Is it possible? If not, is it possible with another way?
>
> Best regards,
> Samuel ROZE.
>
Sorry for the late reply. Had a major hangover during the weekend.
I've only got the batch operation working for Docs ACL and Calendar batch
mode.
The code was created off the 1.8 version of the library. So you'd want to do
a diff against version 1.8.4 if you want to get the diff.
You can get the file from http://rojakcoder.com/Gdata.zip
Please feel free to email me if you have any questions about the code.
--
View this message in context: http://zend-framework-community.634137.n4.nabble.com/Google-Data-API-version-2-compatability-is-it-planned-tp2550756p2714855.html
Sent from the Zend gdata mailing list archive at Nabble.com.
I'm working on a ZF-based application, and I've a problem... I'm using a layout to define my header/footer and a view printed using
"echo $this->layout()->content".
The problem is that in a controller, each page have the same structure and I want to create a layout for them. I can create a new layout but in its I have to write again my header/footer declarations, and I don't want because if I have to change one link, I will have to change in the both layouts.
So, my question is: is it possible to create a layout name "my_controller" within I'll user "echo $this->layout()->content" and my view will be printed in, and that my new layout takes place of the view in my main "layout" layout?
These files will be used to generate HTML of my pages:
layouts/layout.phtml > layouts/my_controller.phtml > views/my_action.phtml
Is it possible? If not, is it possible with another way?
Best regards,
Samuel ROZE.
AssetController:
$assets = $this->_model->getAllAssetsByClient($clientId);
$this->view->partialLoop()->setObjectKey('asset');
View assetRow (which is a partial)
<td><?php echo $this->asset->assetId ?></td>
<td><?php echo $this->asset->assetType ?></td>
<td><?php echo $this->asset->description ?></td>
<td><?php echo $this->asset->timestamp ?></td>
<td><?php echo $this->asset->getContent() ?></td>
And implementing Zend_Db_Table_Row_Abstract for Assets
public function getContent(){
$content = NULL;
$type = $this->assetType;
switch ($type) {
case 'photo':
$photosTable = new Application_Model_Table_Photo();
$photoRow =
$photosTable->fetchRow($photosTable->getDefaultAdapter()->quoteInto('assetId
= ?', $this->assetId));
$content = $photoRow->getThumbnail();
break;
case 'video':
$videosTable = new Application_Model_Table_Video();
$videosRow =
$videosTable->fetchRow($videosTable->getDefaultAdapter()->quoteInto('assetId
= ?', $this->assetId));
$content = $videosRow->getThumbnail();
break;
case 'text':
$textsTable = new Application_Model_Table_Text();
$textsRow =
$textsTable->fetchRow($textsTable->getDefaultAdapter()->quoteInto('assetId =
?', $this->assetId));
$content = $textsRow->content;
break;
}
return $content;
}
Regards
Kyle Schatzle
On Wed, Sep 22, 2010 at 11:58 PM, Bill Karwin <bill@karwin.com> wrote:
>
> On Sep 22, 2010, at 3:31 PM, kschatzle wrote:
>
> public function getAllAssetsByClientId() {
>>
>
> Wouldn't you want to pass a parameter for $clientId or something, so you
> could add it to the WHERE clause of your query?
>
>
> "assetId" should not be NULL in case 1 or 2 above.
>>
>
> This probably happens because your result set contains multiple columns of
> the same name (assetId), but with different values. The result set comes
> back as an associative array, and an assoc array can store only one value
> per key, so PDO overwrites the element of the array with the successive
> assetId columns. Of course, a.assetId is non-null and one other of
> t.assetId, p.assetId, and v.assetId is non-null. The others are null.
>
> Your solution is to list columns explicitly instead of relying on the
> default behavior of selecting "*" from each table. Unfortunately, SQL does
> not have a wildcard that means "all columns except assetId" so you'll have
> to list them all.
>
> Once you list the columns, you can either exclude duplicate columns so they
> aren't included in the query result set, or else alias them so they are
> included, but with a unique column name.
>
>
> $query = $this->select()
> ->setIntegrityCheck(false)
> ->from(array('a' => 'assets')) // this is okay to rely on "*"
> ->joinLeft(array('t' => 'texts') , 'a.assetId = t.assetId',
> array('textId', 'content'))
> ->joinLeft(array('p' => 'photos'), 'a.assetId = p.assetId',
> array('photoId', 'photoPath'=>'path', 'photoFileName'=>'fileName'))
> ->joinLeft(array('v' => 'videos'), 'a.assetId = v.assetId',
> array('videoId', 'videoPath'=>'path', 'videoFileName'=>'fileName'));
>
> I'm guessing that both photos and videos have columns path and fileName,
> and these need to be aliased so one doesn't overwrite the other.
>
> Regards,
> Bill Karwin
>
>
Second, knowing that these sorts of problems would occur, custom
adapters for Zend_Paginator were
designed to be quite simple to implement--just two methods. You could
probably mangle the query object in the adapter to achieve the desired
result.
Of these, the first is the best solution.
-Matt
On Saturday, September 18, 2010, patf <patfigel@gmail.com> wrote:
>
> Hi,
>
> emulating LIMIT and OFFSET for SQL Server is quite tricky.
> ZF generates the following SQL for SQL Server for limit=10 and offset=20:
>
> SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 30 "foobar".* FROM "foobar"
> ORDER BY "foobar" ASC) AS inner_tbl ORDER BY "foobar" DESC) AS outer_tbl
> ORDER BY "foobar" asc
>
> Though this will not work for the last result set ...
>
> This could be fixed in Sqlsrv Adapter by using MSSQL's ROW_NUMBER(), but
> there are two big problems with that solution:
> - ROW_NUMBER() was introduced with SQL Server 2005, so SQL Server 2000
> would no longer be supported by ZF.
> - ROW_NUMBER()'s performance is quite weak.
> Plus, the code in Zend_Db_Adapter_Sqlsrv::limit would get even weirder ...
>
> Perhaps you could create a new Paginator Adapter and write some ugly hacks
> to get this working, but I don't think it's worthwhile.
> --
> View this message in context: http://zend-framework-community.634137.n4.nabble.com/Issue-with-Zend-Db-Table-Select-Pagination-and-Sqlsrv-tp2544029p2545610.html
> Sent from the Zend DB mailing list archive at Nabble.com.
>
> public function getAllAssetsByClientId() {
Wouldn't you want to pass a parameter for $clientId or something, so
you could add it to the WHERE clause of your query?
> "assetId" should not be NULL in case 1 or 2 above.
This probably happens because your result set contains multiple
columns of the same name (assetId), but with different values. The
result set comes back as an associative array, and an assoc array can
store only one value per key, so PDO overwrites the element of the
array with the successive assetId columns. Of course, a.assetId is
non-null and one other of t.assetId, p.assetId, and v.assetId is non-
null. The others are null.
Your solution is to list columns explicitly instead of relying on the
default behavior of selecting "*" from each table. Unfortunately, SQL
does not have a wildcard that means "all columns except assetId" so
you'll have to list them all.
Once you list the columns, you can either exclude duplicate columns so
they aren't included in the query result set, or else alias them so
they are included, but with a unique column name.
$query = $this->select()
->setIntegrityCheck(false)
->from(array('a' => 'assets')) // this is okay to rely
on "*"
->joinLeft(array('t' => 'texts') , 'a.assetId =
t.assetId', array('textId', 'content'))
->joinLeft(array('p' => 'photos'), 'a.assetId =
p.assetId', array('photoId', 'photoPath'=>'path',
'photoFileName'=>'fileName'))
->joinLeft(array('v' => 'videos'), 'a.assetId =
v.assetId', array('videoId', 'videoPath'=>'path',
'videoFileName'=>'fileName'));
I'm guessing that both photos and videos have columns path and
fileName, and these need to be aliased so one doesn't overwrite the
other.
Regards,
Bill Karwin
I'm a heavy user of the Gdata API. I've made some changes to the
library code to access some new features (version 2) for my own needs.
But the modifications are ad hoc and incomplete i.e. not utilising all
of the API features.
As soon as I can get all the features done and the unit tests
completed, I'll be filing a bug report for the new features. Till
then, I won't be keeping my hopes high for the library to be updated.
Chua
On 23 September 2010 01:44, PaulG <foofoonet@gmail.com> wrote:
>
> I have searched here and other places and cannot find the answer to this
> question.
>
> The ZF Gdata 1.10.8 component appears to work as a wrapper for Google
> Calendar Data API version 1.0. Is there a plan to move to join Java and .Net
> in making a wrapper for Google Calendar Data API version 2.0 which supports
> all of the Atom implementation (as I understand it).
>
> If anyone can point me in the right direction to find the answer to that I'd
> be obliged.
>
> Paul
> --
> View this message in context: http://zend-framework-community.634137.n4.nabble.com/Google-Data-API-version-2-compatability-is-it-planned-tp2550756p2550756.html
> Sent from the Zend gdata mailing list archive at Nabble.com.
>
class Application_Model_Table_Asset extends Zend_Db_Table_Abstract {
protected $_name = "assets";
protected $_primary = "assetId";
protected $_sequence = true;
protected $_rowClass = "Application_Model_Table_Row_Asset";
public function getAllAssetsByClientId() {
$query = $this->select()
->setIntegrityCheck(false)
->from(array('a' => 'assets'))
->joinLeft(array('t' => 'texts') , 'a.assetId = t.assetId')
->joinLeft(array('p' => 'photos'), 'a.assetId = p.assetId')
->joinLeft(array('v' => 'videos'), 'a.assetId = v.assetId');
Zend_Debug::dump($query);
echo $query->__toString();
Zend_Debug::dump($assets);
return $this->fetchAll($query);
}
}
Here's a snippet of the dump:
Hello everyone. I'm fairly new to Zend Framework, so I hope I'm not missing
something ridiculous here. But I can't figure out what I'm doing wrong when
trying to left join multiple tables. Here's the class below. (I've omitted
other non-vital parts for now)
class Application_Model_Table_Asset extends Zend_Db_Table_Abstract {
protected $_name = "assets";
protected $_primary = "assetId";
protected $_sequence = true;
protected $_rowClass = "Application_Model_Table_Row_Asset";
public function getAllAssetsByClientId() {
$query = $this->select()
->setIntegrityCheck(false)
->from(array('a' => 'assets'))
->joinLeft(array('t' => 'texts') , 'a.assetId = t.assetId')
->joinLeft(array('p' => 'photos'), 'a.assetId = p.assetId')
->joinLeft(array('v' => 'videos'), 'a.assetId = v.assetId');
Zend_Debug::dump($query);
echo $query->__toString();
Zend_Debug::dump($assets);
return $this->fetchAll($query);
}
}
Here's a snippet of the dump:
[0] => array(11) {
["assetId"] => int(58)
["clientId"] => int(8)
["assetType"] => string(5) "video"
["description"] => string(5) "test3"
["timestamp"] => string(19) "2010-09-22 14:05:19"
["textId"] => NULL
["content"] => NULL
["photoId"] => NULL
["path"] => string(60)
"C:\wamp\www\vhosts\public\assets/client/8/video/"
["fileName"] => string(6) "58.flv"
["videoId"] => int(8)
}
[1] => array(11) {
["assetId"] => NULL
["clientId"] => int(8)
["assetType"] => string(5) "photo"
["description"] => string(5) "test2"
["timestamp"] => string(19) "2010-09-22 14:05:06"
["textId"] => NULL
["content"] => NULL
["photoId"] => int(14)
["path"] => NULL
["fileName"] => NULL
["videoId"] => NULL
}
[2] => array(11) {
["assetId"] => NULL
["clientId"] => int(8)
["assetType"] => string(4) "text"
["description"] => string(5) "test1"
["timestamp"] => string(19) "2010-09-22 13:41:34"
["textId"] => int(12)
["content"] => string(5) "test1"
["photoId"] => NULL
["path"] => NULL
["fileName"] => NULL
["videoId"] => NULL
}
"assetId" should not be NULL in case 1 or 2 above.
A quick copy from the "echo $query->__toString();" and paste to phpmyadmin
confirmed that it is indeed a good query. The data in phpmyadmin is exactly
what I would expect. Including the correct assetId's
//////////////////////////////////////////DATA
BELOW////////////////////////////////////////
object(Zend_Db_Table_Select)#88 (7) {
["_info":protected] => array(10) {
["schema"] => NULL
["name"] => string(6) "assets"
["cols"] => array(5) {
[0] => string(7) "assetId"
[1] => string(8) "clientId"
[2] => string(9) "assetType"
[3] => string(11) "description"
[4] => string(9) "timestamp"
}
["primary"] => array(1) {
[1] => string(7) "assetId"
}
["metadata"] => array(5) {
["assetId"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(7) "assetId"
["COLUMN_POSITION"] => int(1)
["DATA_TYPE"] => string(3) "int"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(true)
["PRIMARY_POSITION"] => int(1)
["IDENTITY"] => bool(true)
}
["clientId"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(8) "clientId"
["COLUMN_POSITION"] => int(2)
["DATA_TYPE"] => string(3) "int"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
["assetType"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(9) "assetType"
["COLUMN_POSITION"] => int(3)
["DATA_TYPE"] => string(28) "enum('text','video','photo')"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
["description"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(11) "description"
["COLUMN_POSITION"] => int(4)
["DATA_TYPE"] => string(7) "varchar"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => string(2) "50"
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
["timestamp"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(9) "timestamp"
["COLUMN_POSITION"] => int(5)
["DATA_TYPE"] => string(9) "timestamp"
["DEFAULT"] => string(17) "CURRENT_TIMESTAMP"
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
}
["rowClass"] => string(33) "Application_Model_Table_Row_Asset"
["rowsetClass"] => string(20) "Zend_Db_Table_Rowset"
["referenceMap"] => array(0) {
}
["dependentTables"] => array(0) {
}
["sequence"] => bool(true)
}
["_integrityCheck":protected] => bool(false)
["_table":protected] => object(Application_Model_Table_Asset)#73 (18) {
["_name":protected] => string(6) "assets"
["_primary":protected] => array(1) {
[1] => string(7) "assetId"
}
["_sequence":protected] => bool(true)
["_rowClass":protected] => string(33)
"Application_Model_Table_Row_Asset"
["_definition":protected] => NULL
["_definitionConfigName":protected] => NULL
["_db":protected] => object(Zend_Db_Adapter_Pdo_Mysql)#55 (12) {
["_pdoType":protected] => string(5) "mysql"
["_numericDataTypes":protected] => array(16) {
[0] => int(0)
[1] => int(1)
[2] => int(2)
["INT"] => int(0)
["INTEGER"] => int(0)
["MEDIUMINT"] => int(0)
["SMALLINT"] => int(0)
["TINYINT"] => int(0)
["BIGINT"] => int(1)
["SERIAL"] => int(1)
["DEC"] => int(2)
["DECIMAL"] => int(2)
["DOUBLE"] => int(2)
["DOUBLE PRECISION"] => int(2)
["FIXED"] => int(2)
["FLOAT"] => int(2)
}
["_defaultStmtClass":protected] => string(21) "Zend_Db_Statement_Pdo"
["_config":protected] => array(8) {
["dbname"] => string(8) "<deleted manually -KMS>"
["username"] => string(4) "<deleted manually -KMS>"
["password"] => string(0) "<deleted manually -KMS>"
["host"] => string(9) "<deleted manually -KMS>"
["charset"] => string(4) "UTF8"
["persistent"] => bool(false)
["options"] => array(2) {
["caseFolding"] => int(0)
["autoQuoteIdentifiers"] => bool(true)
}
["driver_options"] => array(1) {
[1002] => int(0)
}
}
["_fetchMode":protected] => int(2)
["_profiler":protected] => object(Zend_Db_Profiler)#56 (4) {
["_queryProfiles":protected] => array(0) {
}
["_enabled":protected] => bool(false)
["_filterElapsedSecs":protected] => NULL
["_filterTypes":protected] => NULL
}
["_defaultProfilerClass":protected] => string(16) "Zend_Db_Profiler"
["_connection":protected] => object(PDO)#87 (0) {
}
["_caseFolding":protected] => int(0)
["_autoQuoteIdentifiers":protected] => bool(true)
["_allowSerialization":protected] => bool(true)
["_autoReconnectOnUnserialize":protected] => bool(false)
}
["_schema":protected] => NULL
["_cols":protected] => array(5) {
[0] => string(7) "assetId"
[1] => string(8) "clientId"
[2] => string(9) "assetType"
[3] => string(11) "description"
[4] => string(9) "timestamp"
}
["_identity":protected] => int(1)
["_metadata":protected] => array(5) {
["assetId"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(7) "assetId"
["COLUMN_POSITION"] => int(1)
["DATA_TYPE"] => string(3) "int"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(true)
["PRIMARY_POSITION"] => int(1)
["IDENTITY"] => bool(true)
}
["clientId"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(8) "clientId"
["COLUMN_POSITION"] => int(2)
["DATA_TYPE"] => string(3) "int"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
["assetType"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(9) "assetType"
["COLUMN_POSITION"] => int(3)
["DATA_TYPE"] => string(28) "enum('text','video','photo')"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
["description"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(11) "description"
["COLUMN_POSITION"] => int(4)
["DATA_TYPE"] => string(7) "varchar"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => string(2) "50"
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
["timestamp"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(9) "timestamp"
["COLUMN_POSITION"] => int(5)
["DATA_TYPE"] => string(9) "timestamp"
["DEFAULT"] => string(17) "CURRENT_TIMESTAMP"
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
}
["_metadataCache":protected] => NULL
["_metadataCacheInClass":protected] => bool(true)
["_rowsetClass":protected] => string(20) "Zend_Db_Table_Rowset"
["_referenceMap":protected] => array(0) {
}
["_dependentTables":protected] => array(0) {
}
["_defaultSource":protected] => string(11) "defaultNone"
["_defaultValues":protected] => array(0) {
}
}
["_bind":protected] => array(0) {
}
["_adapter":protected] => object(Zend_Db_Adapter_Pdo_Mysql)#55 (12) {
["_pdoType":protected] => string(5) "mysql"
["_numericDataTypes":protected] => array(16) {
[0] => int(0)
[1] => int(1)
[2] => int(2)
["INT"] => int(0)
["INTEGER"] => int(0)
["MEDIUMINT"] => int(0)
["SMALLINT"] => int(0)
["TINYINT"] => int(0)
["BIGINT"] => int(1)
["SERIAL"] => int(1)
["DEC"] => int(2)
["DECIMAL"] => int(2)
["DOUBLE"] => int(2)
["DOUBLE PRECISION"] => int(2)
["FIXED"] => int(2)
["FLOAT"] => int(2)
}
["_defaultStmtClass":protected] => string(21) "Zend_Db_Statement_Pdo"
["_config":protected] => array(8) {
["dbname"] => string(8) "<deleted dbname manually -KMS>"
["username"] => string(4) "<deleted dbname manually -KMS>"
["password"] => string(0) "<deleted dbname manually -KMS>"
["host"] => string(9) "<deleted dbname manually -KMS>"
["charset"] => string(4) "UTF8"
["persistent"] => bool(false)
["options"] => array(2) {
["caseFolding"] => int(0)
["autoQuoteIdentifiers"] => bool(true)
}
["driver_options"] => array(1) {
[1002] => int(0)
}
}
["_fetchMode":protected] => int(2)
["_profiler":protected] => object(Zend_Db_Profiler)#56 (4) {
["_queryProfiles":protected] => array(0) {
}
["_enabled":protected] => bool(false)
["_filterElapsedSecs":protected] => NULL
["_filterTypes":protected] => NULL
}
["_defaultProfilerClass":protected] => string(16) "Zend_Db_Profiler"
["_connection":protected] => object(PDO)#87 (0) {
}
["_caseFolding":protected] => int(0)
["_autoQuoteIdentifiers":protected] => bool(true)
["_allowSerialization":protected] => bool(true)
["_autoReconnectOnUnserialize":protected] => bool(false)
}
["_parts":protected] => array(11) {
["distinct"] => bool(false)
["columns"] => array(4) {
[0] => array(3) {
[0] => string(1) "a"
[1] => string(1) "*"
[2] => NULL
}
[1] => array(3) {
[0] => string(1) "t"
[1] => string(1) "*"
[2] => NULL
}
[2] => array(3) {
[0] => string(1) "p"
[1] => string(1) "*"
[2] => NULL
}
[3] => array(3) {
[0] => string(1) "v"
[1] => string(1) "*"
[2] => NULL
}
}
["union"] => array(0) {
}
["from"] => array(4) {
["a"] => array(4) {
["joinType"] => string(10) "inner join"
["schema"] => NULL
["tableName"] => string(6) "assets"
["joinCondition"] => NULL
}
["t"] => array(4) {
["joinType"] => string(9) "left join"
["schema"] => NULL
["tableName"] => string(5) "texts"
["joinCondition"] => string(21) "a.assetId = t.assetId"
}
["p"] => array(4) {
["joinType"] => string(9) "left join"
["schema"] => NULL
["tableName"] => string(6) "photos"
["joinCondition"] => string(21) "a.assetId = p.assetId"
}
["v"] => array(4) {
["joinType"] => string(9) "left join"
["schema"] => NULL
["tableName"] => string(6) "videos"
["joinCondition"] => string(21) "a.assetId = v.assetId"
}
}
["where"] => array(0) {
}
["group"] => array(0) {
}
["having"] => array(0) {
}
["order"] => array(0) {
}
["limitcount"] => NULL
["limitoffset"] => NULL
["forupdate"] => bool(false)
}
["_tableCols":protected] => array(0) {
}
}
SELECT `a`.*, `t`.*, `p`.*, `v`.*
FROM `assets` AS `a`
LEFT JOIN `texts` AS `t` ON a.assetId = t.assetId
LEFT JOIN `photos` AS `p` ON a.assetId = p.assetId
LEFT JOIN `videos` AS `v` ON a.assetId = v.assetId
object(Zend_Db_Table_Rowset)#72 (10) {
["_data":protected] => array(3) {
[0] => array(11) {
["assetId"] => int(58)
["clientId"] => int(8)
["assetType"] => string(5) "video"
["description"] => string(5) "test3"
["timestamp"] => string(19) "2010-09-22 14:05:19"
["textId"] => NULL
["content"] => NULL
["photoId"] => NULL
["path"] => string(60)
"C:\wamp\www\vhosts\public\assets/client/8/video/"
["fileName"] => string(6) "58.flv"
["videoId"] => int(8)
}
[1] => array(11) {
["assetId"] => NULL
["clientId"] => int(8)
["assetType"] => string(5) "photo"
["description"] => string(5) "test2"
["timestamp"] => string(19) "2010-09-22 14:05:06"
["textId"] => NULL
["content"] => NULL
["photoId"] => int(14)
["path"] => NULL
["fileName"] => NULL
["videoId"] => NULL
}
[2] => array(11) {
["assetId"] => NULL
["clientId"] => int(8)
["assetType"] => string(4) "text"
["description"] => string(5) "test1"
["timestamp"] => string(19) "2010-09-22 13:41:34"
["textId"] => int(12)
["content"] => string(5) "test1"
["photoId"] => NULL
["path"] => NULL
["fileName"] => NULL
["videoId"] => NULL
}
"assetId" should not be NULL in either case! (note that the
A quick copy and paste from the "echo $query->__toString();" to phpmyadmin
confirmed that it is indeed a good query. The data in phpmyadmin is exactly
what I would expect.
Every table should have an assetId, clientId, description, and timestamp.
The rest of the data could be null.
The database schema is fairly easy. I have an 'assets' table that has a
one-to-one relationship to either a 'photo', 'video', or 'text' table.
//////////////////////////////////////////DATA
BELOW////////////////////////////////////////
object(Zend_Db_Table_Select)#88 (7) {
["_info":protected] => array(10) {
["schema"] => NULL
["name"] => string(6) "assets"
["cols"] => array(5) {
[0] => string(7) "assetId"
[1] => string(8) "clientId"
[2] => string(9) "assetType"
[3] => string(11) "description"
[4] => string(9) "timestamp"
}
["primary"] => array(1) {
[1] => string(7) "assetId"
}
["metadata"] => array(5) {
["assetId"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(7) "assetId"
["COLUMN_POSITION"] => int(1)
["DATA_TYPE"] => string(3) "int"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(true)
["PRIMARY_POSITION"] => int(1)
["IDENTITY"] => bool(true)
}
["clientId"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(8) "clientId"
["COLUMN_POSITION"] => int(2)
["DATA_TYPE"] => string(3) "int"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
["assetType"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(9) "assetType"
["COLUMN_POSITION"] => int(3)
["DATA_TYPE"] => string(28) "enum('text','video','photo')"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
["description"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(11) "description"
["COLUMN_POSITION"] => int(4)
["DATA_TYPE"] => string(7) "varchar"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => string(2) "50"
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
["timestamp"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(9) "timestamp"
["COLUMN_POSITION"] => int(5)
["DATA_TYPE"] => string(9) "timestamp"
["DEFAULT"] => string(17) "CURRENT_TIMESTAMP"
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
}
["rowClass"] => string(33) "Application_Model_Table_Row_Asset"
["rowsetClass"] => string(20) "Zend_Db_Table_Rowset"
["referenceMap"] => array(0) {
}
["dependentTables"] => array(0) {
}
["sequence"] => bool(true)
}
["_integrityCheck":protected] => bool(false)
["_table":protected] => object(Application_Model_Table_Asset)#73 (18) {
["_name":protected] => string(6) "assets"
["_primary":protected] => array(1) {
[1] => string(7) "assetId"
}
["_sequence":protected] => bool(true)
["_rowClass":protected] => string(33)
"Application_Model_Table_Row_Asset"
["_definition":protected] => NULL
["_definitionConfigName":protected] => NULL
["_db":protected] => object(Zend_Db_Adapter_Pdo_Mysql)#55 (12) {
["_pdoType":protected] => string(5) "mysql"
["_numericDataTypes":protected] => array(16) {
[0] => int(0)
[1] => int(1)
[2] => int(2)
["INT"] => int(0)
["INTEGER"] => int(0)
["MEDIUMINT"] => int(0)
["SMALLINT"] => int(0)
["TINYINT"] => int(0)
["BIGINT"] => int(1)
["SERIAL"] => int(1)
["DEC"] => int(2)
["DECIMAL"] => int(2)
["DOUBLE"] => int(2)
["DOUBLE PRECISION"] => int(2)
["FIXED"] => int(2)
["FLOAT"] => int(2)
}
["_defaultStmtClass":protected] => string(21) "Zend_Db_Statement_Pdo"
["_config":protected] => array(8) {
["dbname"] => string(8) "<deleted manually -KMS>"
["username"] => string(4) "<deleted manually -KMS>"
["password"] => string(0) "<deleted manually -KMS>"
["host"] => string(9) "<deleted manually -KMS>"
["charset"] => string(4) "UTF8"
["persistent"] => bool(false)
["options"] => array(2) {
["caseFolding"] => int(0)
["autoQuoteIdentifiers"] => bool(true)
}
["driver_options"] => array(1) {
[1002] => int(0)
}
}
["_fetchMode":protected] => int(2)
["_profiler":protected] => object(Zend_Db_Profiler)#56 (4) {
["_queryProfiles":protected] => array(0) {
}
["_enabled":protected] => bool(false)
["_filterElapsedSecs":protected] => NULL
["_filterTypes":protected] => NULL
}
["_defaultProfilerClass":protected] => string(16) "Zend_Db_Profiler"
["_connection":protected] => object(PDO)#87 (0) {
}
["_caseFolding":protected] => int(0)
["_autoQuoteIdentifiers":protected] => bool(true)
["_allowSerialization":protected] => bool(true)
["_autoReconnectOnUnserialize":protected] => bool(false)
}
["_schema":protected] => NULL
["_cols":protected] => array(5) {
[0] => string(7) "assetId"
[1] => string(8) "clientId"
[2] => string(9) "assetType"
[3] => string(11) "description"
[4] => string(9) "timestamp"
}
["_identity":protected] => int(1)
["_metadata":protected] => array(5) {
["assetId"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(7) "assetId"
["COLUMN_POSITION"] => int(1)
["DATA_TYPE"] => string(3) "int"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(true)
["PRIMARY_POSITION"] => int(1)
["IDENTITY"] => bool(true)
}
["clientId"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(8) "clientId"
["COLUMN_POSITION"] => int(2)
["DATA_TYPE"] => string(3) "int"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
["assetType"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(9) "assetType"
["COLUMN_POSITION"] => int(3)
["DATA_TYPE"] => string(28) "enum('text','video','photo')"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
["description"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(11) "description"
["COLUMN_POSITION"] => int(4)
["DATA_TYPE"] => string(7) "varchar"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => string(2) "50"
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
["timestamp"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(9) "timestamp"
["COLUMN_POSITION"] => int(5)
["DATA_TYPE"] => string(9) "timestamp"
["DEFAULT"] => string(17) "CURRENT_TIMESTAMP"
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
}
["_metadataCache":protected] => NULL
["_metadataCacheInClass":protected] => bool(true)
["_rowsetClass":protected] => string(20) "Zend_Db_Table_Rowset"
["_referenceMap":protected] => array(0) {
}
["_dependentTables":protected] => array(0) {
}
["_defaultSource":protected] => string(11) "defaultNone"
["_defaultValues":protected] => array(0) {
}
}
["_bind":protected] => array(0) {
}
["_adapter":protected] => object(Zend_Db_Adapter_Pdo_Mysql)#55 (12) {
["_pdoType":protected] => string(5) "mysql"
["_numericDataTypes":protected] => array(16) {
[0] => int(0)
[1] => int(1)
[2] => int(2)
["INT"] => int(0)
["INTEGER"] => int(0)
["MEDIUMINT"] => int(0)
["SMALLINT"] => int(0)
["TINYINT"] => int(0)
["BIGINT"] => int(1)
["SERIAL"] => int(1)
["DEC"] => int(2)
["DECIMAL"] => int(2)
["DOUBLE"] => int(2)
["DOUBLE PRECISION"] => int(2)
["FIXED"] => int(2)
["FLOAT"] => int(2)
}
["_defaultStmtClass":protected] => string(21) "Zend_Db_Statement_Pdo"
["_config":protected] => array(8) {
["dbname"] => string(8) "<deleted dbname manually -KMS>"
["username"] => string(4) "<deleted dbname manually -KMS>"
["password"] => string(0) "<deleted dbname manually -KMS>"
["host"] => string(9) "<deleted dbname manually -KMS>"
["charset"] => string(4) "UTF8"
["persistent"] => bool(false)
["options"] => array(2) {
["caseFolding"] => int(0)
["autoQuoteIdentifiers"] => bool(true)
}
["driver_options"] => array(1) {
[1002] => int(0)
}
}
["_fetchMode":protected] => int(2)
["_profiler":protected] => object(Zend_Db_Profiler)#56 (4) {
["_queryProfiles":protected] => array(0) {
}
["_enabled":protected] => bool(false)
["_filterElapsedSecs":protected] => NULL
["_filterTypes":protected] => NULL
}
["_defaultProfilerClass":protected] => string(16) "Zend_Db_Profiler"
["_connection":protected] => object(PDO)#87 (0) {
}
["_caseFolding":protected] => int(0)
["_autoQuoteIdentifiers":protected] => bool(true)
["_allowSerialization":protected] => bool(true)
["_autoReconnectOnUnserialize":protected] => bool(false)
}
["_parts":protected] => array(11) {
["distinct"] => bool(false)
["columns"] => array(4) {
[0] => array(3) {
[0] => string(1) "a"
[1] => string(1) "*"
[2] => NULL
}
[1] => array(3) {
[0] => string(1) "t"
[1] => string(1) "*"
[2] => NULL
}
[2] => array(3) {
[0] => string(1) "p"
[1] => string(1) "*"
[2] => NULL
}
[3] => array(3) {
[0] => string(1) "v"
[1] => string(1) "*"
[2] => NULL
}
}
["union"] => array(0) {
}
["from"] => array(4) {
["a"] => array(4) {
["joinType"] => string(10) "inner join"
["schema"] => NULL
["tableName"] => string(6) "assets"
["joinCondition"] => NULL
}
["t"] => array(4) {
["joinType"] => string(9) "left join"
["schema"] => NULL
["tableName"] => string(5) "texts"
["joinCondition"] => string(21) "a.assetId = t.assetId"
}
["p"] => array(4) {
["joinType"] => string(9) "left join"
["schema"] => NULL
["tableName"] => string(6) "photos"
["joinCondition"] => string(21) "a.assetId = p.assetId"
}
["v"] => array(4) {
["joinType"] => string(9) "left join"
["schema"] => NULL
["tableName"] => string(6) "videos"
["joinCondition"] => string(21) "a.assetId = v.assetId"
}
}
["where"] => array(0) {
}
["group"] => array(0) {
}
["having"] => array(0) {
}
["order"] => array(0) {
}
["limitcount"] => NULL
["limitoffset"] => NULL
["forupdate"] => bool(false)
}
["_tableCols":protected] => array(0) {
}
}
SELECT `a`.*, `t`.*, `p`.*, `v`.*
FROM `assets` AS `a`
LEFT JOIN `texts` AS `t` ON a.assetId = t.assetId
LEFT JOIN `photos` AS `p` ON a.assetId = p.assetId
LEFT JOIN `videos` AS `v` ON a.assetId = v.assetId
object(Zend_Db_Table_Rowset)#72 (10) {
["_data":protected] => array(3) {
[0] => array(11) {
["assetId"] => int(58)
["clientId"] => int(8)
["assetType"] => string(5) "video"
["description"] => string(5) "test3"
["timestamp"] => string(19) "2010-09-22 14:05:19"
["textId"] => NULL
["content"] => NULL
["photoId"] => NULL
["path"] => string(60)
"C:\wamp\www\vhosts\public\assets/client/8/video/"
["fileName"] => string(6) "58.flv"
["videoId"] => int(8)
}
[1] => array(11) {
["assetId"] => NULL
["clientId"] => int(8)
["assetType"] => string(5) "photo"
["description"] => string(5) "test2"
["timestamp"] => string(19) "2010-09-22 14:05:06"
["textId"] => NULL
["content"] => NULL
["photoId"] => int(14)
["path"] => NULL
["fileName"] => NULL
["videoId"] => NULL
}
[2] => array(11) {
["assetId"] => NULL
["clientId"] => int(8)
["assetType"] => string(4) "text"
["description"] => string(5) "test1"
["timestamp"] => string(19) "2010-09-22 13:41:34"
["textId"] => int(12)
["content"] => string(5) "test1"
["photoId"] => NULL
["path"] => NULL
["fileName"] => NULL
["videoId"] => NULL
}
}
["_table":protected] => object(Application_Model_Table_Asset)#73 (18) {
["_name":protected] => string(6) "assets"
["_primary":protected] => array(1) {
[1] => string(7) "assetId"
}
["_sequence":protected] => bool(true)
["_rowClass":protected] => string(33)
"Application_Model_Table_Row_Asset"
["_definition":protected] => NULL
["_definitionConfigName":protected] => NULL
["_db":protected] => object(Zend_Db_Adapter_Pdo_Mysql)#55 (12) {
["_pdoType":protected] => string(5) "mysql"
["_numericDataTypes":protected] => array(16) {
[0] => int(0)
[1] => int(1)
[2] => int(2)
["INT"] => int(0)
["INTEGER"] => int(0)
["MEDIUMINT"] => int(0)
["SMALLINT"] => int(0)
["TINYINT"] => int(0)
["BIGINT"] => int(1)
["SERIAL"] => int(1)
["DEC"] => int(2)
["DECIMAL"] => int(2)
["DOUBLE"] => int(2)
["DOUBLE PRECISION"] => int(2)
["FIXED"] => int(2)
["FLOAT"] => int(2)
}
["_defaultStmtClass":protected] => string(21) "Zend_Db_Statement_Pdo"
["_config":protected] => array(8) {
["dbname"] => string(8) "<deleted dbname manually -KMS>"
["username"] => string(4) "<deleted dbname manually -KMS>"
["password"] => string(0) "<deleted dbname manually -KMS>"
["host"] => string(9) "<deleted dbname manually -KMS>"
["charset"] => string(4) "UTF8"
["persistent"] => bool(false)
["options"] => array(2) {
["caseFolding"] => int(0)
["autoQuoteIdentifiers"] => bool(true)
}
["driver_options"] => array(1) {
[1002] => int(0)
}
}
["_fetchMode":protected] => int(2)
["_profiler":protected] => object(Zend_Db_Profiler)#56 (4) {
["_queryProfiles":protected] => array(0) {
}
["_enabled":protected] => bool(false)
["_filterElapsedSecs":protected] => NULL
["_filterTypes":protected] => NULL
}
["_defaultProfilerClass":protected] => string(16) "Zend_Db_Profiler"
["_connection":protected] => object(PDO)#87 (0) {
}
["_caseFolding":protected] => int(0)
["_autoQuoteIdentifiers":protected] => bool(true)
["_allowSerialization":protected] => bool(true)
["_autoReconnectOnUnserialize":protected] => bool(false)
}
["_schema":protected] => NULL
["_cols":protected] => array(5) {
[0] => string(7) "assetId"
[1] => string(8) "clientId"
[2] => string(9) "assetType"
[3] => string(11) "description"
[4] => string(9) "timestamp"
}
["_identity":protected] => int(1)
["_metadata":protected] => array(5) {
["assetId"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(7) "assetId"
["COLUMN_POSITION"] => int(1)
["DATA_TYPE"] => string(3) "int"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(true)
["PRIMARY_POSITION"] => int(1)
["IDENTITY"] => bool(true)
}
["clientId"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(8) "clientId"
["COLUMN_POSITION"] => int(2)
["DATA_TYPE"] => string(3) "int"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
["assetType"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(9) "assetType"
["COLUMN_POSITION"] => int(3)
["DATA_TYPE"] => string(28) "enum('text','video','photo')"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
["description"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(11) "description"
["COLUMN_POSITION"] => int(4)
["DATA_TYPE"] => string(7) "varchar"
["DEFAULT"] => NULL
["NULLABLE"] => bool(false)
["LENGTH"] => string(2) "50"
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
["timestamp"] => array(14) {
["SCHEMA_NAME"] => NULL
["TABLE_NAME"] => string(6) "assets"
["COLUMN_NAME"] => string(9) "timestamp"
["COLUMN_POSITION"] => int(5)
["DATA_TYPE"] => string(9) "timestamp"
["DEFAULT"] => string(17) "CURRENT_TIMESTAMP"
["NULLABLE"] => bool(false)
["LENGTH"] => NULL
["SCALE"] => NULL
["PRECISION"] => NULL
["UNSIGNED"] => NULL
["PRIMARY"] => bool(false)
["PRIMARY_POSITION"] => NULL
["IDENTITY"] => bool(false)
}
}
["_metadataCache":protected] => NULL
["_metadataCacheInClass":protected] => bool(true)
["_rowsetClass":protected] => string(20) "Zend_Db_Table_Rowset"
["_referenceMap":protected] => array(0) {
}
["_dependentTables":protected] => array(0) {
}
["_defaultSource":protected] => string(11) "defaultNone"
["_defaultValues":protected] => array(0) {
}
}
["_connected":protected] => bool(true)
["_tableClass":protected] => string(29) "Application_Model_Table_Asset"
["_rowClass":protected] => string(33) "Application_Model_Table_Row_Asset"
["_pointer":protected] => int(0)
["_count":protected] => int(3)
["_rows":protected] => array(0) {
}
["_stored":protected] => bool(true)
["_readOnly":protected] => bool(false)
}
--
View this message in context: http://zend-framework-community.634137.n4.nabble.com/Help-With-Multitable-Left-Joins-tp2551174p2551174.html
Sent from the Zend DB mailing list archive at Nabble.com.
The ZF Gdata 1.10.8 component appears to work as a wrapper for Google
Calendar Data API version 1.0. Is there a plan to move to join Java and .Net
in making a wrapper for Google Calendar Data API version 2.0 which supports
all of the Atom implementation (as I understand it).
If anyone can point me in the right direction to find the answer to that I'd
be obliged.
Paul
--
View this message in context: http://zend-framework-community.634137.n4.nabble.com/Google-Data-API-version-2-compatability-is-it-planned-tp2550756p2550756.html
Sent from the Zend gdata mailing list archive at Nabble.com.
Fatal error: Zend\Controller\Router\Exception: Route default is not defined
in D:\...\library\Zend\View\Helper\Navigation\AbstractHelper.php on line 524
I just figured out now that it's because the default route has been renamed
from "default" to "application" in ZF2.
Thanks for your help. :-)
--
View this message in context: http://zend-framework-community.634137.n4.nabble.com/Issue-with-Zend-Navigation-and-redirecting-from-a-controller-plug-in-tp2548673p2549344.html
Sent from the Zend MVC mailing list archive at Nabble.com.
--
*Hector Virgen*
Sr. Web Developer
Walt Disney Parks and Resorts Online
http://www.virgentech.com
On Tue, Sep 21, 2010 at 6:56 AM, darkangel <glen.84@gmail.com> wrote:
>
> Hi,
>
> I have a controller plug-in that performs access control. When access is
> denied (and the user is not logged in), I redirect to /login. The problem
> is, my Zend_Navigation links then all point to /login for some reason on
> that page.
>
> Does anyone know why this is happening?
>
> _da.
> --
> View this message in context:
> http://zend-framework-community.634137.n4.nabble.com/Issue-with-Zend-Navigation-and-redirecting-from-a-controller-plug-in-tp2548673p2548673.html
> Sent from the Zend MVC mailing list archive at Nabble.com.
>
>
if you are using Zend_Auth_Adapter_DbTable, just try this one:
$authAdapter = new Zend_Auth_Adapter_DbTable(
$dbAdapter,
'usertable',
new Zend_Db_Expr('LOWER(username)'),
'password'
);
$authAdapter
->setIdentity(strtolower($this->_getParam('username'))
->setCredential($this->_getParam('password'));
--
________________
Sincerely
Sina Miandashti
MuSicBasE.ir & InvisionPower.ir Admin
--
*Hector Virgen*
Sr. Web Developer
Walt Disney Parks and Resorts Online
http://www.virgentech.com
On Tue, Sep 21, 2010 at 8:31 AM, sina miandashti <miandashti@gmail.com>wrote:
> Works Under Ubeckers Solution
>
>
> thanks both u and dear hector :)
>
>
> --
> ________________
> Sincerely
> Sina Miandashti
> MuSicBasE.ir & InvisionPower.ir Admin
>
thanks both u and dear hector :)
--
________________
Sincerely
Sina Miandashti
MuSicBasE.ir & InvisionPower.ir Admin
Have you tried your question at the Zend Forums? This is one is specific
to Zend Framework. You might have better luck over here:
In the Zend Server Community Edition section.
Cheers,
-ralph
On 9/21/10 8:53 AM, Lionel Morrison wrote:
> I would appreciate the forums response on this as I spent all of
> yesterday until about 3am this morning trying to get Zend Server CE
> installed on the same server as Cold Fusion 8. The end result is that
> when you ask for a PHP page it askes you what you want to do with it
> just like you were downloading a ZIP file.
>
> Here is where I think the issue is. I believe that the issue is with
> FastCGI. I got the PHP/CF8 working. Then installed FastCGI and ISAPI
> Rewrite and then the whole thing came to its knees. I was able to
> replicate this issue on 2 different servers.
>
> I would like to install Apache but you know how the world fears
> something it doesn't understand!
>
> Anyway, comments, suggestions, public opinion welcome. I'm at an impasse
> and I could do with the expertise of a PHP community.
>
>
> Thanks
> Lionel
>
>
> Config:
> Windows 2003 x86 & x64 (Service packed)
> Zend Server CE 5.3 and 5.2
> FastCGI (Microsoft)
> ISAPI Rewrite 3
> IIS 6
>
>
>
>
>
>
> On 9/20/10 4:01 PM, Lionel Morrison wrote:
>> Does anyone have the answer to which ISAPI web service extensions to
>> allow in IIS6. I have all unknown extensions set to allow in my dev
>> environemnt but that will not be suitable for production.
>>
>> I don't have fast-cgi installed and this is an out of the box install
>> of Zend Server CE 5.0.3
>>
>>
>> Thanks
>> Lionel
>>
>
>
--
Hector Virgen
Sent from my Droid X
On Sep 21, 2010 6:32 AM, "sina miandashti" <miandashti@gmail.com> wrote:
> its already latin1_swedish_ci
>
> :(
>
> what should i do?
>
> --
> ________________
> Sincerely
> Sina Miandashti
> MuSicBasE.ir & InvisionPower.ir Admin
I have a controller plug-in that performs access control. When access is
denied (and the user is not logged in), I redirect to /login. The problem
is, my Zend_Navigation links then all point to /login for some reason on
that page.
Does anyone know why this is happening?
_da.
--
View this message in context: http://zend-framework-community.634137.n4.nabble.com/Issue-with-Zend-Navigation-and-redirecting-from-a-controller-plug-in-tp2548673p2548673.html
Sent from the Zend MVC mailing list archive at Nabble.com.
Here is where I think the issue is. I believe that the issue is with
FastCGI. I got the PHP/CF8 working. Then installed FastCGI and ISAPI
Rewrite and then the whole thing came to its knees. I was able to
replicate this issue on 2 different servers.
I would like to install Apache but you know how the world fears
something it doesn't understand!
Anyway, comments, suggestions, public opinion welcome. I'm at an impasse
and I could do with the expertise of a PHP community.
Thanks
Lionel
Config:
Windows 2003 x86 & x64 (Service packed)
Zend Server CE 5.3 and 5.2
FastCGI (Microsoft)
ISAPI Rewrite 3
IIS 6
On 9/20/10 4:01 PM, Lionel Morrison wrote:
> Does anyone have the answer to which ISAPI web service extensions to
> allow in IIS6. I have all unknown extensions set to allow in my dev
> environemnt but that will not be suitable for production.
>
> I don't have fast-cgi installed and this is an out of the box install
> of Zend Server CE 5.0.3
>
>
> Thanks
> Lionel
>
:(
what should i do?
--
________________
Sincerely
Sina Miandashti
MuSicBasE.ir & InvisionPower.ir Admin
--
Hector Virgen
Sent from my Droid X
On Sep 20, 2010 10:35 PM, "sina miandashti" <miandashti@gmail.com> wrote:
> hi all zend developers
>
> im using zend_auth for auth stuff of my application
>
> i wanna disable the case sensitive check for usernames in zend_auth
>
> for ex. USERNAME = username = UserName = useRnAme
>
> ?
>
> --
> ________________
> Sincerely
> Sina Miandashti
> MuSicBasE.ir & InvisionPower.ir Admin
im using zend_auth for auth stuff of my application
i wanna disable the case sensitive check for usernames in zend_auth
for ex. USERNAME = username = UserName = useRnAme
?
--
________________
Sincerely
Sina Miandashti
MuSicBasE.ir & InvisionPower.ir Admin
I don't have fast-cgi installed and this is an out of the box install of
Zend Server CE 5.0.3
Thanks
Lionel
emulating LIMIT and OFFSET for SQL Server is quite tricky.
ZF generates the following SQL for SQL Server for limit=10 and offset=20:
SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 30 "foobar".* FROM "foobar"
ORDER BY "foobar" ASC) AS inner_tbl ORDER BY "foobar" DESC) AS outer_tbl
ORDER BY "foobar" asc
Though this will not work for the last result set ...
This could be fixed in Sqlsrv Adapter by using MSSQL's ROW_NUMBER(), but
there are two big problems with that solution:
- ROW_NUMBER() was introduced with SQL Server 2005, so SQL Server 2000
would no longer be supported by ZF.
- ROW_NUMBER()'s performance is quite weak.
Plus, the code in Zend_Db_Adapter_Sqlsrv::limit would get even weirder ...
Perhaps you could create a new Paginator Adapter and write some ugly hacks
to get this working, but I don't think it's worthwhile.
--
View this message in context: http://zend-framework-community.634137.n4.nabble.com/Issue-with-Zend-Db-Table-Select-Pagination-and-Sqlsrv-tp2544029p2545610.html
Sent from the Zend DB mailing list archive at Nabble.com.
I have previously used a Zend_Db_Table_Select object for pagination with
MySQL and Postgresql with great success. And now that I am forced to work
on this project in SQL Server 2008, using the Microsoft-provided Sqlsrv
drivers for PHP on Windows, I am coming across an interesting issue. The
pagination is "working", as I see the appropriate links where I should, the
proper number of items are displayed per page, etc. However, on the last
page, I am seeing the maximum number of items, even though some of them
appeared on the next-to-last page. For example: I have a table with 22
rows, and I have it set to display 10 rows per page. The first two pages
will show 1-10, then 11-20, but then the 3rd page shows 10 records (numbered
21-30), even though there are only 22 records. The last two items on the
last page are the only ones that should be showing up, as the first 8 were
already displayed on the previous page. This has caused a great amount of
confusion to my users. They are asking why there are 30 records shown, when
there's only 22 in the database. I have been forced to change my pagination
method to use an Array, thereby losing all of the benefits that I really
need.
To confirm this only happens with SQL Server, I created an identical table
in MySQL and copied all the data over. I changed my config.ini to point to
the MySQL server, and everything displays as it should.
Is this because of the fact that SQL Server doesn't support LIMIT the same
way as MySQL and Postgresql? I was under the impression that the Zend_Db
adapter would mimic this functionality for SQL Server.
Thanks in advance,
Joey
--
View this message in context: http://zend-framework-community.634137.n4.nabble.com/Issue-with-Zend-Db-Table-Select-Pagination-and-Sqlsrv-tp2544029p2544029.html
Sent from the Zend DB mailing list archive at Nabble.com.
-- Hector Virgen <djvirgen@gmail.com> wrote
(on Thursday, 16 September 2010, 02:00 PM -0700):
> Can someone please unsubscribe Bank of America? Thanks :)
>
> --
> Hector Virgen
> Sent from my Droid X
>
> ---------- Forwarded message ----------
> From: "online" <online@bankofamerica.com>
> Date: Sep 16, 2010 1:37 PM
> Subject: Re: [fw-mvc] Deploying Zend Application (KMM116055210I91L0KM)
> To: "Hector Virgen" <djvirgen@gmail.com>
>
> Dear Hector Virgen,
>
> Thank you for your inquiry dated 09/16/2010 regarding webserver. We are
> committed to providing you with the best banking experience possible and
> we will be happy to assist you.
>
> While we make every effort to assist our customers who contact us by
> e-mail, there are certain situations which require a conversation with
> an account specialist. To provide you with the most accurate and
> efficient service, we ask that you contact Customer Service department
> at 1.800.432.1000 from 7 a.m. to 10 p.m. Monday to Friday and 8 a.m. to
> 5 p.m. Saturdays and Sundays.
>
> Please be assured that we know your time is valuable and would not
> direct you to contact us by telephone unless absolutely necessary like
> it is in this case.
>
> We apologize for any inconvenience this may have caused. We value you as
> a customer and appreciate your business. If we may be of further
> assistance, please contact us again by e-mail. Thank you for choosing
> Bank of America.
>
>
> Sincerely,
>
> Rene Hermosillo
> Bank of America
>
>
> This message is in response to your recent request. If you are not the
> addressee please contact us. Any reply to this e-mail will not be
> secure; please do not respond with personal or confidential information.
>
--
Matthew Weier O'Phinney
Project Lead | matthew@zend.com
Zend Framework | http://framework.zend.com/
PGP key: http://framework.zend.com/zf-matthew-pgp-key.asc
Not sure, but sometimes when I reply to ZF messages I get this auto-responder from BofA's CS dept.
--
Hector VirgenSr. Web DeveloperWalt Disney Parks and Resorts Online
On Thu, Sep 16, 2010 at 6:10 PM, Abraham Block <atblock@gmail.com> wrote:how did you manage this exactly?On Thu, Sep 16, 2010 at 5:00 PM, Hector Virgen <djvirgen@gmail.com> wrote:
Can someone please unsubscribe Bank of America? Thanks :)
--
Hector Virgen
Sent from my Droid X---------- Forwarded message ----------
From: "online" <online@bankofamerica.com>
Date: Sep 16, 2010 1:37 PM
Subject: Re: [fw-mvc] Deploying Zend Application (KMM116055210I91L0KM)
To: "Hector Virgen" <djvirgen@gmail.com>
Dear Hector Virgen,
Thank you for your inquiry dated 09/16/2010 regarding webserver. We are
committed to providing you with the best banking experience possible and
we will be happy to assist you.
While we make every effort to assist our customers who contact us by
e-mail, there are certain situations which require a conversation with
an account specialist. To provide you with the most accurate and
efficient service, we ask that you contact Customer Service department
at 1.800.432.1000 from 7 a.m. to 10 p.m. Monday to Friday and 8 a.m. to
5 p.m. Saturdays and Sundays.
Please be assured that we know your time is valuable and would not
direct you to contact us by telephone unless absolutely necessary like
it is in this case.
We apologize for any inconvenience this may have caused. We value you as
a customer and appreciate your business. If we may be of further
assistance, please contact us again by e-mail. Thank you for choosing
Bank of America.
Sincerely,
Rene Hermosillo
Bank of America
This message is in response to your recent request. If you are not the
addressee please contact us. Any reply to this e-mail will not be
secure; please do not respond with personal or confidential information.
