I'm trying to go through the Example: Simple User Authentication in the CakePHP manual, to learn how to set up my own authentication for a website. The database that I have to use for authentication is a legacy Access database, and I have connected to it successfully with Cake already. For some reason, when I try to login, the query that gets generated is a little screwy.
It generates: SELECT "User"."AccName" AS "User__AccName" AS "User"__"AccName" AS "User__AccName", "User"."AccPass" AS "User__AccPass" AS "User"__"AccPass" AS "User__AccPass", "User"."FirstName" AS "User__FirstName" AS "User"__"FirstName" AS "User__FirstName", "User"."Surname" AS "User__Surname" AS "User"__"Surname" AS "User__Surname", "User"."ContactID" AS "User__ContactID" FROM "registrar" AS "User" WHERE "User"."acc_name" = 'dev' LIMIT 1 I don't understand why it's repeating the "AS" so many times, I haven't seen that before in any of the generated queries. My model is fairly simple: class User extends AppModel { var $name = 'User'; var $useTable = 'registrar'; var $primaryKey = 'ContactID'; var $useDbConfig = 'orderflow'; var $hasMany = 'Order'; } Is there something remarkably stupid that I'm doing that I'm just not aware of? Thanks, Tracy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---