I had a similar problem while using adodb driver and odbc_mssql. While
using mysql worked ok.
What driver are you using?
On Feb 6, 1:48 pm, TracyB <[EMAIL PROTECTED]> wrote:
> 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 [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
-~----------~----~----~----~------~----~------~--~---
