Sorry... something like this should work:
'conditions' => array('NOT' => array('Model.fieldname' => array(5',
'6', 7')))
Should create something like NOT (Model.fieldname IN (5,6,7))
Lookup the book on cakephp.org for Complex Find Conditions
On Apr 19, 8:42 am, mivogt-LU <c...@mivogt.net> wrote:
> 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 sitehttp://cakeqs.organd 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 cake-php@googlegroups.com
> To unsubscribe from this group, send email to
> cake-php+unsubscr...@googlegroups.com For more options, visit this group
> athttp://groups.google.com/group/cake-php?hl=en
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 cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
