Nice to know that after such a long time someone is there to help... I will try this and will get back in case it works..
Regards Tapan Thapa On Mon, Apr 11, 2011 at 8:11 PM, ojonam <[email protected]> wrote: > Hi, > > this is because Oracle has a list of reserved keywords (like "User") which > make your query impossible to deal with for Oracle. The full list is > available here : > http://download.oracle.com/docs/cd/B10500_01/appdev.920/a42525/apb.htm. > This means that you cannot use the term 'User' directly in a query. Your > option is to create an alias for the user model. In the model/user.php file, > add the following: > > class User extends AppModel { > var $name = 'User'; > var $alias = 'Mem'; > > Hope this helps! > > PS: your error is actually an Oracle SQL error. Try using SQLDeveloper or > some other client to test these queries independently of cake. > > -- > 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 > [email protected] For more options, visit this group > at http://groups.google.com/group/cake-php > -- 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
