On Feb 9, 2:03 am, Kris <[EMAIL PROTECTED]> wrote:
> So, I've been pulling my hair out trying to figure out how to do this,
> reading everything on pagination in CakePHP 1.2...
>
> So here's a quick explanation of my setup, then I'll explain what
> effect I want to achieve.
>
> I have a table of items which looks something like (this is
> simplified):
>
> --- items -------------------------------
> | id | name | description | price |
> -------------------------------------------
> | 5 | test | some desc | 2.50 |
> --------------------------------------------
>
> Then there's a table called descriptors (other useful things to
> describe items):
>
> --- descriptors ----
> | id | name | |
> -----------------------
> | 1 | color | |
> -----------------------
>
> Then the join table or what have you (this is part of the kicker):
> --- descriptors_items --------------------
> | id | item_id | descriptor_id | value |
> ------------------------------------------------
> | 1 | 5 | 1 | blue |
> ------------------------------------------------
>
> What I want to be able to do is create extra descriptors for items
> that function as table headers in the view ultimately. This way, for
> instance, I could have items sorted by color in a table. Later, if I
> need an additional way to describe a product (like size), I can just
> create another descriptor and be done with it. No table editing.
>
> I figured out how to get the "value" field from the join table with
> some array mucking around at Mariano's site:
>
> http://cricava.com/blogs/index.php?blog=6&title=modelizing_habtm_join...
>
> As well as how to sort by HABTM at :
>
> http://www.littlehart.net/atthekeyboard/2007/12/11/cakephp-pagination...
>
> What the latter site seems to buy me is being able to sort items that
> have the same Tag, rather than using the tag name as an actual
> clickable field.
>
> I recall reading somewhere about being able to swap columns for rows
> in SQL, through some sort of crazy join I imagine. Will I ultimately
> end up needing to create a SQL view of my data like this and modelize
> it? It would be great if there's a CakePHP way to do it.
>
> Thanks for your time,
> -Kris
There's nothing in cake specific to your example, but I don't recall
seeing anything like your example anywhere. If you know the sql you
need and can't get it to work in Cake this is the right place to ask
but otherwise I think some thinking/researching is required first ;).
AD
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
