So what exactly is the problem? Also is state an association of user or the
post?
The state is associated with the User only.

The problem is I do not need all the information the post is returning in
the pagination. 

SELECT `Post`.`id`, `Post`.`user_id`, `Post`.`contact_first`,
`Post`.`contact_last`, `Post`.`contact_phone`, `Post`.`contact_cell`,
`Post`.`contact_email`,  `Post`. `Post`.`title`, `Post`.`description`,
`Post`.`rank`, `Post`.`status`, `Post`.`created`, `Post`.`modified`,
`Post`.`expires`,.......and so on

I just want the 3 fields 

Yes abrev is the column in the table with the State abreviations for each
state.

    

-----Original Message-----
From: Miles J [mailto:[email protected]] 
Sent: April-13-09 1:09 AM
To: CakePHP
Subject: Re: Value from record


You would have to add another column in the state table. But im guessing
thats what abrev, is for.

I also dont see how echoing the state_id outputs California, can I see your
code?


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to