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
