Wordpress integration - retrieve posts by tag

Having a nightmare of a time trying to retrieve posts by tag while
integrating wordpress.

Here is an outline of the wonderful wordpress schema:

wp_posts
------------
ID

wp_term_relationships
--------------------------------
object_id FK that references wp_posts.ID
term_taxonomy_id FK that references
wp_term_taxonomy.term_taxonomy_id

wp_term_taxonomy
----------------------------
term_taxonomy_id PK
term_id FK that references wp_terms.term_id

wp_terms
--------------
term_id PK
name <----- This is the tag that I want to filter
by

OK, now if you can wrap your head around that clever schema....

Now for example purposes I am going to the URL mysite.com/posts which
will call the index action
Index will use the model 'wp_posts' by specifying var $uses = array
('wp_posts'); and then I set up all my associations and everything
should work sweetly, but it doesn't.

The app completely ignores the 'foreignKey' and
'associationForeignKey' when using var $recursive = '2';

If I try and do things the other way around using var $uses = array
('wp_terms'); it also ignores 'foreignKey' and 'associationForeignKey'
and if I try to replace this with 'condition' => 'wp_terms.term_id =
wp_term_taxonomy.term_id ' it breaks when using var $recursive = '2';

I've tried every possible combination of var $uses = array
('tablename'); and different directional relationships but none of
them seem to work. I'm sure I can't be the only person who has
integrated wordpress into cakephp (I've read through other articles so
please don't point me in that direction)

cakephp please don't let me down, everything else works so well!!!!

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---