Well, i really don't think it needs to have the same field aliased 3
times to the same name. That is what is causing access to choke.
I'm fairly sure it would be better for 'SELECT "User"."AccName" AS
"User__AccName" AS
"User"__"AccName" AS "User__AccName",' to just use the AS once, rather
than 3 times.
Again, the repeated AS is causing the choke, I'm just trying to find
out where that repetition is coming from.
Tracy
On Feb 6, 11:20 am, grigri <[EMAIL PROTECTED]> wrote:
> This isn't a bug, or even a problem.
>
> Cake unifies all database systems with a consistent API. When
> returning result sets, certain database systems (like mysql) identify
> the originating table for each field, whereas others don't.
>
> CakePHP needs that information to decide which array to place the
> result field in, for queries using joins.
>
> If the database does not support retrieving the table information,
> cake fakes it by imposing a certain format on the field aliases
> (Table__field) and extracts them later. You never see the aliases
> except in the SQL log.
>
> Bottom line: leave it be, it's supposed to be like this.
>
> On Feb 6, 4:06 pm, hellfish <[EMAIL PROTECTED]> wrote:
>
> > Right now I'm going forward using mysql, but my company only provides
> > sql server so it's going to be interesting in a few days.
>
> > I wasn't able to find any fixes to that problem.
>
> > On Feb 6, 3:15 pm, TracyB <[EMAIL PROTECTED]> wrote:
>
> > > this is under the adodb driver for access. I have another model using
> > > an access database, and that one doesn't seem to be doing this. did
> > > you find a fix, or did you just switch to a different database?
>
> > > On Feb 6, 10:14 am, hellfish <[EMAIL PROTECTED]> wrote:
>
> > > > 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
-~----------~----~----~----~------~----~------~--~---
