I have two database users and magento. magento is reside at remote machine in LAN. and users is reside at my local machine.
connection between them and fetching data from that magento database is working fine but I want to do pagination on magento's table data. simple displaying it is done, but for pagination we require model name, and how can i have model of other database?? // in controller action $this->Vendor->changeDataSource('vsdatabase'); if($this->changeDbSource('vsdatabase')) { $magento_data = $this->Vendor->query("SELECT * from admin_user"); $this->set('products',$magento_data); } and changeDataSource($newdb) is defined in model file and changeDbSource($database='default') in controller so how can I solve my problem with pagination? I have completed fetching data without pagination. or any other option to do this? Thanks, -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php