Not sure how cake handles this, but maybe you can workaround this issue by creating a synonym in your cake schema to OCD.MACHINES?
create synonym machines for ocd.machines / On Jul 29, 9:56 am, pete123456 <[email protected]> wrote: > Hi, > i im trying to query a table from "other users". is there a way to use the > "find()" instead of doing a custom query. > > thanks > > pete > > WORKS > $this->set('machines', $this->Machine->query("SELECT * FROM OCD.MACHINES")); > > ??? // not working because of the missing user "OCD" > $this->set('machines', $this->Machine->find('all')); > -- > View this message in > context:http://www.nabble.com/oracle-%22find%28%29%22-tp24711573p24711573.html > Sent from the CakePHP mailing list archive at Nabble.com. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
