Hello Manoj, I can confirm that after putting alias, i am able to login with oracle database. However in my login page after putting alias i am getting some notice and warning.
*Notice* (8): Trying to get property of non-object [*CORE\cake\libs\view\helper.php*, line *458*] *Warning* (2): array_keys() expects parameter 1 to be array, null given [*CORE\cake\libs\view\helper.php*, line *458*] *Warning* (2): in_array() expects parameter 2 to be array, null given [*CORE\cake\libs\view\helper.php*, line *458*] Can you please suggest how to resolve this issue? Regards Tapan Thapa On Mon, Apr 11, 2011 at 8:33 PM, Tapan Kumar Thapa < [email protected]> wrote: > 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
