It just happens on this one, and I'm wondering if it has to do with
the fact that i'm using a legacy database, so my User model is
actually using the table Registrar. I was just wondering if maybe it's
caused somehow by it being an access database and having the $useTable
set. Perhaps a bug in the adodb driver in that particular situation or
something.
I don't actually have any other models on the exact same database,
though i have another model running off a different access database
table, and that one doesn't cause any problems.
On Feb 6, 11:36 am, grigri <[EMAIL PROTECTED]> wrote:
> Oops, yes, you're right. I was seeing commas where there weren't any.
> Reading too fast, I suppose. Sorry.
>
> The aliasing is normally handled in the specific datasource class [for
> the database type]
>
> Does this happen for any other models/tables on the same database, or
> just this one?
>
> On Feb 6, 4:24 pm, TracyB <[EMAIL PROTECTED]> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
