HI there, I want to use find() to exlude some data on a few conditions.
My app is built like this customer->request->booking->bookingposition->lodging with request fields: Id Name Customer Date1/Date2 (date1,2 arrival,leave requested) with booking fields: Id Name Customer Mealclass Request with bookingpositionfields: Id Booking Date1/Date2 Lodging (date1,2 arrival,leave booked) *) I use 2 times a date fieldset if a customer might ask for a period he want to visit but do booking only a part of it (i.e. wants to visit in april staying 1 week...) Now if I do add a booking position to a customers booking the usual way is getting full the lodgings list from conroller by find(list). My goal is to exclude those that are already in use (should be easy to agree I need to do so..) With mysql I found 'NOT IN' syntax to fit my needs if I do something like this 1.) select * from bookingpositions, bookings, lodgings .. fittinng ore close the time of the new booking 2.) select * from lodgings not in result of 1.) Is there a way to do similar using the cake built in find function? Some syntax help would be great as I am not realy advanced with the conditions array Thanks in advance Michael Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
