Hi,
I have pasted the app code at:
http://bin.cakephp.org/view/409355633
and the sql schema at:
http://bin.cakephp.org/view/305474219
I did experiment with the table structure you have suggested (id, fk,
fk). In that case the query that is generated selects
bid_session_registrations.id, which works, but I don't get the
bid_session_id & user_id which I'd expect from find('list').
The 'problems' that have surfaced can be 'solved' simply changing the
code manually, I am just wondering why the magic doesn't work in my
case :).
On Aug 20, 11:33 pm, "Jon Bennett" <[EMAIL PROTECTED]> wrote:
> Hi amitava,
>
> >> Nope, your can not use composite keys with cakephp, you have to have
> >> an ID (or a field that you use as the primary, auto-incrementing id) -
> >> search the group for more background on this.
>
> > I was under the impression that habtm join tables don't need to have a
> > separate 'id' PK if you're not going to have a Model for it ... the
> > manual also states that "The contents of the table should be at least
> > two fields, each foreign keys (which should be integers) pointing to
> > both of the primary keys of the involved models."
>
> yes, but ALL tables have to have an auto incrementing field as well,
> so you need:
>
> id
> foreign_key
> foreign_key
>
> > Anyway, as I said earlier, I also used a modified table with an id
> > field ... in this case find() generates the SQL query "SELECT
> > `BidSessionRegistration`.`id` FROM `bid_session_registrations` AS
> > `BidSessionRegistration` WHERE 1 = 1", but shouldn't the code be
> > querying for user_id and bid_session_id?
> > What _does_ help is explicitly passing the query fields, like so:
> > $this->User->BidSessionRegistration->find('list', array('fields' =>
> > array('bid_session_id','user_id'))) ... but why shouldn't $this->User-
> >>BidSessionRegistration->find('list') work? That is more intuitive ...
> > and that is why I wonder where I am making a mistake!
>
> I'm really struggling to follow your code in gmail, could you post
> your models, controller and view tohttp://bin.cakephp.org/add/eleven10- might
> help to get you DB as
> well.
>
>
>
> >> make sure you define your associations in alphabetical order,
> >> scaffolding can be quite picky about that (least it was last time I
> >> used it, though that was some time ago!).
>
> > I am not sure I get your point ... are you talking about the order of
> > defining models in the bake script? (I defined them in the order
> > BidSession, User, Bid) ... or should I be looking in the respective
> > model classes? I know I am breaking the naming convention for the
> > habtm join table, but in this case the name 'registrations' sounds
> > better ... and I have mentioned the joinTable in both the User and
> > BidSession models ...
>
> sorry, I didn't mean alphabetical order - I mean this. You have to
> make the sure the order of your foreign keys matches the order of
> association declarations in your model classes.
>
> Also, it's much easier to stick to the conventions...
>
> cheers,
>
> jon
>
> --
>
> jon bennett
> w:http://www.jben.net/
> iChat (AIM): jbendotnet Skype: jon-bennett
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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
-~----------~----~----~----~------~----~------~--~---
