Ok. Now I think I understand what you're trying to obtain. Please tell me again your problem.
Best regards! On Thu, Feb 16, 2012 at 4:10 AM, Sean <[email protected]> wrote: > Thanks for the reply, Florin. > > Auction hasMany AuctionImages is the way that it is currently set. The > problem is that it currently "uses up" any AuctionImage that is > associated with the Auction. Each image is associated with a > particular auction_id. > > What I'm looking for is a way to have a set of images that I then > associate with numerous auctions. That is multiple images with > multiple auctions (e.g. 6 images for a single item type and then > associate them with multiple auctions). > > In addition to the structure that I'm attempting in the Models, here > is the current structure of the database tables: > > auctions: > Column Type > 1 id int(11) (AUTO INCREMENT) > 2 title varchar(255) > 5 description text > 6 category_id int(11) > .... > 26 created datetime > 27 modified datetime > > Keyname Type Unique Column > PRIMARY BTREE Yes id > category_id BTREE No category_id > > auction_images: > 1 id int(8) UNSIGNED > AUTO_INCREMENT > 2 auction_id int(11) > 3 image varchar(255) > 4 order int(11) > 5 created datetime > 6 modified datetime > > Keyname Type Unique Column > PRIMARY BTREE Yes id > auction_id BTREE No auction_id > > > Join table - auctions_auction_images > 1 id int(11) AUTO_INCREMENT > 2 auction_id int(11) > 3 auction_image_id int(11) > 4 order int(1) > > Keyname Type Unique Column > PRIMARY BTREE Yes id > auction_id BTREE No auction_id > auction_image_id BTREE No auction_image_id > > I hope this help clear up what I am looking for. > > Thanks, > Sean > > On Feb 15, 5:33 pm, Florin Trifu <[email protected]> > wrote: > > Hi > > > > I don't know if my understanding is correct, but Auction hasMany > > AuctionImages and not HABTM. > > You should try to change that hasAndBelongsTo from the Auction model, of > > which I've never heard by the way, into hasMany. > > > > As by the error following the pattern "model_name_X is not associated > with > > model_name_X" usually appears in this case: > > > > Let's take for example you Image model: > > > > - you use $actsAs = array('Containable') > > - then you pass an array following this pattern into a query > interrogating > > the Image model: > > > > array('contain' => array('Image' [,'model_name'])) > > > > Hope it's useful! > > > > Best regards! > > > > > > > > > > > > > > > > On Wed, Feb 15, 2012 at 10:40 PM, Sean <[email protected]> wrote: > > > Hi all, > > > > > I am trying to do something that I think is pretty common. > > > > > I am working on an auction site and if I had say a auctions table and > > > a auction_images table. I want to be able to use multiple images with > > > multiple auctions. > > > > > In other words - auction1 be associated with auction_image 1, 2, 3 & > > > auction2 be associated with 1, 2, 3 > > > > > When I use a $belongsTo relationship from Users to Images it works > > > fine, but that limits things to haveing specific images directly > > > linked to image id's (effectively "using up" the associated images). > > > > > I thought that the HABTM direction was the way to go, but am having a > > > problem with it. But when I use HABTM, I get an error that the model > > > images is not associated with the model images. I believe that I have > > > followed the book.cakephp directions and Josh Benner's directions but > > > it's not working. > > > > > Here are the model's: > > > > > Auction Model: > > > class Auction extends AppModel { > > > > > var $name = 'Auction'; > > > > > var $actsAs = array('Containable'); > > > > > var $belongsTo = array( > > > 'Category' => array( > > > 'className' => 'Category', > > > 'foreignKey' => 'category_id' > > > ), > > > 'Status' => array( > > > 'className' => 'Status', > > > 'foreignKey' => 'status_id' > > > ), > > > 'Winner' => array( > > > 'className' => 'User', > > > 'foreignKey' => 'winner_id' > > > ) > > > ); > > > > > var $hasMany = array( > > > 'Bidbutler' => array( > > > 'className' => 'Bidbutler', > > > 'foreignKey' => 'auction_id', > > > 'limit' => 10, > > > 'dependent' => true > > > ), > > > > > 'Bid' => array( > > > 'className' => 'Bid', > > > 'foreignKey' => 'auction_id', > > > 'order' => 'Bid.id DESC', > > > 'limit' => 10, > > > 'dependent' => true > > > ), > > > > > 'Autobid' => array( > > > 'className' => 'Autobid', > > > 'foreignKey' => 'auction_id', > > > 'limit' => 10, > > > 'dependent' => true > > > ) > > > ); > > > > > var $hasAndBelongsTo = array( > > > 'AuctionImage' => > > > array( > > > 'className' => > > > 'AuctionImage', > > > 'joinTable' > => > > > 'auctions_auction_images', > > > 'foreignKey' > => > > > 'auction_id', > > > 'associationForeignKey' => > > > 'auction_image_id', > > > 'unique' > => > > > false, > > > 'limit' > > > => '6', > > > 'order' > > > => array('order' => 'asc'), > > > ), > > > ); > > > > > AuctionImages Model: > > > > > class AuctionImage extends AppModel { > > > > > var $name = 'AuctionImage'; > > > > > var $hasAndBelongsToMany = array( > > > 'Auction' => array( > > > 'className' => > 'Auction', > > > 'joinTable' => > > > 'auctions_auction_images', > > > 'foreignKey' => > > > 'auction_image_id', > > > 'associationForeignKey' => > 'auction_id', > > > 'unique' => > false, > > > 'limit' => > '6' > > > > > ) > > > ); > > > > > I'm not sure how the controller language is supposed to look but an > > > example of the auction_image language would be: > > > > > $auction = $this->AuctionImage->Auction->read(null, $auction_id); > > > > > -- > > > Our newest site for the community: CakePHP Video Tutorials > > >http://tv.cakephp.org > > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help > > > others with their CakePHP related questions. > > > > > To unsubscribe from this group, send email to > > > [email protected] For more options, visit this > group > > > athttp://groups.google.com/group/cake-php > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > [email protected] For more options, visit this group > at http://groups.google.com/group/cake-php > -- Florin Trifu Mobile: +40 728 300 750 -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
